Changes between Version 1 and Version 2 of GenericTrac

Timestamp:

Dec 8, 2006, 8:47:05 PM (17 years ago)

Author:

Christian Boos

Comment:

Some refinement to the table definitions

GenericTrac

@@ -43 +43 @@
 -- record Milestone change metadata
 --
-create table milestone_journal (
+create table milestone_rev (
  tid            int primary key,
  date           int,
@@ -55 +55 @@
 create index milestone_authname_idx on milestone_journal ( authname, authenticated );
 
--- record Milestone changed properties
+-- Track changes of Milestone properties
 --
 create table milestone_history (
@@ -64 +64 @@
  unique (tid, id)
 );
+
+-- record Milestone metadata
+--
+create table milestone_schema (
+ name     text primary key,
+ type     text,
+ detail   text,
+ value    text,
+ order    int,
+ revprop  char
+);
 }}}