E_D("DROP TABLE IF EXISTS `db_table_field`;"); $this->E_C("CREATE TABLE `db_table_field` ( `field_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `table_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '模型ID', `field` varchar(50) NOT NULL DEFAULT '' COMMENT '字段名', `name` varchar(30) NOT NULL DEFAULT '' COMMENT '别名', `fieldtype` varchar(30) NOT NULL COMMENT '字段类型', `fieldlen` varchar(20) NOT NULL COMMENT '长度', `formtype` varchar(20) NOT NULL DEFAULT '' COMMENT '字段类型', `tips` text COMMENT '字段提示', `pattern` varchar(255) NOT NULL DEFAULT '' COMMENT '数据校验正则', `errortips` varchar(255) DEFAULT '' COMMENT '数据校验未通过的提示信息', `savefun` varchar(255) DEFAULT NULL, `issystem` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否主表', `isunique` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '值唯一', `sort` mediumint(8) unsigned NOT NULL DEFAULT '0', `formwidth` smallint(4) DEFAULT NULL COMMENT '元素宽度', `formheight` smallint(4) DEFAULT NULL COMMENT '元素高度', `imgwidth` smallint(6) DEFAULT '0' COMMENT '图片宽度', `imgheight` smallint(6) DEFAULT '0' COMMENT '图片高度', `defaultval` text COMMENT '默认值', `htmlcode` longtext COMMENT 'html代码', `memberhtmlcode` longtext COMMENT '会员投稿html代码', PRIMARY KEY (`field_id`), KEY `modelid` (`table_id`), KEY `field` (`field`,`table_id`) ) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COMMENT='模型字段列表'"); $this->E_D("replace into `db_table_field` values('27','9','title','标题','varchar','255','text','','','','','1','0','0','0','0','0','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('28','9','thumb','缩略图','varchar','255','image','','','','','1','0','0','0','0','123','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('29','9','newstime','时间','int','11','date','','','','','1','0','0','0','0','0','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('30','9','linkurl','跳转链接','varchar','255','text','如填写直接跳转到该地址','','','','1','0','0','0','0','0','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('32','9','newstext','详情','longtext','','editor','','','','','0','0','0','98','500','800','0','','
远程图片保存本地    提取第一张图做为缩略图（如果缩略图为空的情况下）
','
');"); $this->E_D("replace into `db_table_field` values('53','10','title','标题','varchar','255','text','','','','','1','0','1','0','0','0','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('54','10','thumb','缩略图','varchar','255','image','','','','','1','0','2','0','0','1000','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('55','10','newstime','时间','int','11','date','','','','','1','0','3','0','0','0','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('56','10','price','产品价格','int','11','text','','','','','1','0','4','0','0','1000','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('57','10','newstext','产品详情','longtext','','editor','','','','','0','0','8','0','400','1000','0','','
远程图片保存本地    提取第一张图做为缩略图（如果缩略图为空的情况下）
','
');"); $this->E_D("replace into `db_table_field` values('58','10','morepic','产品多图','text','','morepic','','','','','1','0','7','0','0','1000','0','','
  • \" draggable=\"false\"> \"> \">
    \">
    删除
  • +
','
  • \" draggable=\"false\"> \"> \">
    \">
    删除
  • +
');"); $this->E_D("replace into `db_table_field` values('59','10','type_no','型号','varchar','50','text','','','','','1','0','5','0','0','1000','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('60','10','pro_group','产品系列','varchar','50','select','','','','','1','0','6','0','0','1000','0','国产 进口 自己研发','
','
');"); $this->E_D("replace into `db_table_field` values('61','10','price2','促销价','int','11','text','','','','','1','0','4','0','0','1000','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); $this->E_D("replace into `db_table_field` values('62','10','sales','销量','int','11','text','','','','','1','0','0','0','0','1000','0','','
\" style=\"\"/>
','
\" style=\"\"/>
');"); ?>