1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
|
DROP TABLE IF EXISTS bb1_applications;
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 default '',
reply text NOT NULL default '',
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; |