Drop Table sl_adsqlnextsqlCREATE TABLE [$Prefix$ad] ([dtime] datetime default now(), [id] autoincrement(1,1), [overtime] varchar, [u1] varchar, [u2] varchar, [u3] text, [u4] varchar, [u5] text, [u6] text)sqlnextsqlDrop Table sl_adminsqlnextsqlCREATE TABLE [$Prefix$admin] ([id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] text, [u4] datetime default now())sqlnextsqlinsert into [$Prefix$admin] ([id],[u1],[u2],[u3],[u4]) values(1,'cdsile','01AC3D95A020811609CEEF9ED8336E2E','','2013/5/31 10:40:40')sqlnextsqlDrop Table sl_collectsqlnextsqlCREATE TABLE [$Prefix$collect] ([dtime] datetime default now(), [id] autoincrement(1,1), [u1] varchar, [u10] text, [u11] varchar, [u12] text, [u13] text, [u14] text, [u15] varchar, [u16] varchar, [u17] varchar, [u18] int default 0, [u19] varchar, [u2] varchar, [u3] varchar, [u4] varchar, [u5] varchar, [u6] varchar, [u7] text, [u8] text, [u9] text)sqlnextsqlDrop Table sl_ColumnssqlnextsqlCREATE TABLE [$Prefix$Columns] ([classid] int default 0, [id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] varchar, [u4] varchar)sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(0,1,'内容管理','2','','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(0,4,'用户管理','1','','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(4,7,'管理员管理','','admin_table.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(0,8,'系统管理','2','','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(8,9,'参数管理','','Parameter.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(8,10,'系统日志','','Web_Blog.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(0,11,'扩展管理','2','','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(11,12,'广告管理','','Ad_Table.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(8,13,'网站配置','','Config.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(8,30,'模型管理','','Model.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(0,31,'采集管理','1','','隐藏')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(31,32,'新增采集项目','','collect_edit.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(31,33,'采集项目管理','','collect_list.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(0,36,'生成管理','1','','隐藏')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(36,37,'生成静态页面','','Generate.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(36,38,'一键生成','','Generates.aspx?type=all','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(1,71,'单页面管理','','shop_Single.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(11,83,'配置管理','','peizhi_table.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(11,108,'SQL server','','sql_back.aspx','显示')sqlnextsqlDrop Table sl_FieldsqlnextsqlCREATE TABLE [$Prefix$Field] ([id] autoincrement(1,1), [Model_id] int default 0, [u1] varchar, [u10] varchar, [u11] varchar, [u12] varchar, [u2] varchar, [u3] varchar, [u4] varchar, [u5] varchar, [u6] text, [u7] text, [u8] text, [u9] int default 0)sqlnextsqlDrop Table sl_ModelsqlnextsqlCREATE TABLE [$Prefix$Model] ([id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] text, [u4] varchar, [u5] varchar, [u6] varchar, [u7] varchar, [u8] varchar)sqlnextsqlDrop Table sl_ParametersqlnextsqlCREATE TABLE [$Prefix$Parameter] ([classid] int default 0, [id] autoincrement(1,1), [u1] varchar, [u2] text, [u3] int default 0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,2,'字段类型','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,3,'文本框','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,4,'文本域','',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,5,'编辑器','',2)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,6,'文件框','数量：0
格式：*',3)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,8,'下拉框','',4)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,9,'单选按钮组','',5)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,10,'多选按钮组','',6)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,11,'模型类型','',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(11,12,'文章模型','articles.aspx',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,13,'数字','',7)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,14,'密码框','',8)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,15,'过滤标签','',2)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,29,'缩略图','数量：0
格式：*',9)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,30,'时间框','',10)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,31,'过滤HTML标签 （剩下纯文字）','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,32,'a： 过滤链接 （字留下，链接去掉）','',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,33,'a： 过滤链接','',2)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,34,'font： 过滤字体样式 （字留下，样式去掉）','',3)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,35,'img ： 过滤图片','',4)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,36,'过滤表格属性（字留下，表格属性去掉）','',5)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,37,'过滤表格属性','',6)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,38,'span： 过滤行内元素span容器（保留内容）','',7)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,39,'span： 过滤行内元素span容器','',8)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,40,'class： 过滤类名','',9)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,41,'style： 过滤样式','',10)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,42,'div： 过滤层（保留内容）','',11)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,43,'div： 过滤层','',12)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,44,'script： 过滤js，vbs等脚本','',13)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,45,'Object：过滤Flash，控件等','',14)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(15,46,'iframe： 过滤内联页','',15)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,47,'关键字属性','',3)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(47,50,'推荐','',2)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(11,51,'表单模型','auto_table.aspx',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,52,'多选下拉框','',11)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,53,'组图','',12)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,61,'二级联动','',13)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,62,'三级联动','',14)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,82,'订单状态','',5)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(82,83,'下单成功','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(82,84,'送单完成','',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(82,85,'送单未完成','',2)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(82,86,'未付款','',3)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(82,87,'已付款','',4)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(82,88,'已取消','',5)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,89,'支付方式','',6)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(89,90,'门店支付','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(89,91,'网银支付','',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(89,92,'微信支付','',2)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,120,'货币','',15)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,133,'子编辑器','',16)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(11,134,'商品模型','produts.aspx',2)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(11,135,'订单模型','order_table.aspx',3)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,136,'头像','',17)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,137,'三级城市','',18)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,155,'配置分类','',10)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(155,156,'补充','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(155,157,'规格','',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,158,'颜色','',19)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,159,'标题','',20)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(89,160,'支付宝','',3)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(89,161,'会员卡支付','',4)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(89,162,'货到付款','',5)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,163,'订单类型','',11)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(163,164,'线上','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(163,165,'门店','',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,166,'编号','',21)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(11,167,'自定义模型（短信）','duanxin_table.aspx',4)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(0,169,'物流公司','',11)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(169,170,'圆通速递','yuantong',12)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(169,171,'韵达快递','yunda',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(82,181,'订单关闭','',6)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,182,'相关选择','',22)sqlnextsqlDrop Table sl_peizhisqlnextsqlCREATE TABLE [$Prefix$peizhi] ([classid] int default 0, [id] autoincrement(1,1), [leixing] varchar, [u1] varchar, [u2] varchar, [u3] text, [u4] int default 0)sqlnextsqlDrop Table sl_SinglesqlnextsqlCREATE TABLE [$Prefix$Single] ([dtime] datetime default now(), [id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] varchar, [u4] varchar, [u5] text, [u6] varchar, [u7] varchar)sqlnextsqlDrop Table sl_sortsqlnextsqlCREATE TABLE [$Prefix$sort] ([id] autoincrement(1,1), [Model_id] int default 0, [paixu] int default 0, [Sort_id] int default 0, [type] varchar, [u1] varchar, [u10] varchar, [u2] varchar, [u3] varchar, [u4] varchar, [u5] varchar, [u6] varchar, [u7] varchar, [u8] varchar, [u9] text)sqlnextsqlDrop Table sl_systemsqlnextsqlCREATE TABLE [$Prefix$system] ([dtime] datetime default now(), [id] autoincrement(1,1), [u1] varchar, [u2] text, [u3] varchar, [u4] varchar)sqlnextsql