summaryrefslogtreecommitdiffstats
path: root/pbs-data.sql
diff options
context:
space:
mode:
authorSimon2011-03-14 13:18:21 +0100
committerSimon2011-03-14 13:18:21 +0100
commitc4ab2b2f9a88409fbd78325a4d2c19fcb4ed340c (patch)
treea2e6fe7eaa589ad71b4df87d74809c03ff80e403 /pbs-data.sql
parentResource an alphasession angepasst (diff)
downloadpbs2-c4ab2b2f9a88409fbd78325a4d2c19fcb4ed340c.tar.gz
pbs2-c4ab2b2f9a88409fbd78325a4d2c19fcb4ed340c.tar.xz
pbs2-c4ab2b2f9a88409fbd78325a4d2c19fcb4ed340c.zip
Membership in Session eingefügt, Filtertypes nur einmal per Script einfügen, auskommentierten Code entfernt
Diffstat (limited to 'pbs-data.sql')
-rw-r--r--pbs-data.sql10
1 files changed, 0 insertions, 10 deletions
diff --git a/pbs-data.sql b/pbs-data.sql
index a1f1c1b..5035bfa 100644
--- a/pbs-data.sql
+++ b/pbs-data.sql
@@ -1,16 +1,6 @@
USE pbs;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--- Insert Filtertypes
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'IP');
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'MAC');
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'PoolID');
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'BootIso');
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Membership');
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Group');
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Time');
-INSERT INTO `pbs`.`pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (NULL, 'Client');
-
-- Insert example data for filters
INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES (NULL , 'testgruppe1', NULL);
INSERT INTO `pbs`.`pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES (NULL, 'Mr.Test', 'te', 'st', NULL, NULL, NULL, NULL, NULL, '', '', 'test', '', '');