summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSeungha Son <seungha.son@samsung.com>2017-09-08 12:26:30 (GMT)
committerSeungha Son <seungha.son@samsung.com>2017-09-08 12:28:27 (GMT)
commit5d62086c49cc7bab9c71da4e7688aee3d2c0a11c (patch)
tree3a6773afc41ca3d0d5fbb6906c04f7d8eb4c382c
parent3466f1f396d17c5d5f575d0d1f86608f062aec5a (diff)
downloadbadge-5d62086c49cc7bab9c71da4e7688aee3d2c0a11c.zip
badge-5d62086c49cc7bab9c71da4e7688aee3d2c0a11c.tar.gz
badge-5d62086c49cc7bab9c71da4e7688aee3d2c0a11c.tar.bz2
Modify SQL cmd from lowercase to uppercaserefs/changes/25/148725/1
Signed-off-by: Seungha Son <seungha.son@samsung.com> Change-Id: I98c27f7f150f422f911ea49db5036aa9b1833cf1
-rwxr-xr-xsrc/badge_db.c12
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) \
); "