mysql.sql

不错的东西

CREATE TABLE `2checkout` (
  `id` int(11) NOT NULL default '0',
  `invoice_id` int(11) unsigned zerofill NOT NULL auto_increment,
  `payment_gross` float NOT NULL default '0',
  `cc_firstname` varchar(255) NOT NULL default '',
  `cc_lastname` varchar(255) NOT NULL default '',
  `cc_address` varchar(255) NOT NULL default '',
  `cc_city` varchar(255) NOT NULL default '',
  `cc_state` varchar(255) NOT NULL default '',
  `cc_zip` int(5) NOT NULL default '0',
  `cc_country` varchar(255) NOT NULL default '',
  `approved` set('Y','N') NOT NULL default 'N',
  `test_mode` int(1) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`invoice_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `access` (
  `id` int(11) NOT NULL default '0',
  `session` varchar(40) NOT NULL default '',
  `host` int(11) NOT NULL default '0',
  `filename` varchar(255) NOT NULL default '',
  `method` int(1) NOT NULL default '0',
  `level` tinyint(4) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL auto_increment,
  `sid` int(11) NOT NULL default '0',
  `sdid` int(11) NOT NULL default '0',
  `firstname` varchar(50) NOT NULL default '',
  `lastname` varchar(50) NOT NULL default '',
  `company` varchar(50) NOT NULL default '',
  `address` varchar(50) NOT NULL default '',
  `city` varchar(50) NOT NULL default '',
  `state` int(1) NOT NULL default '0',
  `province` varchar(50) NOT NULL default '',
  `zip` int(5) NOT NULL default '0',
  `country` int(3) NOT NULL default '0',
  `phone_num` varchar(12) NOT NULL default '',
  `fax_num` varchar(12) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `referrer` varchar(50) NOT NULL default '',
  `username` varchar(8) NOT NULL default '',
  `password` varchar(40) NOT NULL default '',
  `pay_method` int(1) NOT NULL default '0',
  `pay_period` int(1) NOT NULL default '0',
  `package` int(11) NOT NULL default '0',
  `domain` varchar(255) NOT NULL default '',
  `domain_type` int(11) NOT NULL default '0',
  `level` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `hostname` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `servstatus` enum('yes','no') default 'no',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `ad_cue` (
  `id` bigint(20) NOT NULL default '0',
  `setup` int(11) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE `authnet` (
  `id` int(11) NOT NULL default '0',
  `invoice_id` int(11) unsigned zerofill NOT NULL auto_increment,
  `payment_gross` float NOT NULL default '0',
  `cc_firstname` varchar(255) NOT NULL default '',
  `cc_lastname` varchar(255) NOT NULL default '',
  `cc_address` varchar(255) NOT NULL default '',
  `cc_city` varchar(255) NOT NULL default '',
  `cc_state` varchar(255) NOT NULL default '',
  `cc_zip` int(5) NOT NULL default '0',
  `cc_country` varchar(255) NOT NULL default '',
  `cc_type` int(11) NOT NULL default '0',
  `cc_num` varchar(16) NOT NULL default '0',
  `cc_exp` varchar(4) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`invoice_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `emailBlock` (
  `emailID` int(11) NOT NULL auto_increment,
  `email` text NOT NULL,
  PRIMARY KEY  (`emailID`)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE `ipBlock` (
  `blockID` int(11) NOT NULL auto_increment,
  `IP` int(11) NOT NULL default '0',
  PRIMARY KEY  (`blockID`),
  UNIQUE KEY `IP` (`IP`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `banned` (
  `id` int(11) NOT NULL auto_increment,
  `host` int(11) NOT NULL default '0',
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `creationQue` (
  `creationID` int(11) NOT NULL auto_increment,
  `creationTime` text NOT NULL,
  PRIMARY KEY  (`creationID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `merchant` (
  `id` int(11) NOT NULL default '0',
  `alias` varchar(50) NOT NULL default '',
  `username` varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `key` varchar(50) NOT NULL default '',
  `return_url` varchar(50) NOT NULL default '',
  `test_mode` int(1) NOT NULL default '0',
  `active` int(1) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE `messages` (
  `id` int(11) NOT NULL default '0',
  `tid` int(11) NOT NULL default '0',
  `message` longtext NOT NULL,
  `date` int(10) NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE `packages` (
  `id` int(11) NOT NULL auto_increment,
  `sid` int(11) NOT NULL default '0',
  `whm_name` varchar(255) NOT NULL default '',
  `pkg_name` varchar(255) NOT NULL default '',
  `pkg_type` int(1) NOT NULL default '0',
  `monthly` float NOT NULL default '0',
  `quarterly` float NOT NULL default '0',
  `biannually` float NOT NULL default '0',
  `annually` float NOT NULL default '0',
  `monthly_id` int(11) NOT NULL default '0',
  `quarterly_id` int(11) NOT NULL default '0',
  `biannually_id` int(11) NOT NULL default '0',
  `annually_id` int(11) NOT NULL default '0',
  `disk_quota` int(11) NOT NULL default '0',
  `shell` tinyint(1) NOT NULL default '0',
  `max_ftp` int(11) NOT NULL default '0',
  `max_email` int(11) NOT NULL default '0',
  `max_mysql` int(11) NOT NULL default '0',
  `max_subdomains` int(11) NOT NULL default '0',
  `max_park` int(11) NOT NULL default '0',
  `max_mail` varchar(11) NOT NULL default '',
  `max_addon` int(11) NOT NULL default '0',
  `inet` tinyint(1) NOT NULL default '0',
  `cgi` tinyint(1) NOT NULL default '0',
  `frontpage` tinyint(1) NOT NULL default '0',