mfhs-1.2.sql

来自「网络硬盘_支持1GB文件上传和续传_无错版」· SQL 代码 · 共 592 行 · 第 1/2 页

  `enabled` tinyint(1) default '1',
  `hook_priority` int(11) default '1',
  `plugin_id` int(11) default '1',
  PRIMARY KEY  (`hook_id`)
) ENGINE=MyISAM;

#
# Table structure for table news
#

CREATE TABLE `news` (
  `news_id` int(11) unsigned NOT NULL auto_increment,
  `title` text,
  `body` text,
  `public` tinyint(1) default '1',
  `start_date` int(11) default NULL,
  `end_date` int(11) default NULL,
  `date` int(11) default NULL,
  `lang` varchar(4) default NULL,
  PRIMARY KEY  (`news_id`)
) ENGINE=MyISAM;

#
# Table structure for table plugins
#

CREATE TABLE `plugins` (
  `plugin_id` int(11) NOT NULL auto_increment,
  `name` varchar(64) default '',
  `descr` varchar(255) default '',
  `version` varchar(12) default '',
  `author` varchar(32) default '',
  `homepage` varchar(128) default '',
  `enabled` int(11) default NULL,
  `dependent` varchar(255) default '',
  `plugin_type` enum('3rd','offical','custom') default 'offical',
  `plugin_priority` int(11) default '1',
  `run_type` enum('eval','function') default 'eval',
  PRIMARY KEY  (`plugin_id`)
) ENGINE=MyISAM;

#
# Table structure for table pointhistory
#

CREATE TABLE `pointhistory` (
  `history_id` int(11) NOT NULL auto_increment,
  `uid` int(11) default NULL,
  `promotion_id` int(11) default NULL,
  `points` int(11) default NULL,
  `date` int(11) default NULL,
  `status` enum('complete','pending') default 'pending',
  `type` enum('upgrade','payout') default 'upgrade',
  `user_note` text,
  `admin_note` text,
  PRIMARY KEY  (`history_id`)
) ENGINE=MyISAM;

#
# Table structure for table promotions
#

