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

Timestamp:

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

Author:

bird

Message:

Added column 'weigth' to the state table.
This column hold the weigth functions in that state should have when
calculating the total completion percentage.

File:

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

trunk/tools/database/CreateTables.sql

@@ -1 @@
--- $Id: CreateTables.sql,v 1.10 2000-07-18 22:13:20 bird Exp $
+-- $Id: CreateTables.sql,v 1.11 2000-07-19 21:29:36 bird Exp $
 --
 -- Create all tables.
@@ -15 +15 @@
     refcode TINYINT NOT NULL PRIMARY KEY,
     color   CHAR(7) NOT NULL,
+    weight  TINYINT NOT NULL,
     name    VARCHAR(32) NOT NULL,
-    description VARCHAR(128),
+    description VARCHAR(128) NOT NULL,
     UNIQUE u1(refcode),
     UNIQUE u2(name),