cvs: php-hosts-web / table.sql
| From: | jim winstead | Date: | Sun, 21 Apr 2002 22:13:57 +0000 |
| Subject: | cvs: php-hosts-web / table.sql | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-9727@lists.php.net to get a copy of this message | ||
jimw Sun Apr 21 18:13:57 2002 EDT
Modified files:
/php-hosts-web table.sql
Log:
new host_value table
Index: php-hosts-web/table.sql
diff -u php-hosts-web/table.sql:1.2 php-hosts-web/table.sql:1.3
--- php-hosts-web/table.sql:1.2 Sat Apr 20 23:53:27 2002
+++ php-hosts-web/table.sql Sun Apr 21 18:13:57 2002
@@ -1,3 +1,9 @@
+-- MySQL dump 8.19
+--
+-- Host: localhost Database: phphosts
+---------------------------------------------------------
+-- Server version 4.0.1-alpha-log
+
--
-- Table structure for table 'host_services'
--
@@ -8,6 +14,17 @@
OptionID int(11) NOT NULL default '0',
OptionValue varchar(255) 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;
--