From d0d5a894f4e8219c33599697a1dacad56d1e363f Mon Sep 17 00:00:00 2001 From: Simon Date: Wed, 2 Mar 2011 17:17:12 +0100 Subject: Neue Filter hinzufügen --- simonFilterSqlTests.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 simonFilterSqlTests.sql (limited to 'simonFilterSqlTests.sql') diff --git a/simonFilterSqlTests.sql b/simonFilterSqlTests.sql new file mode 100644 index 0000000..95d15ab --- /dev/null +++ b/simonFilterSqlTests.sql @@ -0,0 +1,6 @@ +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', '', ''); +INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (NULL, '1', 'Testrolle', NULL); +INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (NULL, '1', '1', '1'); +INSERT INTO `pbs`.`pbs_bootmenu` (`bootmenuID`, `membershipID`, `title`, `time`) VALUES (NULL, '1', 'TestBootMenu', ''); +INSERT INTO `pbs`.`pbs_filter` (`filterID`, `membershipID`, `groupID`, `bootmenuID`, `title`, `description`, `created`, `priority`) VALUES (NULL, '1', '1', '1', 'TestFilter', NULL, '', '1'); -- cgit v1.2.3-55-g7522