CREATE TABLE `promotions` (
  `promotion_id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `descr` text,
  `source_gid` int(11) default NULL,
  `dest_gid` int(11) default NULL,
  `months` int(11) default NULL,
  `points` int(11) default NULL,
  `money` varchar(11) default NULL,
  `points_fee` int(11) default NULL,
  `note` text,
  `start_date` int(11) default NULL,
  `end_date` int(11) default NULL,
  `expire_date` int(11) default NULL,
  PRIMARY KEY  (`promotion_id`)
) ENGINE=MyISAM;

#
# Dumping data for table promotions
#

INSERT INTO `promotions` VALUES (2,'Registered promotion','Registered promotion description',2,3,1,100,'5',1000,'Registered promotion payout explantion',0,0,0);
INSERT INTO `promotions` VALUES (3,'Premium extend','Premium extend',3,3,1,100,'5',1000,'Premium extend',0,0,0);

#
# Table structure for table records
#

CREATE TABLE `records` (
  `record_id` int(11) unsigned NOT NULL auto_increment,
  `txn_id` varchar(32) default NULL,
  `txn_ref` varchar(255) default NULL,
  `provider` varchar(20) default NULL,
  `item_name` varchar(255) default NULL,
  `item_number` varchar(255) default NULL,
  `amount` varchar(11) default NULL,
  `fee` varchar(11) default NULL,
  `currency` varchar(32) default NULL,
  `quantity` int(11) default NULL,
  `payment_status` varchar(30) default NULL,
  `payment_type` varchar(255) default NULL,
  `pending_reason` varchar(255) default NULL,
  `payment_date` int(11) default NULL,
  `subscr_id` varchar(255) default NULL,
  `subscr_ref` varchar(255) default NULL,
  `subscr_unit` enum('D','M','Y') default NULL,
  `subscr_period` int(11) default NULL,
  `subscr_amount` varchar(11) default NULL,
  `trial_unit` enum('D','M','Y') default NULL,
  `trial_period` int(11) default NULL,
  `trial_amount` varchar(11) default NULL,
  `payee_account` varchar(255) default NULL,
  `payer_account` varchar(255) default NULL,
  `note` text,
  `data` text,
  `uid` int(11) default NULL,
  `descr` text,
  `record_date` int(11) default NULL,
  PRIMARY KEY  (`record_id`)
) ENGINE=MyISAM;

#
# Table structure for table reports
#

CREATE TABLE `reports` (
  `report_id` int(11) unsigned NOT NULL auto_increment,
  `upload_id` varchar(12) character set utf8 default NULL,
  `file_id` int(11) default NULL,
  `username` varchar(32) default NULL,
  `subject` varchar(255) default NULL,
  `problems` varchar(255) default NULL,
  `details` text,
  `date` int(11) default NULL,
  `fullname` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `IP` varchar(32) default NULL,
  PRIMARY KEY  (`report_id`)
) ENGINE=MyISAM;

#
# Table structure for table server
#

CREATE TABLE `server` (
  `server_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `http` enum('http://','https://') default 'http://',
  `domain` varchar(255) default NULL,
  `cgiurl` varchar(255) default NULL,
  `php_temp_dir` varchar(32) default 'temp',
  `cgi_temp_dir` varchar(32) default 'temp',
  `upload_dir` varchar(32) default 'files',
  `keepext` enum('yes','no') default 'no',
  `iswin` enum('yes','no') default 'yes',
  `lighttpd` tinyint(1) default '0',
  `webspace` varchar(255) default '0',
  `max_webspace` varchar(255) default '0',
  `warn_webspace` varchar(255) default '0',
  `mod_status` varchar(255) default '0,0,0,0',
  `im_path` varchar(64) default NULL,
  `ffmpeg_path` varchar(64) default NULL,
  `mplayer_path` varchar(64) default NULL,
  `hosted` int(11) default '0',
  `dbhost` varchar(255) default NULL,
  `ftp` varchar(255) default NULL,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `path` text,
  `enabled` tinyint(1) default '0',
  `cgi_prog_mode` enum('syn','ajax') default 'ajax',
  `url_prog_mode` enum('syn','ajax') default 'syn',
  `ftp_prog_mode` enum('syn','ajax') default 'syn',
  PRIMARY KEY  (`server_id`)
) ENGINE=MyISAM;

#
# Table structure for table setting
#

CREATE TABLE `setting` (
  `set_id` int(11) NOT NULL default '0',
  `admin` varchar(32) default NULL,
  `pass` varchar(255) default NULL,
  `pass_salt` varchar(3) default NULL,
  `admin_lastclick` int(11) default NULL,
  `admin_ip` varchar(32) default NULL,
  `reset_date` int(11) default NULL,
  `last_login` int(11) default NULL,
  `last_fail` int(11) default NULL,
  `fail_times` tinyint(3) default '0',
  `max_failtimes` tinyint(4) default '3',
  `adminemail` varchar(100) NOT NULL default '',
  `servermoniter_emails` varchar(255) default NULL,
  `validate` char(1) default '0',
  `banip` mediumtext,
  `sitename` varchar(200) default NULL,
  `server` varchar(11) default '0',
  `language` varchar(255) default '255',
  `lang_page` enum('static','dyn') default 'static',
  `newsletter_subject` varchar(255) default NULL,
  `newsletter_body` text,
  `newsletter_target` varchar(4) default NULL,
  `in_process` tinyint(4) default '0',
  `site_keyword` text,
  `site_descr` text,
  `emailsign` text,
  `skin_dir` varchar(255) default NULL,
  `cached` tinyint(4) default '1',
  `notifyreport` tinyint(1) default '1',
  `site_offline` tinyint(1) default '0',
  `descr` tinyint(1) default '1',
  `password` tinyint(1) default '1',
  `sitestats` tinyint(1) default '1',
  `static_url` enum('dyn','short','seo') default NULL,
  `allow_php` tinyint(1) default '1',
  `shaketime` int(11) default '2000',
  `startshow` int(11) default '2000',
  `adtop` int(11) default '200',
  `adleft` int(11) default '500',
  `slidestep` int(11) default '15',
  `slideinternal` int(11) default '10',
  `show_featured_files` tinyint(1) default '1',
  `show_guest_package` tinyint(1) default '1',
  `thumb_width` int(11) default '165',
  `thumb_height` int(11) default '165',
  `thumb_type` enum('fix','soft') default 'soft',
  `validate_type` enum('auto','admin') default 'auto',
  `featured_type` tinyint(1) default '0',
  `featured_ads` tinyint(3) default NULL,
  `featured_files` int(11) default NULL,
  `featured_users` text,
  `top_page` enum('static','dyn') default 'dyn',
  `download_code` varchar(64) default NULL,
  `check_download_ip` tinyint(1) default '1',
  `download_prefix` varchar(32) default NULL,
  `cache_sessions` tinyint(4) default '1',
  `allow_proxy` tinyint(1) default '0',
  `mfhs_version` varchar(64) default NULL,
  `main` tinyint(1) default '1',
  `debug` enum('yes','no') default 'no',
  `admin_charset` varchar(32) default 'UTF-8',
  `report_captcha` tinyint(1) default '0',
  `contact_captcha` tinyint(1) default '0',
  `show_options` tinyint(1) default '1',
  `expired_package` int(11) default NULL,
  `use_flash_progress` tinyint(1) default '0',
  `inline_crontab` tinyint(1) default '1',
  `license_status` varchar(32) default NULL,
  `license_keycode` varchar(32) default NULL,
  `last_stats` varchar(64) default NULL,
  PRIMARY KEY  (`set_id`)
) ENGINE=MyISAM;

