diff options
author | 2007-03-14 00:11:00 +0000 | |
---|---|---|
committer | 2007-03-14 00:11:00 +0000 | |
commit | d3db213e30e65ea92e53dd7dc51567baed028363 (patch) | |
tree | 9c3f4c9390f1d1dfce4ae3f5fd03925e1eecb15a /docs | |
parent | removing old html and templates directories so they don't confuse (diff) | |
download | scire-d3db213e30e65ea92e53dd7dc51567baed028363.tar.gz scire-d3db213e30e65ea92e53dd7dc51567baed028363.tar.bz2 scire-d3db213e30e65ea92e53dd7dc51567baed028363.zip |
updating the database schemas. the additions may be temporary tables.
svn path=/; revision=180
Diffstat (limited to 'docs')
-rw-r--r-- | docs/scire.sql | 17 | ||||
-rw-r--r-- | docs/scire2.sql | 4 |
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/'); |