summaryrefslogtreecommitdiffstats
path: root/pbs-data.sql
diff options
context:
space:
mode:
authorBjörn Geiger2011-03-10 21:48:48 +0100
committerBjörn Geiger2011-03-10 21:48:48 +0100
commitd70f09da9fe5e0eaadde22433761ed696a558fe9 (patch)
tree096476b8074a6cb12da0b05bee1589ab9aa15f8f /pbs-data.sql
parentbei Verknüpfungstabellen zusammengesetzter primary key erzeugt, Zend braucht... (diff)
parentMerge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff)
downloadpbs2-d70f09da9fe5e0eaadde22433761ed696a558fe9.tar.gz
pbs2-d70f09da9fe5e0eaadde22433761ed696a558fe9.tar.xz
pbs2-d70f09da9fe5e0eaadde22433761ed696a558fe9.zip
Merge branch 'master' of ssh://git.openslx.org/lsfks/master-teamprojekt/pbs2
Diffstat (limited to 'pbs-data.sql')
-rw-r--r--pbs-data.sql7
1 files changed, 6 insertions, 1 deletions
diff --git a/pbs-data.sql b/pbs-data.sql
index 01ec4a1..a1f1c1b 100644
--- a/pbs-data.sql
+++ b/pbs-data.sql
@@ -64,8 +64,11 @@ INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES
(10, 3, 10);
-- Insert Data for Sessions
+INSERT INTO `pbs`.`pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES
+(NULL, 'Config 1', '1', '1', 'Shellscirpt', UNIX_TIMESTAMP());
+
INSERT INTO `pbs`.`pbs_bootos` (`bootosID`, `configID`, `groupID`, `membershipID`, `title`, `description`, `path_init`, `path_kernel`, `defaultkcl`, `created`, `expires`, `public`) VALUES
-(1, NULL, 1, 1, 'BootOS 1', 'Description', '', '', '', '', NULL, 0);
+(1, 1, 1, 1, 'BootOS 1', 'Description', '', '', '', '', NULL, 0);
INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `path`, `serialnumber`, `created`, `expires`, `public`) VALUES
(1, 'BootISO 1', 1, 1, '', 1337, '', NULL, 1),
@@ -74,4 +77,6 @@ INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `pat
INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES
(3, '1', '2', '3', '4', '5', '6', '7', NULL, '1299612370', 'test', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a');
+INSERT INTO `pbs`.`pbs_session` (`sessionID`, `clientID`, `bootosID`, `bootisoID`, `time`, `ip`, `ip6`) VALUES (NULL, '1', '1', '1', UNIX_TIMESTAMP(), '1.1.1.2', NULL);
+