bring the seed data a bit more up to date.

permissions now sync'd with the phpgacl_seed data.
clients and scripts updated.

svn path=/; revision=205

1 files changed, 3 insertions, 16 deletions

diff --git a/docs/scire2.sql b/docs/scire2.sql
index 7378c4c..3f7a3e5 100644
--- a/docs/scire2.sql
+++ b/docs/scire2.sql
@@ -3,29 +3,16 @@ use scire;
 INSERT INTO users (userid, username, password, email, phone, pager, real_name, comment) values (1, 'root','444mwGdhEKuO.', 'root@localhost.com', '', '', 'Root User', 'This is the comment for the root user.');
 INSERT INTO users (userid, username, password, email, phone, pager, real_name, comment) values (2, 'codeman','444mwGdhEKuO.', 'codeman@localhost.com', '', '', 'Preston Cody', 'Project lead and developer.');
 
-INSERT INTO permissions (permid, name, description, creator) values (1, 'Update Packages', 'This permission is to allow the upgrading of packages.', 1);
+INSERT INTO `permissions` VALUES (0,'View Users','Able to list the users',1,'2007-03-26 01:29:28','Default'),(23,'Test Permission 1','this is only a test.',1,'2007-03-26 02:20:40','Default'),(24,'Add ClientGroup','In the clients section, lets you add a group of clients.',2,'2007-04-01 17:03:11','Default'),(25,'Edit ClientGroup','Allows editing of the name and parent of a clientgroup.',2,'2007-04-01 17:07:32','Default'),(26,'Delete ClientGroup','deleting of a clientgroup.  clients within move to parent.',2,'2007-04-01 17:08:39','Default'),(27,'Assign Permission','allows assigning permissions of users to clients.  This is a very important permission!',2,'2007-04-01 17:52:25','Default'),(28,'View Permissions','see the list of active permissions.',2,'2007-04-01 17:53:17','Default'),(29,'Edit Client','edit client information.',2,'2007-04-01 18:10:02','Default'),(30,'Delete Client','remove a client.',2,'2007-04-01 18:10:21','Default'),(31,'Change User Pass/Name','If set, the ability to change a user\'s password will be enabled.',1,'2007-04-01 21:16:08','Default'),(32,'Add UserGroup','allows creation of usergroups.',1,'2007-04-01 23:18:59','Default');
 
