sql/mtrack_repos.sql

diff --git a/sql/mtrack_repos.sql b/sql/mtrack_repos.sql
new file mode 100644 (file)
index 0000000..cc31fd3
--- /dev/null
+++ b/sql/mtrack_repos.sql
@@ -0,0 +1,17 @@
+CREATE TABLE mtrack_repos (
+  id int(11) NOT NULL AUTO_INCREMENT,
+  shortname varchar(64)  NOT NULL DEFAULT '',
+  scmtype varchar(16) NOT NULL DEFAULT '',
+  repopath varchar(255) NOT NULL DEFAULT '',
+  browserurl varchar(255) DEFAULT NULL DEFAULT '',
+  browsertype varchar(255) DEFAULT NULL DEFAULT '',
+  description text,
+  serverurl varchar(255) DEFAULT NULL DEFAULT '',
+  parent varchar(255) NOT NULL DEFAULT '',
+  clonedfrom int(11) DEFAULT NULL,
+  PRIMARY KEY (id)
+) ;
+ALTER TABLE mtrack_repos ADD COLUMN project_id INT(11) DEFAULT 0;
+ALTER TABLE mtrack_repos ADD INDEX plookup(project_id);
+
+ 
\ No newline at end of file