diff options
Diffstat (limited to 'tropical/db.py')
| -rw-r--r-- | tropical/db.py | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/tropical/db.py b/tropical/db.py index 15e083b..431fce8 100644 --- a/tropical/db.py +++ b/tropical/db.py @@ -1,6 +1,5 @@ import sqlite3, time, socket - class CalDB: __DBVERSION__="1" @@ -21,9 +20,9 @@ class CalDB: self.cur.execute('INSERT INTO infos VALUES("creation", "'+str(time.time())+'")') self.cur.execute('INSERT INTO infos VALUES("created_on", "'+socket.gethostname()+'")') # Calendars table - self.cur.execute("CREATE TABLE calendars(id INTEGER PRIMARY KEY, name TEXT, description TEXT, color TEXT)") + self.cur.execute("CREATE TABLE calendars(id INTEGER PRIMARY KEY, name TEXT, description TEXT, color TEXT, type INTEGER)") # Events table - self.cur.execute("CREATE TABLE events(id INTEGER PRIMARY KEY, name TEXT, calendar INTEGER, description TEXT, start REAL, end REAL, repeat TEXT, frequency INTEGER, FOREIGN KEY(calendar) REFERENCES calendars(id))") + self.cur.execute("CREATE TABLE events(id INTEGER PRIMARY KEY, name TEXT, calendar INTEGER, description TEXT, start REAL, end REAL, repeat INTEGER, frequency INTEGER, location INTEGER, FOREIGN KEY(calendar) REFERENCES calendars(id))") self.con.commit() def keyExists(self, db, key): |