sql/mtrack_change.sql

diff --git a/sql/mtrack_change.sql b/sql/mtrack_change.sql
index e69de29..817ef21 100644 (file)
--- a/sql/mtrack_change.sql
+++ b/sql/mtrack_change.sql
@@ -0,0 +1,14 @@
+
+CREATE TABLE mtrack_change (
+  id int(11) NOT NULL AUTO_INCREMENT,
+  person_id int(11) DEFAULT 0,
+  ontable varchar(128) DEFAULT '',
+  onid int(11) NOT NULL DEFAULT 0,
+  changedate datetime NOT NULL,
+  rev varchar(32) NOT NULL DEFAULT '',
+  reason text ,
+  PRIMARY KEY (id)
+) ;
+
+ALTER TABLE mtrack_change ADD COLUMN rev varchar(64) NOT NULL DEFAULT '';
+ALTER TABLE mtrack_change ADD COLUMN branch varchar(64) NOT NULL DEFAULT '';