summaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
Diffstat (limited to 'docs')
-rw-r--r--docs/scire.sql4
-rw-r--r--docs/scire2.sql4
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');