-INSERT INTO scripts (scriptid, name, description, location, script_data, log_location, success_code, run_as, priority, permission, pp_location, pp_script_data) values (100, 'Gentoo Update Script', 'This script will run emerge sync and emerge -u world, logging the results.', '', '#!/bin/bash \n emerge sync \n emerge -u world', '/var/log/scire/updatelog.txt', 0, 'root', 5, 1, '', '');
-INSERT INTO scripts (scriptid, name, description, location, script_data, log_location, success_code, run_as, priority, permission, pp_location, pp_script_data) values (101, 'Gentoo Install Package Script', 'This script will run emerge on a given package and log the results.', '', '#!/bin/bash \n emerge %%package%%', '/var/log/scire/installlog.txt', 0, 'root', 2, 1, '', '');
-INSERT INTO scripts (scriptid, name, description, location, script_data, log_location, success_code, run_as, priority, permission, pp_location, pp_script_data) values (102, 'Gentoo Uninstall Package Script', 'This script will run emerge unmerge on a given package and log the results.', '', '#!/bin/bash \n emerge unmerge', '/var/log/scire/uninstalllog.txt', 0, 'root', 2, 1, '', '');
-INSERT INTO scripts (scriptid, name, description, location, script_data, log_location, success_code, run_as, priority, permission, pp_location, pp_script_data) values (103, 'Gentoo Rollback Script', 'This script will roll back a given package to its previous version, logging the results.', '', '#!/bin/bash \n emerge -C && emerge ', '/var/log/scire/rollbacklog.txt', 0, 'root', 1, 1, '', '');
-INSERT INTO scripts (scriptid, name, description, location, script_data, log_location, success_code, run_as, priority, permission, pp_location, pp_script_data) values (104, 'Gentoo PackageList Script', 'This script will return a list of packages installed on the system and the current version of those packages.', '', '#!/bin/bash \n %%tag1%% %%tag2%%', '/var/log/scire/packagelistlog.txt', 0, 'nobody', 8, 1, '', '');
+INSERT INTO `scripts` VALUES (100,'Gentoo Update Script','This script will run emerge sync and emerge -u world, logging the results.','','#!/bin/bash \n emerge sync \n emerge -u world','/var/log/scire/updatelog.txt','0','root',5,1,'',''),(101,'Gentoo Install Package Script','This script will run emerge on a given package and log the results.','','#!/bin/bash\nemerge --nocolor --nospinner --quiet -u world','/var/log/scire/installlog.txt','0','root',2,1,'',''),(102,'Gentoo Uninstall Package Script','This script will run emerge unmerge on a given package and log the results.','','#!/bin/bash \n emerge unmerge','/var/log/scire/uninstalllog.txt','0','root',2,1,'',''),(103,'Gentoo Rollback Script','This script will roll back a given package to its previous version, logging the results.','','#!/bin/bash \n emerge -C && emerge ','/var/log/scire/rollbacklog.txt','0','root',1,1,'',''),(104,'Gentoo PackageList Script','This script will return a list of packages installed on the system and the current version of those packages.','','#!/bin/bash \n %%tag1%% %%tag2%%','/var/log/scire/packagelistlog.txt','0','nobody',8,1,'',''),(105,'install_vim','This will emerge vim for gentoo','Embedded','#!/bin/bash\r\nemerge vim\r\n	','','0','root',1,0,'Embedded',''),(106,'install ufed','this installs ufed, a stupid little prog that helps with USE flags','Embedded','#!/bin/bash\r\nemerge ufed','','0','root',1,0,'Embedded','');
 
 INSERT INTO os (osid, osname, update_script, install_script, uninstall_script, rollback_script, packagelist_script) values (1,'Gentoo Linux',100 ,101 ,102 ,103, 104 );
 
 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 (clientid, assetid, digest, cert, hostname, mac, ip, gli_profile, osid, status, contact, installtime) values (1, 'ASSET01', 'D0:31:71:87:87:5D:F9:75:95:49:D9:9A:62:A0:6E:BB:21:0B:AE:E9', '', 'testhostlead', '00:0a:0b:0c:0d:0e', '192.168.3.4', 1, 1, 'Active', 2, '2006-01-01 00:00:00');
-
-INSERT INTO clients (clientid, assetid, digest, cert, hostname, mac, ip, gli_profile, osid, status, contact, installtime) values (2, 'ASSET02', '00:01:02:03:87:5D:F9:75:95:49:D9:9A:62:A0:6E:BB:21:0B:AE:E9', '', 'testhostslave', '00:0a:0a:0a:0d:0e', '192.168.3.5', 1, 1, 'Pending', 2, NOW() );
-
-INSERT INTO clients (clientid, assetid, digest, cert, hostname, mac, ip, gli_profile, osid, status, contact, installtime) values (3, 'MTA ASSET03', '08:07:06:05:87:5D:F9:75:95:49:D9:9A:62:A0:6E:BB:21:0B:AE:E9', '', 'testhostmtalead', '0b:0b:0b:0c:0d:0e', '192.168.3.6', 2, 1, 'Inactive', 2, NOW());
-
-INSERT INTO clients (clientid, assetid, digest, cert, hostname, mac, ip, gli_profile, osid, status, contact, installtime) values (4, 'MTA ASSET04', '11:22:33:33:33:5D:F9:75:95:49:D9:9A:62:A0:6E:BB:21:0B:AE:E9', '', 'testhostmtaslave', '0c:0c:0c:0c:0d:0e', '192.168.3.7', 2,1, 'Active', 2, '2005-12-25 00:00:00');
-
+INSERT INTO `clients` VALUES (3,'ASSET02',NULL,'testclient','00:01:02:03:04:0A','1.2.3.4',1,1,'active',2,'0000-00-00 00:00:00',''),(5,'ASSET05',NULL,'testclient2','00:01:02:03:04:05','192.168.1.11',1,1,'active',1,'0000-00-00 00:00:00','sampledigest');
 
 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);