test commit

svn path=/; revision=4

2 files changed, 114 insertions, 0 deletions

diff --git a/moria/moria.sql b/moria/moria.sql
new file mode 100644
index 0000000..9d4d1de
--- /dev/null
+++ b/moria/moria.sql
@@ -0,0 +1,90 @@
+--create database moria;
+use moria;
+drop table if exists modules;
+create table modules ( id INT NOT NULL default '0',
+name VARCHAR(50),
+long_name VARCHAR(150),
+description VARCHAR(250),
+main_content VARCHAR(90),
+author VARCHAR(50),
+distribution VARCHAR(50),
+category VARCHAR(30),
+homepage VARCHAR(90),           
+PRIMARY KEY (id)
+) TYPE=MyISAM;
+
+drop table if exists machines;
+create table machines ( 
+machine_id INT NOT NULL default '0',
+hostname VARCHAR(30) NOT NULL default 'hostname',
+mac VARCHAR(17) NOT NULL default '00:01:02:03:04:05',
+ip VARCHAR(15) NOT NULL default 'dhcp',
+profile VARCHAR(30),
+distribution VARCHAR(50),
+role VARCHAR(30),
+administrator VARCHAR(50),
+status VARCHAR(100),
+PRIMARY KEY (machine_id)
+) TYPE=MyISAM;
+
+drop table if exists profiles;
+create table profiles (
+profile_name VARCHAR(30),
+filename VARCHAR(90) NOT NULL,
+description VARCHAR(250),
+distribution VARCHAR(50),
+PRIMARY KEY (profile_name)
+) TYPE=MyISAM;
+
+drop table if exists groups;
+create table groups (
+profile_name VARCHAR(30) NOT NULL,
+machine_id INT NOT NULL
+) TYPE=MyISAM;
+
+drop table if exists users;
+create table users (
+username VARCHAR(30) NOT NULL,
+password VARCHAR(50) NOT NULL default 'invalid',
+real_name VARCHAR(60),
+PRIMARY KEY (username)
+) TYPE=MyISAM;
+
+drop table if exists roles;
+create table roles (
+role_name VARCHAR(30) NOT NULL,
+description VARCHAR(90),
+creator VARCHAR(30),
+PRIMARY KEY (role_name)
+) TYPE=MyISAM;
+
+drop table if exists user_role;
+create table user_role (
+username VARCHAR(30) NOT NULL,
+role_name VARCHAR(30) NOT NULL,
+PRIMARY KEY (username, role_name)
+) TYPE=MyISAM;
+
+--INSERT INTO jobs (client, cliengroup, jobtype, priority, jobparam) VALUES ("boxa", "webserver", "pkgupdate", 2, "apache")
+--INSERT INTO jobs (client, cliengroup, jobtype, priority, jobparam) VALUES ("boxa", "webserver", "cfgupdate", 3, "scp://server/etc/apache2/httpd2.conf")
+--INSERT INTO jobs (client, cliengroup, jobtype, priority, jobparam) VALUES ("boxa", "webserver", "runscript", 4, "scp://server/etc/apache2/updatesomething.sh")
+
+drop table if exists jobs;
+create table jobs (
+job_id INT NOT NULL,
+client_id INT NOT NULL,
+jobtype VARCHAR(30) NOT NULL,
+priority INT NOT NULL default 5,
+jobparam VARCHAR(300),
+timecreated TIMESTAMP NOT NULL,
+timetosend TIMESTAMP NOT NULL,
+timesent TIMESTAMP,
+timedone TIMESTAMP,
+status VARCHAR(50) NOT NULL,
+created_by VARCHAR(30) NOT NULL,
+description VARCHAR(250),
+PRIMARY KEY (job_id)
+) TYPE=MyISAM;
+
+grant all on moria.* to hobbit identified by 'hobbitpassword';
+grant all on moria.* to hobbit@localhost identified by 'hobbitpassword';
diff --git a/moria/moria2.sql b/moria/moria2.sql
new file mode 100644
index 0000000..68147ec
--- /dev/null
+++ b/moria/moria2.sql
@@ -0,0 +1,24 @@
+use moria;
+INSERT INTO modules values (1,'GLIMD','Gentoo Linux Installation Mangement Daemon','Description goes here and all that good stuff.','glimd.txt','Preston Cody','gentoo','deployment','http://www.gentoo.org/proj/en/releng/gli/');
+INSERT INTO modules values (2,'Exporter','Server Information Exporter','This is a utility that will take selected data from the central server about machines and export it into an XML format.','Exporter.php','Preston Cody',NULL,'information','http://www.gentoo.org/proj/en/releng/gli/');
+
+INSERT INTO machines values (1, 'testhostlead', '00:0a:0b:0c:0d:0e', '192.168.3.4', 'printerserver', 'gentoo', 'lead', 'Preston Cody', 'Installed');
+
+INSERT INTO machines values (2, 'testhostslave', '00:0a:0a:0a:0d:0e', '192.168.3.5', 'printerserver', 'gentoo', 'clone', 'Preston Cody', 'Not Installed');
+
+INSERT INTO machines values (3, 'testhostmtalead', '0b:0b:0b:0c:0d:0e', '192.168.3.6', 'mta', 'gentoo', 'lead', 'Preston Cody', 'Installed');
+
+INSERT INTO machines values (4, 'testhostmtaslave', '0c:0c:0c:0c:0d:0e', '192.168.3.7', 'mta', 'gentoo', 'clone', 'Preston Cody', 'Installed');
+
+INSERT INTO profiles values ('printerserver', 'printerserverprofile.xml', 'Printer Servers use this profile', 'gentoo');
+
+INSERT INTO profiles values ('mta', 'mtaprofile.xml', 'MTAs use this profile', 'gentoo');
+
+INSERT INTO users values ('root','444mwGdhEKuO.','Root User');
+INSERT INTO roles values ('root','Administrative Role','root');
+INSERT INTO user_role values ('root','root');
+--create table profiles (
+--profile_name VARCHAR(30),
+--filename VARCHAR(90) NOT NULL,
+--description VARCHAR(250),
+--distribution VARCHAR(50),