Changeset 27102d5 for src/sql/sqlengine.cpp
- Timestamp:
- 01/18/10 10:22:57 (13 years ago)
- Branches:
- master, qt5
- Children:
- 8f25cb1
- Parents:
- 8035cef
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
src/sql/sqlengine.cpp
r8035cef r27102d5 52 52 QDir::home().mkdir(".fosdem"); 53 53 databaseName = QDir::homePath() + "/.fosdem/" + "fosdem.sqlite"; 54 54 qDebug()<<databaseName; 55 55 login("QSQLITE",databaseName); 56 56 } … … 120 120 } 121 121 } 122 122 123 123 124 void SqlEngine::addPersonToDB(QHash<QString,QString> &aPerson) … … 233 234 FOREIGN KEY(xid_activity) REFERENCES ACTIVITY(id))"); 234 235 235 query.exec("CREATE VIRTUAL TABLE VIRTUAL_EVENT using fts3 ( \ 236 // TBD Virtual tables compatibility (waiting for Marek). Temporary non virtual VIRTUAL_TABLE below: To be deleted 237 /* query.exec("CREATE VIRTUAL TABLE VIRTUAL_EVENT using fts3 ( \ 236 238 xid_conference INTEGER NOT NULL, \ 237 239 id INTEGER NOT NULL , \ … … 241 243 description VARCHAR, \ 242 244 PRIMARY KEY (xid_conference,id))"); 245 */ 246 query.exec("CREATE TABLE VIRTUAL_EVENT ( \ 247 xid_conference INTEGER NOT NULL, \ 248 id INTEGER NOT NULL , \ 249 tag VARCHAR,title VARCHAR NOT NULL , \ 250 subtitle VARCHAR, \ 251 abstract VARCHAR, \ 252 description VARCHAR, \ 253 PRIMARY KEY (xid_conference,id))"); 243 254 244 255 query.exec("CREATE TABLE EVENT_PERSON ( \
Note: See TracChangeset
for help on using the changeset viewer.