From 0838598f3d24e1f81c039b8a2af1557979bee14a Mon Sep 17 00:00:00 2001 From: Loïc Guégan Date: Tue, 17 Sep 2024 10:35:33 +0200 Subject: Minor changes --- tropical/db.py | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) (limited to 'tropical/db.py') 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): -- cgit v1.2.3