diff options
| author | Seungha Son <seungha.son@samsung.com> | 2017-09-08 21:26:30 +0900 |
|---|---|---|
| committer | Seungha Son <seungha.son@samsung.com> | 2017-09-08 21:28:27 +0900 |
| commit | 5d62086c49cc7bab9c71da4e7688aee3d2c0a11c (patch) | |
| tree | 3a6773afc41ca3d0d5fbb6906c04f7d8eb4c382c | |
| parent | 3466f1f396d17c5d5f575d0d1f86608f062aec5a (diff) | |
| download | badge-5d62086c49cc7bab9c71da4e7688aee3d2c0a11c.tar.gz badge-5d62086c49cc7bab9c71da4e7688aee3d2c0a11c.tar.bz2 badge-5d62086c49cc7bab9c71da4e7688aee3d2c0a11c.zip | |
Modify SQL cmd from lowercase to uppercase
Signed-off-by: Seungha Son <seungha.son@samsung.com>
Change-Id: I98c27f7f150f422f911ea49db5036aa9b1833cf1
| -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) \ ); " |