Changeset 3915 for trunk/tools/database/CreateTables.sql

Timestamp:

Aug 2, 2000, 3:01:36 AM (25 years ago)

Author:

bird

Message:

Corrections and changes.

File:

• trunk/tools/database/CreateTables.sql (modified) (4 diffs)

trunk/tools/database/CreateTables.sql

@@ -1 @@
--- $Id: CreateTables.sql,v 1.15 2000-08-01 01:58:53 bird Exp $
+-- $Id: CreateTables.sql,v 1.16 2000-08-02 01:01:36 bird Exp $
 --
 -- Create all tables.
@@ -15 +15 @@
     refcode     SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
     name        VARCHAR(64) NOT NULL,
+    first       VARCHAR(45) NOT NULL,
+    last        VARCHAR(45) NOT NULL,
     initials    CHAR(4) NOT NULL,
     alias       VARCHAR(32),
@@ -23 +25 @@
     UNIQUE u1(refcode),
     UNIQUE u2(name),
-    UNIQUE u3(initials)
+    UNIQUE u3(initials),
+    INDEX  i1(first),
+    INDEX  i2(last)
 --   ,UNIQUE i4(alias), UNIQUE columns have to be defined NOT NULL in mySql.
 --    UNIQUE i5(email)  UNIQUE columns have to be defined NOT NULL in mySql.
@@ -55 +59 @@
     weight  TINYINT NOT NULL,
     name    VARCHAR(32) NOT NULL,
-    description VARCHAR(128) NOT NULL,
+    description TEXT NOT NULL,
     UNIQUE u1(refcode),
     UNIQUE u2(name),