3.1.sql

下载系统 # 汉化：Fising # 邮箱：[e-mail] # 网址：http://www.fising.cn # 声明：本人水平有限

ALTER TABLE `##PREFIX##settings` CHANGE `settings_id` `id` INT( 1 ) NOT NULL DEFAULT '1';
ALTER TABLE `##PREFIX##settings` CHANGE `settings_dbname` `dbname` TEXT NOT NULL;
ALTER TABLE `##PREFIX##settings` CHANGE `settings_dbdescription` `dbdescription` TEXT NOT NULL;
ALTER TABLE `##PREFIX##settings` CHANGE `settings_dburl` `dburl` TEXT NOT NULL;
ALTER TABLE `##PREFIX##settings` CHANGE `settings_topnumber` `topnumber` INT( 5 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##settings` CHANGE `settings_homeurl` `homeurl` TEXT NOT NULL;
ALTER TABLE `##PREFIX##settings` CHANGE `settings_newdays` `newdays` INT( 5 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##settings` CHANGE `settings_timeoffset` `timeoffset` INT( 5 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##settings` CHANGE `settings_timezone` `timezone` VARCHAR( 100 ) NOT NULL;
ALTER TABLE `##PREFIX##settings` ADD `enable_email` INT( 1 ) NOT NULL;
ALTER TABLE `##PREFIX##settings` DROP `settings_header`;
ALTER TABLE `##PREFIX##settings` DROP `settings_footer`;
ALTER TABLE `##PREFIX##settings` DROP `newdays`;
ALTER TABLE `##PREFIX##settings` DROP `dbdescription`;
ALTER TABLE `##PREFIX##settings` CHANGE `settings_style` `skin` VARCHAR( 20 ) NOT NULL;
ALTER TABLE `##PREFIX##settings` CHANGE `settings_stats` `stats` INT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##settings` CHANGE `settings_lang` `lang` VARCHAR( 20 ) NOT NULL;
ALTER TABLE `##PREFIX##settings` CHANGE `settings_viewall` `viewall` INT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##settings` CHANGE `settings_showss` `showss` INT( 1 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##settings` DROP `settings_disable`;
ALTER TABLE `##PREFIX##settings` ADD `date_format` VARCHAR( 40 ) NOT NULL;
ALTER TABLE `##PREFIX##settings` ADD `time_format` VARCHAR( 40 ) NOT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_name` `file_name` VARCHAR( 150 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_desc` `file_desc` VARCHAR( 200 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_creator` `file_creator` VARCHAR( 100 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_version` `file_version` VARCHAR( 20 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_catid` `file_catid` INT( 5 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_posticon` `file_posticon` VARCHAR( 30 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_license` `file_license` INT( 5 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_pin` `file_pin` INT( 1 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_rating` `file_rating` INT( 10 ) NOT NULL;
ALTER TABLE `##PREFIX##files` CHANGE `file_totalvotes` `file_totalvotes` INT( 10 ) NOT NULL;
ALTER TABLE `##PREFIX##settings` ADD `dropdown` TEXT NOT NULL;
CREATE TABLE `##PREFIX##emaillog` (`e_id` int(6) NOT NULL auto_increment,`e_date` int(20) NOT NULL default '0',`e_ip` varchar(15) NOT NULL default '',`e_fromname` text NOT NULL,`e_fromaddress` text NOT NULL,`e_toname` text NOT NULL,`e_toaddress` text NOT NULL,`e_headers` text NOT NULL,`e_subject` text NOT NULL,`e_message` text NOT NULL,PRIMARY KEY  (`e_id`)) TYPE=MyISAM AUTO_INCREMENT=1 ;
ALTER TABLE `##PREFIX##admin` CHANGE `admin_password` `admin_password` VARCHAR( 32 ) NULL DEFAULT NULL;
DROP TABLE `##PREFIX##team`, `##PREFIX##votes`;
ALTER TABLE `##PREFIX##admin` CHANGE `admin_id` `admin_id` INT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `##PREFIX##admin` CHANGE `admin_username` `admin_username` VARCHAR( 20 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##admin` CHANGE `admin_email` `admin_email` VARCHAR( 50 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##cat` CHANGE `cat_id` `cat_id` INT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `##PREFIX##cat` DROP `cat_1xid`;
ALTER TABLE `##PREFIX##cat` CHANGE `cat_parent` `cat_parent` INT( 5 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##cat` CHANGE `cat_order` `cat_order` INT( 5 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##cat` CHANGE `cat_name` `cat_name` VARCHAR( 75 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##cat` CHANGE `cat_desc` `cat_desc` VARCHAR( 150 ) NULL DEFAULT NULL;
ALTER TABLE `##PREFIX##custom` CHANGE `custom_id` `custom_id` INT( 5 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `##PREFIX##custom` CHANGE `custom_name` `custom_name` VARCHAR( 50 ) NOT NULL;
ALTER TABLE `##PREFIX##custom` CHANGE `custom_description` `custom_description` VARCHAR( 150 ) NOT NULL;
ALTER TABLE `##PREFIX##customdata` CHANGE `customdata_file` `customdata_file` INT( 5 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##customdata` CHANGE `customdata_custom` `customdata_custom` INT( 5 ) NOT NULL DEFAULT '0';
ALTER TABLE `##PREFIX##license` CHANGE `license_id` `license_id` INT( 5 ) NOT NULL AUTO_INCREMENT;
UPDATE `##PREFIX##admin` SET `admin_status` = '3';
ALTER TABLE `##PREFIX##settings` ADD `perpage` INT( 3 ) NOT NULL;
UPDATE `##PREFIX##settings` SET `perpage` = '20' WHERE `id` =1;
ALTER TABLE `##PREFIX##cat` ADD `cat_sort` VARCHAR( 25 ) NOT NULL;
UPDATE `##PREFIX##cat` SET `cat_sort` = 'time|desc';
ALTER TABLE `##PREFIX##files` ADD `file_mirrors` TEXT NOT NULL AFTER `file_dlurl`;
ALTER TABLE `##PREFIX##settings` ADD `enable_report` INT( 1 ) DEFAULT '1' NOT NULL;
ALTER TABLE `##PREFIX##settings` ADD `sort_override` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `quickdl` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `dbstats` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `fromemail` VARCHAR( 50 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `validateemail` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `enable_comments` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `guest_comments` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `enable_registration` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `comments_perpage` INT( 3 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `require_registration` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `newest_news` INT( 30 ) NOT NULL ;
ALTER TABLE `##PREFIX##files` ADD `file_tags` TEXT NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `display_tags` INT( 1 ) NOT NULL ;
ALTER TABLE `##PREFIX##settings` ADD `tag_cloud` TEXT NOT NULL ;
UPDATE `##PREFIX##settings` SET `date_format` = '%b %d, %Y', `time_format` = '%I:%M %p' ;

CREATE TABLE `##PREFIX##users` (
  `user_userid` int(6) NOT NULL auto_increment,
  `user_username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_email` varchar(50) NOT NULL default '',
  `user_status` int(1) NOT NULL default '0',
  `user_emailvalidation` varchar(32) NOT NULL default '',
  `user_passvalidation` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`user_userid`)
) TYPE=MyISAM;

CREATE TABLE `##PREFIX##comments` (
  `comment_id` int(10) NOT NULL auto_increment,
  `comment_userid` int(6) NOT NULL default '0',
  `comment_fileid` int(6) NOT NULL default '0',
  `comment_time` int(20) NOT NULL default '0',
  `comment_subject` varchar(150) NOT NULL default '',
  `comment_ip` varchar(15) NOT NULL default '',
  `comment_text` text NOT NULL,
  PRIMARY KEY  (`comment_id`)
) TYPE=MyISAM;

CREATE TABLE `##PREFIX##adminnews` (
  `date` int(30) NOT NULL default '0',
  `subject` varchar(150) NOT NULL default '',
  `text` text NOT NULL,
  PRIMARY KEY  (`date`)
) TYPE=MyISAM;