cvs: php-hosts-web / table.sql

jimw Sat Apr 20 23:53:27 2002 EDT Modified files: /php-hosts-web table.sql Log: updated table structure Index: php-hosts-web/table.sql diff -u php-hosts-web/table.sql:1.1.1.1 php-hosts-web/table.sql:1.2 --- php-hosts-web/table.sql:1.1.1.1 Thu Feb 7 11:38:32 2002 +++ php-hosts-web/table.sql Sat Apr 20 23:53:27 2002 @@ -1,77 +1,100 @@ -# MySQL dump 4.0 -# -# Host: localhost Database: php_hosts -#-------------------------------------------------------- - -# -# Table structure for table 'hosts' -# -DROP TABLE hosts; +-- +-- Table structure for table 'host_services' +-- + +CREATE TABLE host_services ( + HostID int(11) NOT NULL default '0', + ServiceID int(11) NOT NULL default '0', + OptionID int(11) NOT NULL default '0', + OptionValue varchar(255) default NULL, + KEY lookup (HostID,ServiceID,OptionID) +) TYPE=MyISAM; + +-- +-- Table structure for table 'hosts' +-- + CREATE TABLE hosts ( - HostID int(11) DEFAULT '0' NOT NULL auto_increment, - HostName varchar(64) DEFAULT '' NOT NULL, - HostURL varchar(255) DEFAULT '' NOT NULL, - HostInfoURL varchar(255), - HostEmail varchar(64) DEFAULT '' NOT NULL, - HostPhone varchar(32), - HostFax varchar(32), - HostCity varchar(32), - HostState varchar(32), - HostCountry char(2), - PRIMARY KEY (HostID), + HostID int(11) NOT NULL auto_increment, + HostName varchar(64) NOT NULL default '', + HostURL varchar(255) NOT NULL default '', + HostInfoURL varchar(255) default NULL, + HostEmail varchar(64) NOT NULL default '', + HostPhone varchar(32) default NULL, + HostFax varchar(32) default NULL, + HostCity varchar(32) default NULL, + HostState varchar(32) default NULL, + HostCountry char(2) default NULL, + PRIMARY KEY (HostID), KEY HostName (HostName) -); +) TYPE=MyISAM; +-- +-- Table structure for table 'msgboard_msgs' +-- + +CREATE TABLE msgboard_msgs ( + id int(11) NOT NULL auto_increment, + date int(11) NOT NULL default '0', + subgroup smallint(6) NOT NULL default '0', + parent int(11) default NULL, + type int(11) default NULL, + subj varchar(127) default NULL, + email varchar(127) default NULL, + name varchar(127) default NULL, + document int(11) NOT NULL default '0', + PRIMARY KEY (id), + KEY date (date), + KEY subgroup (subgroup) +) TYPE=MyISAM; + +-- +-- Table structure for table 'options' +-- -# -# Table structure for table 'options' -# -DROP TABLE options; CREATE TABLE options ( - OptionID int(11) DEFAULT '0' NOT NULL auto_increment, - ServiceID int(11) DEFAULT '0' NOT NULL, - OptionValue varchar(255) DEFAULT '' NOT NULL, - PRIMARY KEY (OptionID), + OptionID int(11) NOT NULL auto_increment, + ServiceID int(11) NOT NULL default '0', + OptionName varchar(255) NOT NULL default '', + Sort smallint(6) NOT NULL default '999', + PRIMARY KEY (OptionID), KEY ServiceID (ServiceID), - KEY OptionValue (OptionValue) -); + KEY OptionValue (OptionName) +) TYPE=MyISAM; +-- +-- Table structure for table 'services' +-- -# -# Table structure for table 'services' -# -DROP TABLE services; CREATE TABLE services ( - ServiceID int(11) DEFAULT '0' NOT NULL auto_increment, - ServiceName varchar(64) DEFAULT '' NOT NULL, - ServiceType enum("single","multiple","boolean","free"), - PRIMARY KEY (ServiceID), + ServiceID int(11) NOT NULL auto_increment, + ServiceName varchar(64) NOT NULL default '', + ServiceType enum('single','multiple','multiplev','boolean','booleanv','number','text','free') default NULL, + Sort smallint(6) NOT NULL default '999', + PRIMARY KEY (ServiceID), KEY ServiceName (ServiceName) -); +) TYPE=MyISAM; +-- +-- Table structure for table 'staff' +-- + +CREATE TABLE staff ( + user char(8) NOT NULL default '', + pass char(13) NOT NULL default '' +) TYPE=MyISAM; + +-- +-- Table structure for table 'users' +-- -# -# Table structure for table 'host_services' -# -DROP TABLE host_services; -CREATE TABLE host_services ( - HostID int(11) DEFAULT '0' NOT NULL, - ServiceID int(11) DEFAULT '0' NOT NULL, - OptionID int(11) DEFAULT '0' NOT NULL, - INDEX lookup (HostID,ServiceID,OptionID) -); - - -# -# Table structure for table 'users' -# -DROP TABLE users; CREATE TABLE users ( - UserUser varchar(8) DEFAULT '' NOT NULL, - UserPass varchar(13) DEFAULT '' NOT NULL, - HostID int(11) DEFAULT '0' NOT NULL, - UserEmail varchar(64), - PRIMARY KEY (UserUser), + UserUser varchar(8) NOT NULL default '', + UserPass varchar(13) NOT NULL default '', + HostID int(11) NOT NULL default '0', + UserEmail varchar(64) default NULL, + PRIMARY KEY (UserUser), KEY UserPass (UserPass), KEY HostID (HostID) -); +) TYPE=MyISAM; +