1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
|
CREATE TABLE `bb1_applications` (
`applicationid` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) unsigned NOT NULL default '0',
`groupid` int(11) unsigned NOT NULL default '0',
`sendtime` int(11) unsigned NOT NULL default '0',
`reason` text NOT NULL,
`reply` text NOT NULL,
`status` tinyint(1) NOT NULL default '0',
`groupleaderid` int(11) unsigned NOT NULL default '0',
`notifyperemail` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`applicationid`),
UNIQUE KEY `userid` (`userid`,`groupid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ; |