#define __RUA_SCHEMA_H__
#define CREATE_RUA_HISTORY_TABLE " \
-PRAGMA journal_mode = PERSIST; \
+PRAGMA journal_mode = OFF; \
\
CREATE TABLE IF NOT EXISTS rua_history ( \
- id INTEGER PRIMARY KEY, \
pkg_name TEXT, \
app_path TEXT, \
arg TEXT, \
- launch_time INTEGER \
+ launch_time INTEGER, \
+ instance_id TEXT, \
+ instance_name TEXT, \
+ icon TEXT, \
+ uri TEXT, \
+ PRIMARY KEY(pkg_name, instance_id) \
);"
-
#define CREATE_RUA_STAT_TABLE " \
+PRAGMA journal_mode = OFF; \
+\
CREATE TABLE if not exists rua_panel_stat ( \
-caller_panel TEXT NOT NULL, \
-rua_stat_tag TEXT NOT NULL, \
-score INTEGER DEFAULT 0, \
-PRIMARY KEY(rua_stat_tag, caller_panel) \
+ caller_panel TEXT NOT NULL, \
+ rua_stat_tag TEXT NOT NULL, \
+ score INTEGER DEFAULT 0, \
+ PRIMARY KEY(rua_stat_tag, caller_panel) \
);"
-
/* table index */
enum {
- RUA_COL_ID = 0x00,
RUA_COL_PKGNAME,
RUA_COL_APPPATH,
RUA_COL_ARG,
- RUA_COL_LAUNCHTIME
+ RUA_COL_LAUNCHTIME,
+ RUA_COL_INSTANCE_ID,
+ RUA_COL_INSTANCE_NAME,
+ RUA_COL_ICON,
+ RUA_COL_URI,
};
enum {
RUA_SATA_COL_SCORE
};
-
-
#endif /* __RUA_SCHEMA_H__ */