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

Timestamp:

Feb 13, 2000, 12:54:30 AM (26 years ago)

Author:

bird

Message:

Corrections, DB optimizations, and some new features in StateUpd.

File:

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

trunk/tools/database/CreateTables.sql

@@ -1 @@
--- $Id: CreateTables.sql,v 1.3 2000-02-11 23:54:24 bird Exp $
+-- $Id: CreateTables.sql,v 1.4 2000-02-12 23:54:29 bird Exp $
 --
 -- Create all tables.
@@ -38 +38 @@
     updated  TINYINT  NOT NULL DEFAULT 0,
     UNIQUE i1(refcode, aliasfn),
-    UNIQUE i1a(aliasfn, name, dll),
-    UNIQUE i1b(aliasfn, dll, refcode),
+    UNIQUE i1a(dll, aliasfn, refcode),
+    UNIQUE i1b(aliasfn, name, dll),
     UNIQUE i1c(aliasfn, intname, dll, refcode),
     UNIQUE i2(name, dll, refcode),