maint/update-iserv1-iserv2-test.old-rooms.sql

   1 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');
   2 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');
   3 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');
   4 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');
   5 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');
   6 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');
   7 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');
   8 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');
   9 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');
  10 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');
  11 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');
  12 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');
  13 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');
  14 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');
  15 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');
  16 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');
  17 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');
  18 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');
  19 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');
  20 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');
  21 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');
  22 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');
  23 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');
  24 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');
  25 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');
  26 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');
  27 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');
  28 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');
  29 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');
  30 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');
  31 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');
  32 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');
  33 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');
  34 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');
  35 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');
  36 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');
  37 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');
  38 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');
  39 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');
  40 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');
  41 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');
  42 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');
  43 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');
  44 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');
  45 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');
  46 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');
  47 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');
  48 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');
  49 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');
  50 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');
  51 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');
  52 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');
  53 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');
  54 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');
  55 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');
  56 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');
  57 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');
  58 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');
  59 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');
  60 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');
  61 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');
  62 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');
  63 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');
  64 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');
  65 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');
  66 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');
  67 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');
  68 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');
  69 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');
  70 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');
  71 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');
  72 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');
  73 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');
  74 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');
  75 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');