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

Timestamp:

Feb 18, 2000, 1:42:08 PM (26 years ago)

Author:

bird

Message:

Read more of the function header into the database.
Stateupd is changed to do this and the database is expanded with new fields.
The sample is partly updated.

File:

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

trunk/tools/database/CreateTables.sql

@@ -1 @@
--- $Id: CreateTables.sql,v 1.6 2000-02-15 13:31:06 bird Exp $
+-- $Id: CreateTables.sql,v 1.7 2000-02-18 12:42:05 bird Exp $
 --
 -- Create all tables.
@@ -37 +37 @@
     return   VARCHAR(64),
     updated  TINYINT  NOT NULL DEFAULT 0,
+    description TEXT,
+    remark      TEXT,
+    returndesc  TEXT,
+    sketch      TEXT,
+    equiv       TEXT,
+    time        TEXT,
     UNIQUE i1(refcode, aliasfn),
     UNIQUE i1a(dll, aliasfn, refcode),
@@ -112 +118 @@
     name     VARCHAR(64) NOT NULL,
     type     VARCHAR(64) NOT NULL,
-    description VARCHAR(128),
-    INDEX  i1(function, name(10)),
+    description TEXT,
+    INDEX  i1(function, name),
     UNIQUE u1(function, name)
 );