DROP TABLE IF EXISTS `#@_config`;
CREATE TABLE `#@_config` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `keyword` char(30) NOT NULL COMMENT '变量名',
  `vals` text NOT NULL COMMENT '变量值',
  `opts` text NOT NULL COMMENT 'opt值',
  `types` char(10) NOT NULL COMMENT '类型',
  `name` char(50) NOT NULL COMMENT '说明',
  `notes` varchar(80) NOT NULL DEFAULT '' COMMENT '解释',
  `gid` tinyint(2) NOT NULL COMMENT '所属组别',
  `sys` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否系统',
  `sort` mediumint(8) NOT NULL DEFAULT '50' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `one` (`keyword`) USING BTREE,
  KEY `keys` (`keyword`) USING BTREE,
  KEY `gid` (`gid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='网站配置';
REPLACE INTO `#@_config` VALUES ('1','CFG_NAME','梦赢科技','梦赢科技','char','公司名称','','1','0','50');
REPLACE INTO `#@_config` VALUES ('3','CFG_HOST','http://168.168.100.29/dwcrm','http://localhost','char','系统地址','','1','0','50');
REPLACE INTO `#@_config` VALUES ('6','CFG_PHONE','13802901247','13802901247','char','公司电话','','1','0','50');
REPLACE INTO `#@_config` VALUES ('7','APP_GROUP_LIST','Admin,Public','Admin,Public','char','项目分组','(请以“,”分开)','4','0','50');
REPLACE INTO `#@_config` VALUES ('8','DEFAULT_GROUP','Admin','Admin','char','默认分组','','4','0','50');
REPLACE INTO `#@_config` VALUES ('9','CFG_FAX','13802901247','13802901247','char','公司传真','','1','0','50');
REPLACE INTO `#@_config` VALUES ('10','CFG_MAIL','68058382@qq,com','68058382@qq,com','char','公司邮箱','','1','0','50');
REPLACE INTO `#@_config` VALUES ('11','CFG_ADDRESS','广东省深圳市','广东省深圳市','char','公司地址','','1','0','50');
REPLACE INTO `#@_config` VALUES ('13','CFG_APPID','','','char','站点识别ID','','-1','0','50');
REPLACE INTO `#@_config` VALUES ('14','CODE_ON','0','0','bool','登录验证码','','2','0','50');
REPLACE INTO `#@_config` VALUES ('15','CFG_COPYRIGHT','Copyright 2014 梦赢科技','Copyright 2014 梦赢科技','text','版权信息','','1','0','50');
REPLACE INTO `#@_config` VALUES ('17','DB_FIELDS_CACHE','1','1','bool','开启字段缓存','','2','0','50');
REPLACE INTO `#@_config` VALUES ('18','CODE_MODEL','1','1=&gt;数字|2=&gt;字母|5=&gt;混合','select','验证码模式','','2','0','50');
REPLACE INTO `#@_config` VALUES ('19','CODE_LEN','4','4','int','验证码长度','','2','0','50');
REPLACE INTO `#@_config` VALUES ('20','MAIL_SMTP_SEAVER','smtp.qq.com','smtp.qq.com','char','SMTP服务器','','3','0','50');
REPLACE INTO `#@_config` VALUES ('21','MAIL_SMTP_SSL','','','bool','安全连接(SSL)','(是否使用安全连接，一般都为否)','3','0','50');
REPLACE INTO `#@_config` VALUES ('22','MAIL_SMTP_PORT','25','25','int','SMTP服务器端口','(设置SMTP服务器的端口号，一般默认都是25)','3','0','50');
REPLACE INTO `#@_config` VALUES ('23','MAIL_SMTP_USER','68058382@qq.com','68058382@qq.com','char','SMTP用户名','','3','0','50');
REPLACE INTO `#@_config` VALUES ('24','MAIL_SMTP_PWD','123','123','char','SMTP密码','','3','0','50');
REPLACE INTO `#@_config` VALUES ('25','MAIL_SMTP_NAME','梦赢科技','梦赢科技','char','发件箱名称','','3','0','50');
REPLACE INTO `#@_config` VALUES ('32','CFG_CHARSET','UTF-8','UTF-8=&gt;UTF-8|GBK=&gt;GBK','select','编码类型','','4','0','50');
REPLACE INTO `#@_config` VALUES ('33','WALL_ON','0','0','bool','开启防火墙','','52','0','50');
REPLACE INTO `#@_config` VALUES ('34','WALL_KEY','','','char','防火墙密钥','(6~50个数字或字母)','52','0','50');
REPLACE INTO `#@_config` VALUES ('35','LOGIN_URL','','','char','允许后台登陆的域名','(如：http://www.piocms.com/index.php/admin)','52','0','50');
REPLACE INTO `#@_config` VALUES ('36','LOGIN_TIME','','','more','允许登陆后台的时间点','(不选为不限制)','52','0','50');
REPLACE INTO `#@_config` VALUES ('37','LOGIN_WEEK','','','more','允许登陆后台的星期','(不选为不限制) ','52','0','50');
REPLACE INTO `#@_config` VALUES ('39','CFG_NUM','2','2','int','保留小数位','(小数点后保留的位数)','2','0','50');
REPLACE INTO `#@_config` VALUES ('38','WALL_SHIELDING','操你妈|鸡巴|性爱|毛泽东|共产党','操你妈|鸡巴|性爱|毛泽东|共产党','text','屏蔽敏感字符','(多个用“|”格开，屏蔽前台所提交的内容)','52','0','50');
REPLACE INTO `#@_config` VALUES ('40','DATA_CACHE_TYPE','File','File|Apachenote|Apc|Eaccelerator|Memcache|Shmop|Sqlite|Db|Redis|Xcache','select','数据缓存方式','(部分缓存方式需要服务器支持)','2','0','50');
REPLACE INTO `#@_config` VALUES ('56','DATA_NOWRAP','1','1','bool','自动截取','(设置为true，当表格数据长度超出列宽时将会自动截取)','2','0','50');
REPLACE INTO `#@_config` VALUES ('55','DG_FIT_COLUMNS','1','1','bool','自动列适应','(设置为true，将自动使列适应表格宽度以防止出现水平滚动)','2','0','50');
REPLACE INTO `#@_config` VALUES ('54','SEARCH_ADV_ACTION','0','0','bool','高级搜索动作','(控制查询之后窗口是否自动关闭)','2','0','50');
REPLACE INTO `#@_config` VALUES ('41','DATA_CACHE_SUBDIR','1','1','bool','哈希子目录缓存','','2','0','50');
REPLACE INTO `#@_config` VALUES ('42','DATA_PATH_LEVEL','2','2','int','哈希目录层次','(需要开启哈希目录缓存)','2','0','50');
REPLACE INTO `#@_config` VALUES ('46','IMG_WIDTH','180','180','int','默认缩略图宽度','','3','0','50');
REPLACE INTO `#@_config` VALUES ('47','IMG_HEIGHT','137','137','int','默认缩略图高度','','3','0','50');
REPLACE INTO `#@_config` VALUES ('50','PAGE_ROW','50','0=&gt;0|10=&gt;10|30=&gt;30|50=&gt;50|80=&gt;80|100=&gt;100|100000000000=&gt;ALL','select','每页显示行数','(为"0"时表示不显示分页)','2','0','50');
REPLACE INTO `#@_config` VALUES ('57','UPLOAD_SIZE','1048576','1048576','int','上传限制','(单位：字节)','3','0','50');
REPLACE INTO `#@_config` VALUES ('53','SEARCH_ACTION','0','0','bool','快速查询动作','(控制查询之后窗口是否自动关闭)','2','0','50');
REPLACE INTO `#@_config` VALUES ('62','SKIN_COOKIE_EXPIRES','365','365','int','皮肤过期时间','(切换皮肤过期时间，单位：天)','3','0','50');
REPLACE INTO `#@_config` VALUES ('61','CFG_OPEN_TABS','1','1','bool','选项卡打开方式','(是否在新的选项卡打开项目)','2','0','50');
REPLACE INTO `#@_config` VALUES ('63','DB_SQL_BUILD_CACHE','1','1','bool','SQL解析缓存','','2','0','50');
REPLACE INTO `#@_config` VALUES ('64','DB_SQL_BUILD_LENGTH','30','30','int','SQL解析缓存长度','','2','0','50');
REPLACE INTO `#@_config` VALUES ('65','DB_SQL_BUILD_QUEUE','file','file|xcache|apc','select','SQL解析缓存方式','','2','0','50');
REPLACE INTO `#@_config` VALUES ('66','DATA_CACHE_TIME','0','0','int','数据缓存时间','(“0”表示永久缓存，单位：秒)','2','0','50');
REPLACE INTO `#@_config` VALUES ('67','BROWSER_CACHE','0','0','bool','调用浏览器缓存','(是否调用调用浏览的缓存)','2','0','50');
REPLACE INTO `#@_config` VALUES ('68','DATAGRID_VIEW','0','0=&gt;无视图|scrollview=&gt;scrollview|bufferview=&gt;bufferview','select','开启表格视图','','2','0','50');
REPLACE INTO `#@_config` VALUES ('76','CFG_ON','1','1','bool','站点开关','(关闭时，系统将无法登录)','4','0','50');
REPLACE INTO `#@_config` VALUES ('77','BACKUP_SIZE','300','300','int','备份文件大小','(单个备份文件大小限制，单位：KB)','3','0','50');
REPLACE INTO `#@_config` VALUES ('71','SUBMIT_ACTION','1','1','bool','提交成功动作','(提交成功之后窗口是否自动关闭)','2','0','50');
REPLACE INTO `#@_config` VALUES ('72','MORE_COMY','1','1','bool','开启子公司','','3','0','50');
REPLACE INTO `#@_config` VALUES ('78','USER_TO_MAIL','0','0','bool','用户注册提醒','(为新增的用户发送邮件提醒)','3','0','50');
REPLACE INTO `#@_config` VALUES ('79','MAIL_OF_USER','0','0','bool','允许个人邮箱','(开启后，运行用户更改并使用个人邮箱)','3','0','50');
REPLACE INTO `#@_config` VALUES ('80','PRO_TABS','进度跟进','进度跟进','text','跟进选项卡','(设置跟进选项分类，多个请用“|”分开)','3','1','50');
REPLACE INTO `#@_config` VALUES ('81','SMS_AUTO_REPORT','1','1','bool','信息自动提醒','','2','1','50');
REPLACE INTO `#@_config` VALUES ('82','VIEW_GRESS','7','7','int','最新跟进天数','(显示多少天内的数据)','3','1','50');
