Changeset cec47c6 for src/fosdem.sql


Ignore:
Timestamp:
05/05/10 15:56:14 (12 years ago)
Author:
kirilma <kirilma@…>
Branches:
master, qt5
Children:
58eb7cc
Parents:
3cdaf7d
Message:

store path to conference map in database

path stored as additional field in conference table
if it's null or empty, "Show map" button is not shown
if existing database does not have the field, it will be automatically added

File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/fosdem.sql

    r3cdaf7d rcec47c6  
    1111    , timeslot_duration INTEGER
    1212    , active INTEGER DEFAULT 0
    13     , url VARCHAR UNIQUE);
    14 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");
     13    , url VARCHAR UNIQUE
     14    , map VARCHAR);
     15INSERT 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");
    1516CREATE TABLE TRACK ( id INTEGER  PRIMARY KEY AUTOINCREMENT  NOT NULL
    1617    , name VARCHAR UNIQUE NOT NULL );
Note: See TracChangeset for help on using the changeset viewer.