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

Timestamp:

Aug 2, 2000, 3:22:34 AM (25 years ago)

Author:

bird

Message:

Added line (linenumber) to designnote and function.

File:

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

trunk/tools/database/CreateTables.sql

@@ -1 @@
--- $Id: CreateTables.sql,v 1.16 2000-08-02 01:01:36 bird Exp $
+-- $Id: CreateTables.sql,v 1.17 2000-08-02 01:22:34 bird Exp $
 --
 -- Create all tables.
@@ -111 +111 @@
     seqnbrfile  SMALLINT NOT NULL,
     seqnbr      INTEGER NOT NULL,
+    line        INTEGER  NOT NULL DEFAULT -1,
     title       TEXT,
     note        TEXT    NOT NULL,
@@ -138 +139 @@
     type     CHAR     NOT NULL DEFAULT 'A',
     updated  TINYINT  NOT NULL DEFAULT 0,
+    line     INTEGER  NOT NULL DEFAULT -1,
     description TEXT,
     remark      TEXT,