cvs: functable / dbmodel.sql
| From: | Hartmut Holzgraefe | Date: | Sat, 08 Dec 2001 17:48:42 +0000 |
| Subject: | cvs: functable / dbmodel.sql | ||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-8521@lists.php.net to get a copy of this message | ||
hholzgra Sat Dec 8 12:48:42 2001 EDT
Modified files:
/functable dbmodel.sql
Log:
performance tuning
Index: functable/dbmodel.sql
diff -u functable/dbmodel.sql:1.4 functable/dbmodel.sql:1.5
--- functable/dbmodel.sql:1.4 Sat Dec 8 11:09:59 2001
+++ functable/dbmodel.sql Sat Dec 8 12:48:42 2001
@@ -77,13 +77,20 @@
DROP TABLE IF EXISTS quickref;
CREATE TABLE quickref (
- function varchar(100),
- language varchar(6),
- descr varchar(255)
+ function varchar(100) NOT NULL KEY,
+ language varchar(6) NOT NULL,
+ descr varchar(255) NOT NULL,
+ PRIMARY KEY(function,language,descr)
);
+
+
+#
+# Table structure for table 'author'
+#
+
DROP TABLE IF EXISTS author;
CREATE TABLE author (
function varchar(100) UNIQUE NOT NULL PRIMARY KEY,
- author varchar(100)
+ author varchar(100) NOT NULL
);