updated some scire database interface files

fixed some queries
fixed the exporter pages (as useless as they are now).

svn path=/; revision=91

2 files changed, 7 insertions, 1 deletions

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)