updating the database schemas. the additions may be temporary tables.

svn path=/; revision=180

2 files changed, 18 insertions, 3 deletions

diff --git a/docs/scire.sql b/docs/scire.sql
index 06103f0..a839b78 100644
--- a/docs/scire.sql
+++ b/docs/scire.sql
@@ -209,9 +209,24 @@ CREATE TABLE GLI_profiles (
 ) ENGINE = MyISAM;
 
 DROP TABLE IF EXISTS dyn_tags;
+CREATE TABLE dyn_tags (
   jobid INT NOT NULL,
   tag VARCHAR(30) NOT NULL,
   tag_value VARCHAR(255),
   PRIMARY KEY (jobid, tag),
   FOREIGN KEY (jobid) REFERENCES jobs.jobid
-) ENGINE = MyISAM;
\ No newline at end of file
+) ENGINE = MyISAM;
+
+drop table if exists modules;
+create table modules ( 
+id INT NOT NULL default '0',
+name VARCHAR(50),
+long_name VARCHAR(150),
+description VARCHAR(250),
+path VARCHAR(90),
+author VARCHAR(50),
+distribution VARCHAR(50),
+category VARCHAR(30),
+homepage VARCHAR(90),           
+PRIMARY KEY (id)
+) TYPE=MyISAM;
diff --git a/docs/scire2.sql b/docs/scire2.sql
index 0e7c3d8..7378c4c 100644
--- a/docs/scire2.sql
+++ b/docs/scire2.sql
@@ -39,5 +39,5 @@ INSERT INTO settings (userid, setting_name, setting_value) values (2, 'clients_p
 #INSERT INTO jobs values  (3, 2, 'Install Packages', 6, 'emerge cups', NOW(), NOW(), NOW(), NOW(), 'Failed', 'root', 'Adding cups');
 #INSERT INTO jobs values  (4, 3, 'Update', 2, 'glsa-check', NOW(), NOW(), NOW(), NOW(), 'In Progress', 'root', 'Security Update');
 #INSERT INTO jobs values  (5, 3, 'Install Packages', 5, 'emerge postfix', NOW(), NOW(), NOW(), NOW(), 'Scheduled', 'root', 'Adding postfix, cause its an mta duh.');
-#INSERT INTO modules values (1,'GLIMD','Gentoo Linux Installation Mangement Daemon','Description goes here and all that good stuff.','glimd.txt','Preston Cody','gentoo','deployment','http://www.gentoo.org/proj/en/releng/gli/');
-#INSERT INTO modules values (2,'Exporter','Server Information Exporter','This is a utility that will take selected data from the central server about machines and export it into an XML format.','Exporter.php','Preston Cody',NULL,'information','http://www.gentoo.org/proj/en/releng/gli/');
+#INSERT INTO modules values (1,'Quickstart','Quickstart Installation Mangement Daemon','Description goes here and all that good stuff.','quickstart/index.php','Preston Cody','gentoo','deployment','http://www.gentoo.org/proj/en/releng/gli/');
+#INSERT INTO modules values (2,'Exporter','Server Information Exporter','This is a utility that will take selected data from the central server about machines and export it into an XML format.','Exporter/index.php','Preston Cody',NULL,'information','http://www.gentoo.org/proj/en/releng/gli/');