MYSQL 3.23升级用如下代码:
drop table if exists cdb_postmach;
create table cdb_postmach (
style varchar(20) not null default '',
sside varchar(254) not null default '',
cdate int(18) not null default '0',
value text not null
) TYPE=MyISAM;
insert into cdb_postmach values ('set', '0', 0, 'thison');
insert into cdb_postmach values ('set', '0', 0, 'other');
insert into cdb_postmach values ('set', '18', 0, 'reftime');
insert into cdb_postmach values ('set', '5', 0, 'whatis');
insert into cdb_postmach values ('set', '15', 0, 'usertime');
insert into cdb_postmach values ('set', '0', '0', 'posttid');
insert into cdb_postmach values ('set', '18', 0, 'posttime');
insert into cdb_postmach values ('set', '2', '0', 'moneys');
insert into cdb_postmach values ('set', '3', 0, 'replytime');
insert into cdb_postmach values ('set', '0', 0, 'fids');
insert into cdb_postmach values ('set', '2', 0, 'ext_type');
insert into cdb_postmach values('set', '1', 0, 'closetopic');
insert into cdb_postmach values ('set', '0', 0, 'moderatedstatus'); |