这里升级数据库的时候请注意一下,由于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 编辑 ] |