Changeset d06ae27 for src/fosdem.sql

Timestamp:

04/15/10 14:01:48 (12 years ago)

Author:

kirilma <kirilma@…>

Branches:

master, qt5

Children:

f5b68a4

Parents:

be9b645

Message:

store URL's for conferences

• use it at update
• let user update the url before request

File:

• src/fosdem.sql (modified) (1 diff)

src/fosdem.sql

@@ -10 +10 @@
     , 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);
+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");
 CREATE TABLE TRACK ( id INTEGER  PRIMARY KEY AUTOINCREMENT  NOT NULL
     , name VARCHAR UNIQUE NOT NULL );