sql/mtrack_wiki.sql

diff --git a/sql/mtrack_wiki.sql b/sql/mtrack_wiki.sql
new file mode 100644 (file)
index 0000000..c271cd2
--- /dev/null
+++ b/sql/mtrack_wiki.sql
@@ -0,0 +1,14 @@
+
+CREATE TABLE  mtrack_wiki (
+  id int(11)  NOT NULL AUTO_INCREMENT,
+  project_id int(11)  NOT NULL  DEFAULT 0,
+  path varchar(128)  NOT NULL  DEFAULT '',
+  wikidata longtext  NOT NULL,
+  created_id int(11)  NOT NULL  DEFAULT 0,
+  updated_id int(11)  NOT NULL  DEFAULT 0,
+  is_protected int(2)  NOT NULL COMMENT 'if so team only',
+  is_protected_company int(2)  NOT NULL  DEFAULT 0,
+  protected_group text  NOT NULL,
+  PRIMARY KEY (id),
+  INDEX lookup(project_id, path)
+);
\ No newline at end of file