1 PRAGMA journal_mode = PERSIST;
3 CREATE TABLE IF NOT EXISTS mida (
4 id INTEGER PRIMARY KEY,
6 mime_type TEXT UNIQUE NOT NULL
9 CREATE TABLE IF NOT EXISTS svc (
10 id INTEGER PRIMARY KEY,
12 svc_name TEXT UNIQUE NOT NULL
15 DROP TABLE IF EXISTS system_svc;
17 CREATE TABLE IF NOT EXISTS system_svc (
18 id INTEGER PRIMARY KEY,
19 svc_name TEXT UNIQUE NOT NULL
23 INSERT INTO system_svc(svc_name) VALUES ("create_alarm");
24 INSERT INTO system_svc(svc_name) VALUES ("open_calendar");
25 INSERT INTO system_svc(svc_name) VALUES ("create_event");
26 INSERT INTO system_svc(svc_name) VALUES ("view_event");
27 INSERT INTO system_svc(svc_name) VALUES ("take_picture");
28 INSERT INTO system_svc(svc_name) VALUES ("record_video");
29 INSERT INTO system_svc(svc_name) VALUES ("read_barcode");
30 INSERT INTO system_svc(svc_name) VALUES ("search_contact");
31 INSERT INTO system_svc(svc_name) VALUES ("create_email");
32 INSERT INTO system_svc(svc_name) VALUES ("view_email");
33 INSERT INTO system_svc(svc_name) VALUES ("browse_file");
34 INSERT INTO system_svc(svc_name) VALUES ("create_memo");
35 INSERT INTO system_svc(svc_name) VALUES ("view_memo");
36 INSERT INTO system_svc(svc_name) VALUES ("create_message");
37 INSERT INTO system_svc(svc_name) VALUES ("view_message");
38 INSERT INTO system_svc(svc_name) VALUES ("search");
39 INSERT INTO system_svc(svc_name) VALUES ("make_videocall");
40 INSERT INTO system_svc(svc_name) VALUES ("make_voicecall");
41 INSERT INTO system_svc(svc_name) VALUES ("record_voice");
42 INSERT INTO system_svc(svc_name) VALUES ("play_music");
43 INSERT INTO system_svc(svc_name) VALUES ("browse_web");
44 INSERT INTO system_svc(svc_name) VALUES ("update_facebook");
45 INSERT INTO system_svc(svc_name) VALUES ("update_twitter");
46 INSERT INTO system_svc(svc_name) VALUES ("open_ebook");