From c4ab2b2f9a88409fbd78325a4d2c19fcb4ed340c Mon Sep 17 00:00:00 2001 From: Simon Date: Mon, 14 Mar 2011 13:18:21 +0100 Subject: Membership in Session eingefügt, Filtertypes nur einmal per Script einfügen, auskommentierten Code entfernt --- pbs-data.sql | 10 ---------- 1 file changed, 10 deletions(-) (limited to 'pbs-data.sql') 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', '', ''); -- cgit v1.2.3-55-g7522