| 这里升级数据库的时候请注意一下,由于D4升级后普遍都用了GBK!
 那么在升级数据库的时候,请注意一下...
 
 把
 
 TYPE=MyISAM;
 
 改为:
 
 ENGINE=MyISAM DEFAULT CHARSET=gbk;
 
 
 1.
 
 
 复制代码CREATE TABLE `cdb_crames` (
  `id` int(10) NOT NULL auto_increment,
  `uid` int(18) NOT NULL default '0',
  `name` varchar(30) default NULL,
  `fname` varchar(80) default NULL,
  `type` int(1) NOT NULL default '1',
  `digest` int(1) NOT NULL default '0',
  `dateline` int(20) default NULL,
  `shower` int(1) NOT NULL default '0',
  `info` varchar(240) default NULL,
  KEY `ID` (`id`),
  KEY `WDATE` (`dateline`),
  KEY `NAME` (`name`),
  KEY `type` (`type`),
  KEY `digest` (`digest`)
) TYPE=MyISAM;
 
 
 2.
 
 
 
 复制代码CREATE TABLE `cdb_crameimger` (
  `id` int(8) NOT NULL auto_increment,
  `sup` int(5) NOT NULL default '0',
  `name` varchar(24) default NULL,
  `src` varchar(120) default NULL,
  `path` varchar(30) default NULL,
  KEY `ID` (`id`),
  KEY `sup` (`sup`)
) TYPE=MyISAM;
 
 3.
 
 
 
 复制代码INSERT INTO `cdb_crameimger` VALUES (1, 0, '默认相框', NULL, 'default');
INSERT INTO `cdb_crameimger` VALUES (2, 1, NULL, 'k1.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (3, 1, NULL, 'k2.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (4, 6, NULL, 'k3.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (5, 6, NULL, 'k4.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (6, 0, '精致相框', NULL, 'delicacy');
INSERT INTO `cdb_crameimger` VALUES (7, 6, NULL, '1145693162_1.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (9, 6, NULL, '1145693181_3.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (10, 6, NULL, '1145693190_4.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (11, 6, NULL, '1145693197_5.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (12, 1, NULL, '1145694639_3.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (13, 1, NULL, '1145694647_1.png', NULL);
INSERT INTO `cdb_crameimger` VALUES (14, 1, NULL, '1145694656_2.png', NULL);
 
 
 至于
 
 [ 本帖最后由 oytktk 于 2006-4-26 11:51 编辑 ]
 |