cvs: php-hosts-web / table.sql
| From: | jim winstead | Date: | Tue, 23 Apr 2002 01:23:11 +0000 |
| Subject: | cvs: php-hosts-web / table.sql | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-9794@lists.php.net to get a copy of this message | ||
jimw Mon Apr 22 21:23:11 2002 EDT
Modified files:
/php-hosts-web table.sql
Log:
combine host_services and host_value tables, drop staff table (will be using cvs accounts)
Index: php-hosts-web/table.sql
diff -u php-hosts-web/table.sql:1.5 php-hosts-web/table.sql:1.6
--- php-hosts-web/table.sql:1.5 Mon Apr 22 14:36:17 2002
+++ php-hosts-web/table.sql Mon Apr 22 21:23:11 2002
@@ -13,21 +13,11 @@
ServiceID int(11) NOT NULL default '0',
OptionID int(11) NOT NULL default '0',
OptionValue varchar(255) default NULL,
+ OptionValueEx text default NULL,
KEY lookup (HostID,ServiceID,OptionID)
) TYPE=MyISAM;
--
--- Table structure for table 'host_value'
---
-
-CREATE TABLE host_value (
- HostId int(11) NOT NULL default '0',
- ServiceId int(11) NOT NULL default '0',
- content text,
- PRIMARY KEY (HostId,ServiceId)
-) TYPE=MyISAM;
-
---
-- Table structure for table 'hosts'
--
@@ -93,15 +83,6 @@
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;
--