, days INTEGER
, day_change INTEGER
, timeslot_duration INTEGER
- , active INTEGER DEFAULT 0);
-INSERT INTO "CONFERENCE" VALUES(1,'FOSDEM 2010','Free and Opensource Software Developers European Meeting','ULB (Campus Solbosch)','Brussels',1265414400,1265500800,2,28800,900,1);
+ , active INTEGER DEFAULT 0
+ , url VARCHAR UNIQUE
+ , map VARCHAR);
+INSERT INTO "CONFERENCE" VALUES(1,'FOSDEM 2010','Free and Opensource Software Developers European Meeting','ULB (Campus Solbosch)','Brussels',1265414400,1265500800,2,28800,900,1,"http://fosdem.org/2010/schedule/xml", ":/maps/campus.png");
CREATE TABLE TRACK ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
, name VARCHAR UNIQUE NOT NULL );
INSERT INTO "TRACK" VALUES(1,'Keynotes');
CREATE TABLE ROOM ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL
, name VARCHAR UNIQUE NOT NULL
, picture VARCHAR NOT NULL);
-INSERT INTO "ROOM" VALUES(1,'Janson','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(2,'Chavanne','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(3,'Ferrer','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(4,'Lameere','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(5,'H.1301','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(6,'UA2.114','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(7,'H.1302','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(8,'H.1308','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(9,'H.1309','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(10,'H.2213','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(11,'H.2214','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(12,'AW1.105','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(13,'AW1.120','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(14,'AW1.121','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(15,'AW1.124','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(16,'AW1.126','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(17,'Guillissen','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(18,'AY','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(19,'AW1.117','NOT DEFINED YET');
-INSERT INTO "ROOM" VALUES(20,'AW1.125','NOT DEFINED YET');
+INSERT INTO "ROOM" VALUES(1,'Janson', ':/maps/rooms/janson.png');
+INSERT INTO "ROOM" VALUES(2,'Chavanne', ':/maps/rooms/chavanne.png');
+INSERT INTO "ROOM" VALUES(3,'Ferrer', ':/maps/rooms/ferrer.png');
+INSERT INTO "ROOM" VALUES(4,'Lameere', ':/maps/rooms/lameere.png');
+INSERT INTO "ROOM" VALUES(5,'H.1301', ':/maps/rooms/h1301.png');
+INSERT INTO "ROOM" VALUES(6,'UA2.114', ':/maps/rooms/ua2114.png');
+INSERT INTO "ROOM" VALUES(7,'H.1302', ':/maps/rooms/h1302.png');
+INSERT INTO "ROOM" VALUES(8,'H.1308', ':/maps/rooms/h1308.png');
+INSERT INTO "ROOM" VALUES(9,'H.1309', ':/maps/rooms/h1309.png');
+INSERT INTO "ROOM" VALUES(10,'H.2213', ':/maps/rooms/h2213.png');
+INSERT INTO "ROOM" VALUES(11,'H.2214', ':/maps/rooms/h2214.png');
+INSERT INTO "ROOM" VALUES(12,'AW1.105', ':/maps/rooms/aw1105.png');
+INSERT INTO "ROOM" VALUES(13,'AW1.120', ':/maps/rooms/aw1120.png');
+INSERT INTO "ROOM" VALUES(14,'AW1.121', ':/maps/rooms/aw1121.png');
+INSERT INTO "ROOM" VALUES(15,'AW1.124', ':/maps/rooms/aw1124.png');
+INSERT INTO "ROOM" VALUES(16,'AW1.126', ':/maps/rooms/aw1126.png');
+INSERT INTO "ROOM" VALUES(17,'Guillissen', ':/maps/rooms/guillissen.png');
+INSERT INTO "ROOM" VALUES(18,'AY', ':/maps/rooms/ay.png');
+INSERT INTO "ROOM" VALUES(19,'AW1.117', ':/maps/rooms/aw1117.png');
+INSERT INTO "ROOM" VALUES(20,'AW1.125', ':/maps/rooms/aw1125.png');
CREATE TABLE PERSON ( id INTEGER PRIMARY KEY NOT NULL, name VARCHAR UNIQUE NOT NULL);
INSERT INTO "PERSON" VALUES(19,'Tias Guns');
INSERT INTO "PERSON" VALUES(22,'Peter Saint-Andre');
, description VARCHAR
, favourite INTEGER DEFAULT 0
, alarm INTEGER DEFAULT 0
- , PRIMARY KEY (xid_conference ,id) ON CONFLICT REPLACE
+ , PRIMARY KEY (xid_conference ,id)
, FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
, FOREIGN KEY(xid_track) REFERENCES TRACK(id));
INSERT INTO "EVENT" VALUES(1,819,1265446800,2700,1,'Podium','English','welcome','Welcome','','FOSDEM Opening Talk','FOSDEM was started under the name OSDEM (Open Source Developers of Europe Meeting) by Raphael Bauduin. Raphael says that, since he felt he lacked the brains to properly contribute to the open source community, he wanted to contribute by launching a European event in Brussels. It was an immediate success, with speakers coming from all over.
, xid_person INTEGER NOT NULL
, UNIQUE ( xid_conference , xid_event , xid_person ) ON CONFLICT REPLACE
, FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
- , FOREIGN KEY(xid_event) REFERENCES EVENT(id)
+ , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id)
, FOREIGN KEY(xid_person) REFERENCES PERSON(id));
INSERT INTO "EVENT_PERSON" VALUES(1,819,46);
INSERT INTO "EVENT_PERSON" VALUES(1,803,665);
, xid_room INTEGER NOT NULL
, UNIQUE ( xid_conference , xid_event , xid_room ) ON CONFLICT REPLACE
, FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
- , FOREIGN KEY(xid_event) REFERENCES EVENT(id)
+ , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id)
, FOREIGN KEY(xid_room) REFERENCES ROOM(id));
INSERT INTO "EVENT_ROOM" VALUES(1,819,1);
INSERT INTO "EVENT_ROOM" VALUES(1,803,1);
, url VARCHAR NOT NULL
, UNIQUE ( xid_conference , xid_event , url ) ON CONFLICT REPLACE
, FOREIGN KEY(xid_conference) REFERENCES CONFERENCE(id)
- , FOREIGN KEY(xid_event) REFERENCES EVENT(id));
+ , FOREIGN KEY(xid_conference, xid_event) REFERENCES EVENT(xid_conference, id));
INSERT INTO "LINK" VALUES(1421,1,809,'Homepage','http://sourceware.org/systemtap/');
INSERT INTO "LINK" VALUES(1422,1,808,'Flapjack','http://flapjack-project.com/');
INSERT INTO "LINK" VALUES(1423,1,808,'cucumber-nagios','http://auxesis.github.com/cucumber-nagios');
ToastFreeware / toast / confclerk.git / blobdiff