diff options
| -rwxr-xr-x | src/badge_db.c | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/badge_db.c b/src/badge_db.c index 619f3f2..9830c43 100755 --- a/src/badge_db.c +++ b/src/badge_db.c @@ -30,25 +30,25 @@ #define CREATE_BADGE_TABLE " \ PRAGMA journal_mode = PERSIST; \ PRAGMA synchronous = FULL; \ -create table if not exists badge_data ( \ +CREATE TABLE IF NOT EXISTS badge_data ( \ uid INTEGER, \ pkgname TEXT NOT NULL, \ writable_pkgs TEXT, \ - badge INTEGER default 0, \ + badge INTEGER DEFAULT 0, \ rowid INTEGER PRIMARY KEY AUTOINCREMENT, \ UNIQUE (uid, pkgname) \ ); \ -create table if not exists badge_option ( \ +CREATE TABLE IF NOT EXISTS badge_option ( \ uid INTEGER, \ pkgname TEXT NOT NULL, \ - display INTEGER default 1, \ + display INTEGER DEFAULT 1, \ UNIQUE (uid, pkgname) \ ); \ -create table if not exists badge_setting ( \ +CREATE TABLE IF NOT EXISTS badge_setting ( \ uid INTEGER, \ pkgname TEXT NOT NULL, \ appid TEXT NOT NULL, \ - allow_to_display INTEGER default 1, \ + allow_to_display INTEGER DEFAULT 1, \ UNIQUE (uid, pkgname, appid) \ ); " |