/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50612 Source Host : localhost:3306 Source Database : leipi_formdesign Target Server Type : MYSQL Target Server Version : 50612 File Encoding : 65001 Date: 2014-08-09 23:03:47 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `leipi_foreign_test` -- ---------------------------- DROP TABLE IF EXISTS `leipi_foreign_test`; CREATE TABLE `leipi_foreign_test` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `form_id` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', `dateline` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of leipi_foreign_test -- ---------------------------- INSERT INTO `leipi_foreign_test` VALUES ('13', '52', '32333', '0', '1407556818', '1407338095'); INSERT INTO `leipi_foreign_test` VALUES ('14', '52', '55555', '0', '1407557049', '1407556896'); -- ---------------------------- -- Table structure for `leipi_form` -- ---------------------------- DROP TABLE IF EXISTS `leipi_form`; CREATE TABLE `leipi_form` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `form_name` varchar(255) NOT NULL DEFAULT '' COMMENT '表单名称', `form_desc` varchar(255) NOT NULL DEFAULT '' COMMENT '表单描述', `content` text NOT NULL COMMENT '表单原html模板未经处理的', `content_parse` text NOT NULL COMMENT '表单替换的模板 经过处理', `content_data` text NOT NULL COMMENT '表单中的字段数据', `fields` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '字段总数', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'is_del', `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间', `dateline` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of leipi_form -- ---------------------------- INSERT INTO `leipi_form` VALUES ('52', '示例表', '示例', '


示例表

文本框下拉菜单{|-  -|}
单选{|-单选2 单选1 -|}复选{|-复选2 复选1 复选3 -|}
宏控件二维码

', '


示例表

文本框{data_12}下拉菜单{data_13}  
单选{data_14}复选{checkboxs_0}
宏控件{data_18}二维码{data_19}

{data_20}

{data_21}

', 'a:8:{i:0;a:12:{s:5:\"style\";s:31:\"text-align: left; width: 150px;\";s:5:\"title\";s:9:\"文本框\";s:5:\"value\";s:9:\"雷劈网\";s:4:\"name\";s:7:\"data_12\";s:9:\"orgheight\";s:0:\"\";s:8:\"orgwidth\";s:3:\"150\";s:8:\"orgalign\";s:4:\"left\";s:11:\"orgfontsize\";s:0:\"\";s:7:\"orghide\";s:1:\"0\";s:12:\"leipiplugins\";s:4:\"text\";s:7:\"orgtype\";s:4:\"text\";s:7:\"content\";s:205:\"\";}i:1;a:8:{s:4:\"name\";s:7:\"data_13\";s:5:\"title\";s:12:\"下拉菜单\";s:12:\"leipiplugins\";s:6:\"select\";s:4:\"size\";s:1:\"1\";s:8:\"orgwidth\";s:3:\"150\";s:5:\"style\";s:13:\"width: 150px;\";s:5:\"value\";s:13:\"下拉,菜单\";s:7:\"content\";s:197:\"\";}i:2;a:7:{s:12:\"leipiplugins\";s:6:\"radios\";s:4:\"name\";s:7:\"data_14\";s:5:\"title\";s:6:\"单选\";s:10:\"orgchecked\";s:11:\"orgchecked0\";s:5:\"value\";s:15:\"单选2,单选1\";s:7:\"content\";s:206:\"单选2 单选1 \";s:7:\"options\";a:2:{i:0;a:4:{s:4:\"name\";s:7:\"data_14\";s:5:\"value\";s:7:\"单选2\";s:7:\"checked\";s:7:\"checked\";s:4:\"type\";s:5:\"radio\";}i:1;a:3:{s:4:\"name\";s:7:\"data_14\";s:5:\"value\";s:7:\"单选1\";s:4:\"type\";s:5:\"radio\";}}}i:3;a:8:{s:12:\"leipiplugins\";s:9:\"checkboxs\";s:5:\"title\";s:6:\"复选\";s:10:\"orgchecked\";s:11:\"orgchecked0\";s:10:\"parse_name\";s:11:\"checkboxs_0\";s:4:\"name\";s:23:\"data_16,data_15,data_17\";s:5:\"value\";s:23:\"复选2,复选1,复选3\";s:7:\"content\";s:267:\"复选2 复选1 复选3 \";s:7:\"options\";a:3:{i:0;a:3:{s:4:\"name\";s:7:\"data_16\";s:5:\"value\";s:7:\"复选2\";s:4:\"type\";s:8:\"checkbox\";}i:1;a:4:{s:4:\"name\";s:7:\"data_15\";s:5:\"value\";s:7:\"复选1\";s:7:\"checked\";s:7:\"checked\";s:4:\"type\";s:8:\"checkbox\";}i:2;a:3:{s:4:\"name\";s:7:\"data_17\";s:5:\"value\";s:7:\"复选3\";s:4:\"type\";s:8:\"checkbox\";}}}i:4;a:11:{s:4:\"name\";s:7:\"data_18\";s:4:\"type\";s:4:\"text\";s:5:\"value\";s:8:\"{macros}\";s:5:\"title\";s:9:\"宏控件\";s:12:\"leipiplugins\";s:6:\"macros\";s:7:\"orgtype\";s:11:\"sys_date_cn\";s:7:\"orghide\";s:1:\"0\";s:11:\"orgfontsize\";s:2:\"12\";s:8:\"orgwidth\";s:3:\"150\";s:5:\"style\";s:30:\"font-size: 12px; width: 150px;\";s:7:\"content\";s:197:\"\";}i:5;a:10:{s:4:\"name\";s:7:\"data_19\";s:5:\"title\";s:9:\"雷劈网\";s:5:\"value\";s:20:\"http://www.leipi.org\";s:7:\"orgtype\";s:3:\"url\";s:12:\"leipiplugins\";s:6:\"qrcode\";s:3:\"src\";s:47:\"/Public/js/ueditor/formdesign/images/qrcode.gif\";s:8:\"orgwidth\";s:2:\"40\";s:9:\"orgheight\";s:2:\"40\";s:5:\"style\";s:26:\"width: 40px; height: 40px;\";s:7:\"content\";s:222:\"\";}i:6;a:10:{s:5:\"title\";s:12:\"多行文本\";s:4:\"name\";s:7:\"data_20\";s:12:\"leipiplugins\";s:8:\"textarea\";s:5:\"value\";s:0:\"\";s:7:\"orgrich\";s:1:\"0\";s:11:\"orgfontsize\";s:2:\"12\";s:8:\"orgwidth\";s:3:\"600\";s:9:\"orgheight\";s:2:\"80\";s:5:\"style\";s:39:\"font-size:12px;width:600px;height:80px;\";s:7:\"content\";s:197:\"\";}i:7;a:7:{s:4:\"name\";s:7:\"data_21\";s:5:\"title\";s:9:\"进度条\";s:12:\"leipiplugins\";s:11:\"progressbar\";s:8:\"orgvalue\";s:2:\"20\";s:11:\"orgsigntype\";s:13:\"progress-info\";s:3:\"src\";s:52:\"/Public/js/ueditor/formdesign/images/progressbar.gif\";s:7:\"content\";s:167:\"\";}}', '21', '0', '1407556981', '1407338057'); -- ---------------------------- -- Table structure for `leipi_form_data_52` -- ---------------------------- DROP TABLE IF EXISTS `leipi_form_data_52`; CREATE TABLE `leipi_form_data_52` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `uid` int(10) unsigned NOT NULL DEFAULT '0', `foreign_id` int(10) unsigned NOT NULL DEFAULT '0', `data_1` varchar(255) NOT NULL DEFAULT '', `data_2` varchar(255) NOT NULL DEFAULT '', `data_3` varchar(255) NOT NULL DEFAULT '', `data_5` varchar(255) NOT NULL DEFAULT '', `data_6` varchar(255) NOT NULL DEFAULT '', `data_7` varchar(255) NOT NULL DEFAULT '', `data_8` varchar(255) NOT NULL DEFAULT '', `data_9` varchar(255) NOT NULL DEFAULT '', `data_10` text NOT NULL, `data_11` varchar(255) NOT NULL DEFAULT '', `is_del` tinyint(1) unsigned NOT NULL DEFAULT '0', `updatetime` int(10) unsigned NOT NULL DEFAULT '0', `dateline` int(10) unsigned NOT NULL DEFAULT '0', `data_12` varchar(255) NOT NULL DEFAULT '', `data_13` varchar(255) NOT NULL DEFAULT '', `data_14` varchar(255) NOT NULL DEFAULT '', `data_15` tinyint(1) unsigned NOT NULL DEFAULT '0', `data_16` tinyint(1) unsigned NOT NULL DEFAULT '0', `data_17` tinyint(1) unsigned NOT NULL DEFAULT '0', `data_18` varchar(255) NOT NULL DEFAULT '', `data_19` varchar(255) NOT NULL DEFAULT '', `data_20` text NOT NULL, `data_21` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `uid` (`uid`), KEY `foreign_id` (`foreign_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of leipi_form_data_52 -- ---------------------------- INSERT INTO `leipi_form_data_52` VALUES ('1', '0', '13', '雷劈网', '菜单', '单选2', '0', '1', '1', '2014年8月7日', 'a:2:{s:5:\"value\";s:28:\"http://formdesign.leipi.org/\";s:10:\"qrcode_url\";s:45:\"/Uploads/90e1157fb525881f97148e8e9740ed5e.png\";}', '夺3333', '50', '0', '1407556818', '1407338095', '2222', '下拉', '单选2', '1', '0', '1', '2014年8月9日', 'a:2:{s:5:\"value\";s:3:\"333\";s:10:\"qrcode_url\";s:45:\"/Uploads/310dcbbf4cce62f762a2aaa148d556bd.png\";}', '顶替', '20'); INSERT INTO `leipi_form_data_52` VALUES ('2', '0', '14', '', '', '', '', '', '', '', '', '', '', '0', '1407557049', '1407556896', '雷劈网5', '菜单', '单选2', '1', '0', '1', '2014年8月8日', 'a:2:{s:5:\"value\";s:20:\"http://form/index.ph\";s:10:\"qrcode_url\";s:45:\"/Uploads/1a4363a0562a619d95fa661d80c19e01.png\";}', '顶替333333', '50');