Changeset 3865 for trunk/tools/database

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.

Location:

trunk/tools/database

Files:

• CreateTables.sql (modified) (2 diffs)
• States.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),

trunk/tools/database/States.sql

@@ -1 @@
--- $Id: States.sql,v 1.2 1999-12-02 12:05:47 bird Exp $
+-- $Id: States.sql,v 1.3 2000-07-19 21:29:36 bird Exp $
 --
 -- Insert states into the state table.
@@ -7 +7 @@
 DELETE FROM state;
 
+--      refcode color    weight  name                       description
 INSERT INTO state
-    VALUES (0, '#000080', 'Not Implemented', 'Not implemented.');
+    VALUES (0, '#000080',   0,  'Not Implemented',          'Not implemented.');
 INSERT INTO state
-    VALUES (1, '#0000FF', 'Stub', 'Stub-function. Does nothing.');
+    VALUES (1, '#0000FF',   5,  'Stub',                     'Stub-function. Does nothing.');
 INSERT INTO state
-    VALUES (2, '#808000', 'Partially', 'Partially implemented. Not Tested.');
+    VALUES (2, '#808000',  20,  'Partially',                'Partially implemented. Not Tested.');
 INSERT INTO state
-    VALUES (3, '#FFFF00', 'Partially Tested', 'Partially implemented. Tested and approved.');
+    VALUES (3, '#FFFF00',  25,  'Partially Tested',         'Partially implemented. Tested and approved.');
 INSERT INTO state
-    VALUES (4, '#008000', 'Completely', 'Completely implemented. Not tested.');
+    VALUES (4, '#008000',  90,  'Completely',               'Completely implemented. Not tested.');
 INSERT INTO state
-    VALUES (5, '#00FF00', 'Completely Tested', 'Completely implemented. Tested and approved.');
+    VALUES (5, '#00FF00', 100,  'Completely Tested',        'Completely implemented. Tested and approved.');
 INSERT INTO state
-    VALUES (6, '#808080', 'Open32 Partially', 'Partially implemented. Not Tested.');
+    VALUES (6, '#808080',  20,  'Open32 Partially',         'Partially implemented. Not Tested.');
 INSERT INTO state
-    VALUES (7, '#FFFF80', 'Open32 Partially Tested', 'Partially implemented. Tested and approved.');
+    VALUES (7, '#FFFF80',  25,  'Open32 Partially Tested',  'Partially implemented. Tested and approved.');
 INSERT INTO state
-    VALUES (8, '#008080', 'Open32 Completely', 'Completely implemented. Not tested.');
+    VALUES (8, '#008080',  90,  'Open32 Completely',        'Completely implemented. Not tested.');
 INSERT INTO state
-    VALUES (9, '#00FF80', 'Open32 Completely Tested', 'Completely implemented. Tested and approved.');
+    VALUES (9, '#00FF80', 100,  'Open32 Completely Tested', 'Completely implemented. Tested and approved.');
 INSERT INTO state
-    VALUES (99, '#FF0000', 'Unknown', 'The state of this function is unknown.');
+    VALUES (99, '#FF0000', 25,  'Unknown',                  'The state of this function is unknown.');