test data for IServ2 update script

diff --git a/maint/update-iserv1-iserv2-test.old-rooms.sql b/maint/update-iserv1-iserv2-test.old-rooms.sql
new file mode 100644 (file)
index 0000000..b45a5ea
--- /dev/null
+++ b/maint/update-iserv1-iserv2-test.old-rooms.sql
@@ -0,0 +1,75 @@
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-06-03', 'Fallbeispiele', 'Computerraum 1', '13:00:00', '16', 'AG Erste Hilfe', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-10', 'WN10', 'Computerraum 1', '11:25:00', '18', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-17', 'WN10', 'Computerraum 1', '11:25:00', '21', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-05', 'Recherche el Café', 'Computerraum 1', '12:15:00', '22', 'Spanisch 9', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-16', 'Living in multicultural Britain', 'Computerraum 1', '09:35:00', '24', 'GK 12 ENGLISCH', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-05', 'Recherche', 'Computerraum 2', '11:25:00', '35', '8', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-05', 'Präsentation', 'Computerraum 2', '12:15:00', '37', 'PW1', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '1', '2007-09-03', 'Personalrat', 'Besprechungsraum 307', '11:25:00', '5', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-06', 'Recherche', 'Computerraum 2', '11:25:00', '39', '8m1', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-06', 'Recherche', 'Computerraum 2', '12:15:00', '12', 'Fr2', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('09:20:00', '1', '2008-05-08', 'Informatik 7m1', 'Computerraum 2', '07:45:00', '49', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-10', 'Presentation', 'Computerraum 1', '09:35:00', '52', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-11', 'Presenattion', 'Computerraum 1', '09:35:00', '55', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('09:20:00', '0', '2008-06-20', 'Reports', 'Computerraum 2', '07:45:00', '42', 'LK EN', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-03', 'Presentaion', 'Computerraum 1', '09:35:00', '41', '11 C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-11', 'Presentation', 'Computerraum 1', '11:25:00', '60', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-04', 'Presentation', 'Computerraum 1', '09:35:00', '44', '11 B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-06', 'BUB-Besprechung', 'Besprechungsraum 307', '12:15:00', '48', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-24', 'anders sitzen', 'Computerraum 1', '09:35:00', '62', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-25', 'Mal anders sitzen', 'Computerraum 1', '09:35:00', '64', '11b', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-06', 'BUB Besprechung', 'Besprechungsraum 307', '10:25:00', '8', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-04', 'Presentation', 'Computerraum 1', '11:25:00', '46', '11 C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-26', 'Unterricht', 'Computerraum 1', '10:25:00', '66', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-07-01', 'Presentation', 'Computerraum 1', '09:35:00', '68', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-06-12', 'Komponieren', 'Computerraum 1', '13:00:00', '26', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-06-26', 'Komponieren', 'Computerraum 1', '13:00:00', '28', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-07-10', 'Komponieren', 'Computerraum 1', '13:00:00', '30', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-07-24', 'Komponieren', 'Computerraum 1', '13:00:00', '33', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-08-07', 'Komponieren', 'Computerraum 1', '13:00:00', '36', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-07-02', 'Presentation', 'Computerraum 1', '09:35:00', '70', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('09:20:00', '0', '2008-06-06', 'Reports', 'Computerraum 1', '07:45:00', '11', 'LK En', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-07-02', 'Presentation', 'Computerraum 1', '11:25:00', '72', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('09:20:00', '0', '2008-06-04', 'Unterricht', 'Computerraum 1', '07:45:00', '74', 'Re 11', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-16', 'Recherche', 'Computerraum 1', '11:25:00', '78', '11a', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-30', 'Recherche', 'Computerraum 1', '11:25:00', '80', '11a', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('15:25:00', '1', '2008-01-31', 'Informatik 7m2', 'Computerraum 1', '13:50:00', '1', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('15:25:00', '1', '2007-08-28', 'Informatik 11', 'Computerraum 1', '13:50:00', '0', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('09:20:00', '0', '2008-06-02', 'recherche', 'Computerraum 2', '07:45:00', '6', 'roland.hieber', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-03', 'Reports', 'Computerraum 1', '11:25:00', '7', 'LK En', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('09:20:00', '0', '2008-06-02', 'Neanderthaler', 'Computerraum 1', '08:35:00', '9', 'Bio Lk', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('15:25:00', '1', '2008-05-07', 'Informatik 12', 'Computerraum 1', '13:50:00', '2', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('08:30:00', '0', '2008-06-09', 'Recherche Klassenausflug', 'Computerraum 1', '07:45:00', '10', '7m2', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-17', 'Reports', 'Computerraum 2', '11:25:00', '13', 'LK EN', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-03', 'Internet-Recherche', 'Computerraum 2', '11:25:00', '14', 'Geschichte 12', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-03', 'Internet-Recherche', 'Computerraum 2', '12:15:00', '15', 'Geschichte 12', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('08:30:00', '0', '2008-06-05', 'WN10', 'Computerraum 1', '07:45:00', '17', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-03', 'Presentation', 'Computerraum 1', '10:25:00', '43', '11 C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('08:30:00', '0', '2008-06-12', 'WN10', 'Computerraum 1', '07:45:00', '20', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('16:15:00', '1', '2006-09-01', 'Systemadministration', 'Computerraum 1', '13:00:00', '3', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('16:15:00', '1', '2006-09-01', 'Systemadministration', 'Computerraum 2', '13:00:00', '4', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-05', 'Presentation', 'Computerraum 1', '10:25:00', '51', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-04', 'Presentation', 'Computerraum 1', '10:25:00', '45', '11 B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-10', 'Presentation', 'Computerraum 1', '10:25:00', '53', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '1', '2007-09-10', 'Online-Planspiel', 'Computerraum 1', '13:00:00', '19', 'WG + Wirtschaft', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('10:20:00', '0', '2008-06-05', 'Internetrecherche', 'Computerraum 1', '09:35:00', '23', '7m12s2', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-16', 'DVD Living...', 'Computerraum 1', '10:25:00', '32', 'GK 12 ENGLISCH', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-05', 'Präsentation', 'Computerraum 1', '11:25:00', '38', 'PW1', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-11', '11B', 'Computerraum 1', '10:25:00', '56', 'Presentation', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-12', 'Presentation', 'Computerraum 1', '10:25:00', '61', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-24', 'Presentation', 'Computerraum 1', '10:25:00', '63', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-06-25', 'Presentation', 'Computerraum 1', '10:25:00', '65', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-25', 'Presentation', 'Computerraum 1', '11:25:00', '67', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-06-05', 'Komponieren', 'Computerraum 1', '13:00:00', '25', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-06-19', 'Komponieren', 'Computerraum 1', '13:00:00', '27', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-07-03', 'Komponieren', 'Computerraum 1', '13:00:00', '29', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-07-17', 'Komponieren', 'Computerraum 1', '13:00:00', '31', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:45:00', '0', '2008-07-31', 'Komponieren', 'Computerraum 1', '13:00:00', '34', '', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-07-01', 'Presentation', 'Computerraum 1', '10:25:00', '69', '11C', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('11:10:00', '0', '2008-07-02', 'Presentation', 'Computerraum 1', '10:25:00', '71', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-07-03', 'Presentation', 'Computerraum 1', '11:25:00', '73', '11B', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('09:20:00', '0', '2008-06-04', 'Unterricht', 'Computerraum 2', '07:45:00', '75', 'Re 11', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-09', 'Recherche', 'Computerraum 1', '11:25:00', '77', '11a', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-02', 'Rercherche', 'Computerraum 1', '12:15:00', '76', '11a', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('13:00:00', '0', '2008-06-23', 'Recherche', 'Computerraum 1', '11:25:00', '79', '11a', 'roland.hieber');
+INSERT INTO rooms (timeend, fixed, date, reason, room, timebegin, id, class, act) VALUES ('12:10:00', '0', '2008-06-06', 'Recherche', 'Computerraum 1', '11:25:00', '40', '8m1', 'roland.hieber');