try this one
Code:
CREATE TABLE `uploadapp` ( `id` int(10) unsigned NOT NULL auto_increment, `userid` int(10) NOT NULL default '0', `applied` datetime NOT NULL default '0000-00-00 00:00:00', `speed` varchar(20) NOT NULL default '', `offer` longtext NOT NULL, `reason` longtext NOT NULL, `sites` ENUM('yes', 'no') NOT NULL default 'no', `sitenames` varchar(150) NOT NULL default '', `scene` ENUM('yes', 'no') NOT NULL default 'no', `creating` ENUM('yes', 'no') NOT NULL default 'no', `seeding` ENUM('yes', 'no') NOT NULL default 'no', `connectable` ENUM('yes', 'no', 'pending') NOT NULL default 'pending', `status` ENUM('accepted', 'rejected', 'pending') NOT NULL default 'pending', `moderator` varchar(40) NOT NULL default '', `comment` varchar(200) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `users` (`userid`) ) ENGINE=MyISAM AUTO_INCREMENT=1;
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in
BT.Manager™ forum
My Current Demo is here
http://demo.btmanager.org/