原帖由
johntom 於 2007-7-19 12:03 發表

SQL:
CREATE TABLE `jhzhufu` (
`ID` mediumint(8) unsigned NOT NULL auto_increment,
`jhid` mediumint(8) unsigned NOT NULL default '0',
`username` varchar(15) NOT NULL default '',
`tousername` ...
DROP TABLE IF EXISTS `cdb_marry` ;
CREATE TABLE `cdb_marry` (
`mid` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL,
`username` char(15) NOT NULL,
`marryuser` char(15) NOT NULL,
`proposetime` int(10) default NULL,
`agreetime` int(10) unsigned default NULL,
`regtime` int(10) unsigned default NULL,
`content` mediumtext NOT NULL,
`isreg` tinyint(1) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
`divorce` mediumint(8) unsigned default NULL,
PRIMARY KEY (`mid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ;
DROP TABLE IF EXISTS `cdb_marry` ;
CREATE TABLE `cdb_marry` (
`mid` mediumint(8) unsigned NOT NULL auto_increment,
`uid` mediumint(8) unsigned NOT NULL,
`username` char(15) NOT NULL,
`marryuser` char(15) NOT NULL,
`proposetime` int(10) default NULL,
`agreetime` int(10) unsigned default NULL,
`regtime` int(10) unsigned default NULL,
`content` mediumtext NOT NULL,
`isreg` tinyint(1) NOT NULL default '0',
`status` tinyint(1) NOT NULL default '0',
`divorce` mediumint(8) unsigned default NULL,
PRIMARY KEY (`mid`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;