﻿Drop Table sl_FieldsqlnextsqlCREATE TABLE [$Prefix$Field] ([id] autoincrement(1,1), [Model_id] int default 0, [u1] varchar, [u10] varchar, [u11] varchar, [u2] varchar, [u3] varchar, [u4] varchar, [u5] varchar, [u6] text, [u7] text, [u8] text, [u9] int default 0)sqlnextsqlDrop Table sl_keysqlnextsqlCREATE TABLE [$Prefix$key] ([dtime] datetime default now(), [id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] varchar, [u4] int default 0)sqlnextsqlDrop Table sl_linksqlnextsqlCREATE TABLE [$Prefix$link] ([id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] varchar, [u4] varchar, [u5] varchar, [u6] varchar)sqlnextsqlinsert into [$Prefix$link] ([id],[u1],[u2],[u3],[u4],[u5],[u6]) values(1,'成都思乐科技','http://www.cdsile.com','','','首页','0')sqlnextsqlDrop Table sl_ModelsqlnextsqlCREATE TABLE [$Prefix$Model] ([id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] text)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,48,'美女模特','',0)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(47,49,'美女写真','',1)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,'表单模型','Operationform.aspx',1)sqlnextsqlinsert into [$Prefix$Parameter] ([classid],[id],[u1],[u2],[u3]) values(2,52,'多选下拉框','',11)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, [Sort_id] int default 0, [u1] varchar, [u2] varchar, [u3] varchar, [u4] varchar, [u5] varchar, [u6] varchar, [u7] varchar, [u8] varchar)sqlnextsqlDrop Table sl_systemsqlnextsqlCREATE TABLE [$Prefix$system] ([dtime] datetime default now(), [id] autoincrement(1,1), [u1] varchar, [u2] text, [u3] varchar, [u4] varchar)sqlnextsqlinsert into [$Prefix$system] ([dtime],[id],[u1],[u2],[u3],[u4]) values('2010-11-11 16:35:06',24,'cdsile','此管理员（cdsile）登陆成功!操作页面http://localhost:81/admin/login.aspx','127.0.0.1','管理员登陆')sqlnextsqlDrop Table up_tablesqlnextsqlCREATE TABLE [up_table] ([id] autoincrement(1,1), [file_path] varchar, [up_path] varchar, [contents] varchar, [dtime] datetime default now())sqlnextsqlinsert into [up_table] ([id],[file_path],[up_path],[contents],[dtime]) values(1,'/upfile/up_data/20101182228221941.dll.rar','/bin/CKFinder.dll','完成重写在线编辑器，性能提高3部左右，修改以前不可以上传图片的BUG。','2010-11-8 22:28:22')sqlnextsqlDrop 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)sqlnextsqlinsert into [$Prefix$ad] ([dtime],[id],[overtime],[u1],[u2],[u3],[u4],[u5],[u6]) values('2010-11-8 21:40:33',1,'2010-11-8 21:40:33','ad_2010118214033','首页240*150广告位','<p>
	<img alt="" src="/upfile/Editor/2010118/images/5(2).jpg" style="width: 240px; height: 150px" /></p>','图文','','<p>
	<img alt="" src="/upfile/Editor/2010118/images/5(2).jpg" style="width: 240px; height: 150px" /></p>')sqlnextsqlDrop Table sl_adminsqlnextsqlCREATE TABLE [$Prefix$admin] ([id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] text, [u4] datetime default now())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,'用户管理','2','','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(4,6,'评论管理','','Comments_Table.aspx','显示')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(11,15,'友情链接','','Link_Table.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(11,17,'关键字管理','','K_Table.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(11,27,'WEB FTP','','file_manage_main.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(11,28,'Sql Server','','sql_back.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(1,29,'单页面管理','','shop_Single.aspx','显示')sqlnextsqlinsert into [$Prefix$Columns] ([classid],[id],[u1],[u2],[u3],[u4]) values(1,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','显示')sqlnextsqlDrop Table sl_CommentsqlnextsqlCREATE TABLE [$Prefix$Comment] ([dtime] datetime default now(), [id] autoincrement(1,1), [u1] varchar, [u2] varchar, [u3] text, [u4] varchar, [u5] varchar, [u6] int default 0, [u7] varchar)sqlnextsql