Changeset 27102d5 for src/sql/sqlengine.cpp

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:

• src/sql/sqlengine.cpp (modified) (4 diffs)

src/sql/sqlengine.cpp

@@ -52 +52 @@
         QDir::home().mkdir(".fosdem");
     databaseName = QDir::homePath() + "/.fosdem/" + "fosdem.sqlite";
-
+qDebug()<<databaseName;
     login("QSQLITE",databaseName);
 }
@@ -120 +120 @@
     }
 }
+
 
 void SqlEngine::addPersonToDB(QHash<QString,QString> &aPerson)
@@ -233 +234 @@
             FOREIGN KEY(xid_activity) REFERENCES ACTIVITY(id))");
 
-        query.exec("CREATE VIRTUAL TABLE VIRTUAL_EVENT using fts3 ( \
+        // TBD Virtual tables compatibility (waiting for Marek). Temporary non virtual VIRTUAL_TABLE below: To be deleted
+/*        query.exec("CREATE VIRTUAL TABLE VIRTUAL_EVENT using fts3 ( \
             xid_conference INTEGER  NOT NULL, \
             id INTEGER NOT NULL , \
@@ -241 +243 @@
             description VARCHAR, \
             PRIMARY KEY (xid_conference,id))");
+*/
+        query.exec("CREATE TABLE VIRTUAL_EVENT ( \
+            xid_conference INTEGER  NOT NULL, \
+            id INTEGER NOT NULL , \
+            tag VARCHAR,title VARCHAR NOT NULL , \
+            subtitle VARCHAR, \
+            abstract VARCHAR, \
+            description VARCHAR, \
+            PRIMARY KEY (xid_conference,id))");
 
         query.exec("CREATE TABLE EVENT_PERSON ( \