#
# Dumping data for table setting
#

INSERT INTO `setting` VALUES (1,'admin','d9b1d7db4cd6e70935368a1efb10e377',NULL,1166850868,'127.0.0.1',1166338908,1166842671,1166800713,0,123,'','','0','','Mega File Hosting Script','0','-1','dyn','subject','body','',0,'hosting, webhosting, webspace, webserver, backup, file exchange, bandwidth, free download, free downloads, free upload, upload, uploading, download, downloads, mp3, movies, music, videos, shareware, remote desktop, file synchronization, flirt, download movies, spyware remover, firewall software download, chatroom, file transfer, software downloads, file sharing, music downloads, webcam, file mirroring, free software downloads, photoshop, paint shop, download, music downloading, toolbar, playlist, music, kiss tips, file recovery, toner cartridge, edonkey, emule, spyware free download, Singles, ecards, free download, free video, digital photos, free music, photos, video download','The best file hosting service! we provides free web space for your documents, pictures, music and movies.','changme.com','blue',1,1,0,1,1,0,'dyn',0,2000,2000,200,500,15,10,1,0,165,165,'soft','auto',1,1,6,NULL,NULL,'mycodehere',1,'[dl]',1,0,NULL,1,'','UTF-8',1,1,0,2,0,1,'OK',NULL,NULL);

#
# Table structure for table users
#

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `user` varchar(255) default NULL,
  `pass` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `bandwidth` varchar(255) default '0',
  `webspace` varchar(255) default '0',
  `files` int(11) default '0',
  `totaldownloads` bigint(19) NOT NULL default '0',
  `totalpoints` varchar(32) default '0',
  `gid` int(11) default NULL,
  `status` tinyint(4) default '1',
  `regdate` int(11) default NULL,
  `subscr_id` varchar(255) default NULL,
  `subscr_unit` enum('D','M','Y') default NULL,
  `subscr_period` int(11) default NULL,
  `subscr_fee` varchar(10) default NULL,
  `expire_date` int(11) default '0',
  `payment_type` enum('instant','subscriptions') default NULL,
  `referby` int(11) default NULL,
  `last_login` int(11) default NULL,
  `last_update` int(11) default NULL,
  `last_remove` tinyint(4) default NULL,
  `custom` enum('yes','no') default 'no',
  `data` text,
  `validate_code` varchar(32) default NULL,
  `sent` tinyint(4) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;