cvs: php-hosts-web / table.sql
| From: | jim winstead | Date: | Wed, 24 Apr 2002 02:17:54 +0000 |
| Subject: | cvs: php-hosts-web / table.sql | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-9822@lists.php.net to get a copy of this message | ||
jimw Tue Apr 23 22:17:54 2002 EDT
Modified files:
/php-hosts-web table.sql
Log:
prevent duplicate hostnames, hosturls, and contact addresses
Index: php-hosts-web/table.sql
diff -u php-hosts-web/table.sql:1.8 php-hosts-web/table.sql:1.9
--- php-hosts-web/table.sql:1.8 Mon Apr 22 23:15:30 2002
+++ php-hosts-web/table.sql Tue Apr 23 22:17:54 2002
@@ -37,7 +37,9 @@
contact varchar(64) NOT NULL default '',
password varchar(13) NOT NULL default '',
PRIMARY KEY (HostID),
- KEY HostName (HostName)
+ UNIQUE KEY HostName (HostName),
+ UNIQUE KEY HostURL (HostURL),
+ UNIQUE KEY contact (contact)
) TYPE=MyISAM;
--