Ignore:
Timestamp:
01/18/10 10:22:57 (12 years ago)
Author:
fortefr <fortefr@…>
Branches:
master, qt5
Children:
8f25cb1
Parents:
8035cef
Message:

Temporal virtual_event change

File:
1 edited

Legend:

Unmodified
Added
Removed
  • src/sql/sqlengine.cpp

    r8035cef r27102d5  
    5252        QDir::home().mkdir(".fosdem");
    5353    databaseName = QDir::homePath() + "/.fosdem/" + "fosdem.sqlite";
    54 
     54qDebug()<<databaseName;
    5555    login("QSQLITE",databaseName);
    5656}
     
    120120    }
    121121}
     122
    122123
    123124void SqlEngine::addPersonToDB(QHash<QString,QString> &aPerson)
     
    233234            FOREIGN KEY(xid_activity) REFERENCES ACTIVITY(id))");
    234235
    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 ( \
    236238            xid_conference INTEGER  NOT NULL, \
    237239            id INTEGER NOT NULL , \
     
    241243            description VARCHAR, \
    242244            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))");
    243254
    244255        query.exec("CREATE TABLE EVENT_PERSON ( \
Note: See TracChangeset for help on using the changeset viewer.