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

Timestamp:

Jul 29, 2000, 11:19:34 PM (25 years ago)

Author:

bird

Message:

Added code tabel for function and dll type codes.

File:

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

trunk/tools/database/CreateTables.sql

@@ -1 @@
--- $Id: CreateTables.sql,v 1.12 2000-07-20 11:39:59 bird Exp $
+-- $Id: CreateTables.sql,v 1.13 2000-07-29 21:19:34 bird Exp $
 --
 -- Create all tables.
@@ -28 +28 @@
 );
 
+
+
+--
+-- Support table for Codes
+--
+CREATE TABLE code (
+    codegroup   CHAR(4) NOT NULL,
+    code        CHAR(4) NOT NULL,
+    description VARCHAR(128) NOT NULL,
+    UNIQUE  u1(codegroup, code)
+);
 
 
@@ -137 +148 @@
     INDEX  i4(dll, file),
     INDEX  i5(file),
+    INDEX  i6(state),
     UNIQUE u1(refcode),
     UNIQUE u2(name, dll),