Changeset f657e9c
- Timestamp:
- 06/22/11 21:12:32 (12 years ago)
- Branches:
- master, qt5
- Children:
- 865aab6
- Parents:
- 51529bd
- Location:
- src
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
src/create_tables.sql
r51529bd rf657e9c 11 11 , timeslot_duration INTEGER 12 12 , active INTEGER DEFAULT 0 13 , url VARCHAR UNIQUE13 , url VARCHAR 14 14 , map VARCHAR); 15 15 16 16 CREATE TABLE TRACK ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL 17 17 , xid_conference INTEGER -- NOT NULL 18 , name VARCHAR UNIQUE NOT NULL ); 18 , name VARCHAR NOT NULL 19 , UNIQUE (xid_conference, name)); 19 20 20 21 CREATE TABLE ROOM ( id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL 21 22 , xid_conference INTEGER -- NOT NULL 22 , name VARCHAR UNIQUE NOT NULL 23 , picture VARCHAR NOT NULL); 23 , name VARCHAR NOT NULL 24 , picture VARCHAR NOT NULL 25 , UNIQUE (xid_conference, name)); 24 26 25 27 CREATE TABLE PERSON ( id INTEGER PRIMARY KEY NOT NULL 26 28 , xid_conference INTEGER -- NOT NULL 27 , name VARCHAR UNIQUE NOT NULL); 29 , name VARCHAR NOT NULL 30 , UNIQUE (xid_conference, name)); 28 31 29 32 CREATE TABLE EVENT ( xid_conference INTEGER NOT NULL -
src/sql/sqlengine.cpp
r51529bd rf657e9c 117 117 query.bindValue(":day_change", -QTime::fromString(aConference["timeslot_duration"],TIME_FORMAT).secsTo(QTime(0,0))); 118 118 query.bindValue(":active", confsList.count() > 0 ? 0 : 1); 119 query.exec();119 if (!query.exec()) qDebug() << "Could not execute query to insert a conference:" << query.lastError(); 120 120 aConference["id"] = query.lastInsertId().toString(); // 'id' is assigned automatically 121 121 }
Note: See TracChangeset
for help on using the changeset viewer.