From daa2343e9361296a0626b720e1de51f2d632f823 Mon Sep 17 00:00:00 2001 From: Preston Cody Date: Sun, 4 Jun 2006 04:37:02 +0000 Subject: updated some scire database interface files fixed some queries fixed the exporter pages (as useless as they are now). svn path=/; revision=91 --- docs/moria2.sql | 6 ++++++ docs/scire.sql | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) (limited to 'docs') diff --git a/docs/moria2.sql b/docs/moria2.sql index 108ebb8..6bb6439 100644 --- a/docs/moria2.sql +++ b/docs/moria2.sql @@ -15,3 +15,9 @@ INSERT INTO profiles values ('printerserver', 'printerserverprofile.xml', 'Print INSERT INTO profiles values ('mta', 'mtaprofile.xml', 'MTAs use this profile', 'gentoo'); INSERT INTO users values ('root','444mwGdhEKuO.','Root User'); + +INSERT INTO jobs values (1, 1, 'Update', 5, 'emerge sync', NOW(), NOW(), NOW(), NOW(), 'Scheduled', 'root', 'Regular Update'); +INSERT INTO jobs values (2, 1, 'Install Packages', 5, 'emerge cups', NOW(), NOW(), NOW(), NOW(), 'In Progress', 'root', 'Adding cups'); +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 postrix', NOW(), NOW(), NOW(), NOW(), 'Scheduled', 'root', 'Adding postfix, cause its an mta duh.'); diff --git a/docs/scire.sql b/docs/scire.sql index abbc4a3..cdb0c3f 100644 --- a/docs/scire.sql +++ b/docs/scire.sql @@ -111,7 +111,7 @@ CREATE TABLE scripts ( name VARCHAR(128) NOT NULL, description VARCHAR(255), location VARCHAR(255), - data TEXT, + script_data TEXT, log_location VARCHAR(255), success_code VARCHAR(32), run_as VARCHAR(255) -- cgit v1.2.3-65-gdbad