summaryrefslogtreecommitdiffstats
path: root/simonFilterSqlTests.sql
diff options
context:
space:
mode:
authormichael pereira2011-03-04 03:21:32 +0100
committermichael pereira2011-03-04 03:21:32 +0100
commite2db1dc442e9f28fe666537a8af024c810912bb4 (patch)
treede16d36dff50a950dd963788689e18576a6db02f /simonFilterSqlTests.sql
parentInserted deleteForm (diff)
parentÄnderungen an den Filtern (diff)
downloadpbs2-e2db1dc442e9f28fe666537a8af024c810912bb4.tar.gz
pbs2-e2db1dc442e9f28fe666537a8af024c810912bb4.tar.xz
pbs2-e2db1dc442e9f28fe666537a8af024c810912bb4.zip
Merge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2
Conflicts: .zfproject.xml
Diffstat (limited to 'simonFilterSqlTests.sql')
-rw-r--r--simonFilterSqlTests.sql6
1 files changed, 6 insertions, 0 deletions
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');