summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPreston Cody <codeman@gentoo.org>2008-01-01 00:10:46 +0000
committerPreston Cody <codeman@gentoo.org>2008-01-01 00:10:46 +0000
commite74adab4a9091388f1a57b29aca3683117bc6235 (patch)
tree2b2fa28245d8663cdcd8709bc36e422134ce532b
parentadd LOCK TABLES to grant lines. (diff)
downloadscire-e74adab4a9091388f1a57b29aca3683117bc6235.tar.gz
scire-e74adab4a9091388f1a57b29aca3683117bc6235.tar.bz2
scire-e74adab4a9091388f1a57b29aca3683117bc6235.zip
removing the cert field for the clients table.
svn path=/trunk/; revision=302
-rw-r--r--docs/scire.sql1
-rw-r--r--docs/scire2.sql2
2 files changed, 1 insertions, 2 deletions
diff --git a/docs/scire.sql b/docs/scire.sql
index b3c7a7d..d9a0c37 100644
--- a/docs/scire.sql
+++ b/docs/scire.sql
@@ -21,7 +21,6 @@ CREATE TABLE clients (
clientid INT NOT NULL PRIMARY KEY,
assetid VARCHAR(64) UNIQUE,
digest VARCHAR(128) UNIQUE,
- cert TEXT,
hostname VARCHAR(64) NOT NULL,
mac VARCHAR(17) NOT NULL,
ip VARCHAR(15) NOT NULL,
diff --git a/docs/scire2.sql b/docs/scire2.sql
index 7bf55f5..4d6251c 100644
--- a/docs/scire2.sql
+++ b/docs/scire2.sql
@@ -25,7 +25,7 @@ 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','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 `clients` VALUES (3,'ASSET02','sampledigest','testclient','00:01:02:03:04:0A','1.2.3.4',1,1,2,2,'0000-00-00 00:00:00'),(5,'ASSET05','testdigest','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);