diff options
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/scire.sql | 4 | ||||
| -rw-r--r-- | docs/scire2.sql | 4 |
2 files changed, 5 insertions, 3 deletions
diff --git a/docs/scire.sql b/docs/scire.sql index 49021eb..8b4e14f 100644 --- a/docs/scire.sql +++ b/docs/scire.sql @@ -121,7 +121,7 @@ CREATE TABLE job_conditions ( # might also include data (partition full?) PRIMARY KEY (jobid), - FOREIGN KEY (jobid) REFERENCES jobs.jobid, + FOREIGN KEY (jobid) REFERENCES jobs.jobid ) ENGINE = MyISAM; DROP TABLE IF EXISTS scripts; @@ -231,7 +231,7 @@ CREATE TABLE dyn_tags ( tag VARCHAR(30) NOT NULL, tag_value VARCHAR(255), PRIMARY KEY (jobid, tag), - FOREIGN KEY (jobid) REFERENCES jobs.jobid, + FOREIGN KEY (jobid) REFERENCES jobs.jobid ) ENGINE = MyISAM; drop table if exists modules; diff --git a/docs/scire2.sql b/docs/scire2.sql index 3085ac0..c2ae47a 100644 --- a/docs/scire2.sql +++ b/docs/scire2.sql @@ -25,10 +25,12 @@ INSERT INTO os (osid, osname, update_script, install_script, uninstall_script, r INSERT INTO GLI_profiles (profileid, profile_name, location, description) values (1, 'printerserver', '/scire/gli_profiles/printerserver.xml', 'A typical printer server install profile. has like cups and shit.'); INSERT INTO GLI_profiles (profileid, profile_name, location, description) values (2, 'mta', '/scire/gli_profiles/mta.xml', 'A typical MTA install profile. has like very little except mailers.'); -INSERT INTO `clients` VALUES (3,'ASSET02',NULL,'testclient','00:01:02:03:04:0A','1.2.3.4',1,1,2,2,'0000-00-00 00:00:00',''),(5,'ASSET05',NULL,'testclient2','00:01:02:03:04:05','192.168.1.11',1,1,2,1,'0000-00-00 00:00:00','sampledigest'); +INSERT INTO `clients` VALUES (3,'ASSET02','sampledigest',NULL,'testclient','00:01:02:03:04:0A','1.2.3.4',1,1,2,2,'0000-00-00 00:00:00'),(5,'ASSET05','testdigest',NULL,'testclient2','00:01:02:03:04:05','192.168.1.11',1,1,2,1,'0000-00-00 00:00:00'); INSERT INTO jobs (jobid, priority, created, creator, permission, script, description, pending, failed) values (1, 1, NOW(), 2, 1, 100, 'Upgrading a package on mtalead', 1,0); INSERT INTO jobs_clients (jobid, clientid) values (1, 3); +INSERT INTO job_conditions (jobid, job_dependency, run_schedule, validity_period) values (1, 0, '*/15 * * * *', 4); + INSERT INTO settings (userid, setting_name, setting_value) values (1, 'start_page', 'users.php'); INSERT INTO settings (userid, setting_name, setting_value) values (1, 'theme', 'light_blue'); |