3 CREATE TABLE MSG_CONVERSATION_TABLE
5 CONV_ID INTEGER PRIMARY KEY ,
6 UNREAD_CNT INTEGER DEFAULT 0 ,
7 SMS_CNT INTEGER DEFAULT 0 ,
8 MMS_CNT INTEGER DEFAULT 0 ,
9 MAIN_TYPE INTEGER DEFAULT 0 ,
10 SUB_TYPE INTEGER DEFAULT 0 ,
11 MSG_DIRECTION INTEGER DEFAULT 0 ,
12 DISPLAY_TIME DATETIME ,
13 DISPLAY_NAME TEXT NOT NULL DEFAULT '' ,
14 MSG_TEXT TEXT NOT NULL DEFAULT '' ,
15 LAST_MSG_ID INTEGER DEFAULT 0
18 CREATE TABLE MSG_ADDRESS_TABLE
20 ADDRESS_ID INTEGER PRIMARY KEY ,
21 CONV_ID INTEGER NOT NULL ,
22 ADDRESS_TYPE INTEGER ,
23 RECIPIENT_TYPE INTEGER ,
24 ADDRESS_VAL TEXT NOT NULL DEFAULT '' ,
26 ADDR_BOOK_ID INTEGER ,
27 FIRST_NAME TEXT NOT NULL DEFAULT '' ,
28 LAST_NAME TEXT NOT NULL DEFAULT '' ,
29 MIDDLE_NAME TEXT NOT NULL DEFAULT '' ,
30 PREFIX TEXT NOT NULL DEFAULT '' ,
31 SUFFIX TEXT NOT NULL DEFAULT '' ,
32 IMAGE_PATH TEXT NOT NULL DEFAULT '' ,
35 FOREIGN KEY (CONV_ID) REFERENCES MSG_CONVERSATION_TABLE (CONV_ID)
38 CREATE TABLE MSG_FOLDER_TABLE
40 FOLDER_ID INTEGER PRIMARY KEY ,
41 FOLDER_NAME TEXT NOT NULL ,
42 FOLDER_TYPE INTEGER DEFAULT 0
45 CREATE TABLE MSG_MESSAGE_TABLE
47 MSG_ID INTEGER PRIMARY KEY ,
48 CONV_ID INTEGER NOT NULL ,
49 FOLDER_ID INTEGER NOT NULL ,
50 STORAGE_ID INTEGER NOT NULL ,
51 MAIN_TYPE INTEGER NOT NULL ,
52 SUB_TYPE INTEGER NOT NULL ,
53 DISPLAY_TIME DATETIME ,
54 DATA_SIZE INTEGER DEFAULT 0 ,
55 NETWORK_STATUS INTEGER DEFAULT 0 ,
56 READ_STATUS INTEGER DEFAULT 0 ,
57 PROTECTED INTEGER DEFAULT 0 ,
58 PRIORITY INTEGER DEFAULT 0 ,
59 MSG_DIRECTION INTEGER NOT NULL ,
60 SCHEDULED_TIME DATETIME ,
61 BACKUP INTEGER DEFAULT 0 ,
62 SUBJECT TEXT NOT NULL DEFAULT '' ,
63 MSG_DATA TEXT NOT NULL DEFAULT '' ,
64 THUMB_PATH TEXT NOT NULL DEFAULT '' ,
65 MSG_TEXT TEXT NOT NULL DEFAULT '' ,
66 ATTACHMENT_COUNT INTEGER DEFAULT 0 ,
67 SIM_INDEX INTEGER DEFAULT 0 ,
69 DPM_RESTRICTED INTEGER DEFAULT 0 ,
71 FOREIGN KEY (CONV_ID) REFERENCES MSG_CONVERSATION_TABLE (CONV_ID) ,
72 FOREIGN KEY (FOLDER_ID) REFERENCES MSG_FOLDER_TABLE (FOLDER_ID)
75 CREATE TABLE MSG_SIM_TABLE
79 MSG_ID INTEGER NOT NULL ,
81 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
84 CREATE TABLE MSG_PUSH_TABLE
86 MSG_ID INTEGER PRIMARY KEY ,
90 ID TEXT NOT NULL DEFAULT '' ,
91 HREF TEXT NOT NULL DEFAULT '' ,
92 CONTENT TEXT NOT NULL DEFAULT '' ,
94 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
97 CREATE TABLE MSG_CBMSG_TABLE
99 MSG_ID INTEGER PRIMARY KEY ,
100 CB_MSG_ID INTEGER NOT NULL ,
101 SERIAL_NUM INTEGER NOT NULL ,
103 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
106 CREATE TABLE MSG_SYNCML_TABLE
108 MSG_ID INTEGER PRIMARY KEY ,
109 EXT_ID INTEGER NOT NULL ,
110 PINCODE INTEGER NOT NULL ,
112 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
115 CREATE TABLE MSG_SCHEDULED_TABLE
117 MSG_ID INTEGER PRIMARY KEY ,
118 ALARM_ID INTEGER NOT NULL ,
120 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
123 CREATE TABLE MSG_SMS_SENDOPT_TABLE
125 MSG_ID INTEGER PRIMARY KEY ,
126 DELREP_REQ INTEGER NOT NULL ,
127 KEEP_COPY INTEGER NOT NULL ,
128 REPLY_PATH INTEGER NOT NULL ,
129 ENCODE_TYPE INTEGER NOT NULL ,
131 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
134 CREATE TABLE MSG_FILTER_TABLE
136 FILTER_ID INTEGER PRIMARY KEY ,
137 FILTER_TYPE INTEGER NOT NULL ,
138 FILTER_VALUE TEXT NOT NULL ,
139 FILTER_ACTIVE INTEGER DEFAULT 0
142 CREATE TABLE MSG_MMS_MESSAGE_TABLE
144 MSG_ID INTEGER PRIMARY KEY ,
145 TRANSACTION_ID TEXT NOT NULL DEFAULT '' ,
146 MESSAGE_ID TEXT NOT NULL DEFAULT '' ,
147 FWD_MESSAGE_ID TEXT NOT NULL DEFAULT '' ,
148 CONTENTS_LOCATION TEXT NOT NULL DEFAULT '' ,
149 FILE_PATH TEXT NOT NULL DEFAULT '' ,
150 VERSION INTEGER NOT NULL ,
151 DATA_TYPE INTEGER DEFAULT -1 ,
153 HIDE_ADDRESS INTEGER DEFAULT 0 ,
154 ASK_DELIVERY_REPORT INTEGER DEFAULT 0 ,
155 REPORT_ALLOWED INTEGER DEFAULT 0 ,
156 READ_REPORT_ALLOWED_TYPE INTEGER DEFAULT 0 ,
157 ASK_READ_REPLY INTEGER DEFAULT 0 ,
158 READ INTEGER DEFAULT 0 ,
159 READ_REPORT_SEND_STATUS INTEGER DEFAULT 0 ,
160 READ_REPORT_SENT INTEGER DEFAULT 0 ,
161 PRIORITY INTEGER DEFAULT 0 ,
162 KEEP_COPY INTEGER DEFAULT 0 ,
163 MSG_SIZE INTEGER NOT NULL ,
164 MSG_CLASS INTEGER DEFAULT -1 ,
165 EXPIRY_TIME DATETIME ,
166 CUSTOM_DELIVERY_TIME INTEGER DEFAULT 0 ,
167 DELIVERY_TIME DATETIME ,
168 MSG_STATUS INTEGER DEFAULT -1 ,
170 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
173 CREATE TABLE MSG_MMS_PREVIEW_INFO_TABLE
175 MSG_ID INTEGER NOT NULL ,
180 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
183 CREATE TABLE MSG_MMS_RECIPIENTS_TABLE
185 MSG_ID INTEGER NOT NULL ,
186 ADDRESS_TYPE INTEGER DEFAULT 0 ,
187 RECIPIENT_TYPE INTEGER DEFAULT 0 ,
188 ADDRESS_VAL TEXT NOT NULL DEFAULT '' ,
190 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
193 CREATE TABLE MSG_SMS_REPORT_TABLE
195 MSG_ID INTEGER NOT NULL ,
196 ADDRESS_VAL TEXT NOT NULL DEFAULT '' ,
198 STATUS_TYPE INTEGER ,
199 STATUS INTEGER DEFAULT 0 ,
203 CREATE TABLE MSG_REPORT_TABLE
205 MSG_ID INTEGER NOT NULL ,
206 ADDRESS_VAL TEXT NOT NULL DEFAULT '' ,
207 STATUS_TYPE INTEGER ,
208 STATUS INTEGER DEFAULT 0 ,
212 CREATE TABLE MSG_PUSHCFG_TABLE
214 PUSH_ID INTEGER PRIMARY KEY ,
215 CONTENT_TYPE TEXT NOT NULL DEFAULT '' ,
216 APP_ID TEXT NOT NULL DEFAULT '' ,
217 PKG_NAME TEXT NOT NULL DEFAULT '' ,
223 CREATE TABLE MSG_TMP_MSGID_TABLE
228 CREATE TABLE MSG_CB_CHANNEL_INFO_TABLE
230 CHANNEL_ID INTEGER PRIMARY KEY AUTOINCREMENT,
231 CHANNEL_ACTIVATION INTEGER DEFAULT 0,
232 CHANNEL_FROM INTEGER DEFAULT 0,
233 CHANNEL_TO INTEGER DEFAULT 0,
234 CHANNEL_NAME TEXT NOT NULL DEFAULT '',
235 SIM_INDEX INTEGER DEFAULT 0
238 CREATE TABLE MSG_MULTIPART_TABLE
240 _ID INTEGER PRIMARY KEY AUTOINCREMENT,
241 MSG_ID INTEGER NOT NULL ,
242 SEQ INTEGER DEFAULT 0,
247 CONTENT_LOCATION TEXT,
250 TCS_LEVEL INTEGER DEFAULT -1,
251 MALWARE_ALLOW INTEGER DEFAULT 0,
252 THUMB_FILE_PATH TEXT,
254 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
257 CREATE TABLE MSG_ADDRESS_TEMP_TABLE
259 ADDRESS_VAL TEXT NOT NULL DEFAULT ''
262 CREATE INDEX MSG_CONVERSATION_INDEX ON MSG_CONVERSATION_TABLE(CONV_ID);
263 CREATE INDEX MSG_FOLDER_INDEX ON MSG_FOLDER_TABLE(FOLDER_ID);
264 CREATE INDEX MSG_MESSAGE_INDEX ON MSG_MESSAGE_TABLE(MSG_ID, CONV_ID, FOLDER_ID);
266 INSERT INTO MSG_FOLDER_TABLE VALUES (1, 'INBOX', 1);
267 INSERT INTO MSG_FOLDER_TABLE VALUES (2, 'OUTBOX', 2);
268 INSERT INTO MSG_FOLDER_TABLE VALUES (3, 'SENTBOX', 2);
269 INSERT INTO MSG_FOLDER_TABLE VALUES (4, 'DRAFT', 3);
270 INSERT INTO MSG_FOLDER_TABLE VALUES (5, 'CBMSGBOX', 1);
271 INSERT INTO MSG_FOLDER_TABLE VALUES (6, 'SPAMBOX', 4);
273 INSERT INTO MSG_PUSHCFG_TABLE VALUES (1, 'text/vnd.wap.si', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 1, 0);
274 INSERT INTO MSG_PUSHCFG_TABLE VALUES (2, 'application/vnd.wap.sic', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 2, 0);
275 INSERT INTO MSG_PUSHCFG_TABLE VALUES (3, 'text/vnd.wap.sl', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 3, 0);
276 INSERT INTO MSG_PUSHCFG_TABLE VALUES (4, 'application/vnd.wap.slc', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 4, 0);
277 INSERT INTO MSG_PUSHCFG_TABLE VALUES (5, 'text/vnd.wap.co', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 5, 0);
279 INSERT INTO MSG_PUSHCFG_TABLE VALUES (6, 'application/vnd.wap.coc', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 6, 0);
281 INSERT INTO MSG_PUSHCFG_TABLE VALUES (7, 'application/vnd.wap.mms-message', 'X-Wap-Application-Id: x-wap-application:mms.ua', '', 0, 7, 0);
282 INSERT INTO MSG_PUSHCFG_TABLE VALUES (8, 'application/vnd.wap.sia', 'X-Wap-Application-Id: x-wap-application:push.sia', '', 0, 8, 0);
283 INSERT INTO MSG_PUSHCFG_TABLE VALUES (9, 'application/vnd.syncml.dm+wbxml', 'X-Wap-Application-Id: x-wap-application:push.syncml.dm', '', 0, 9, 0);
284 INSERT INTO MSG_PUSHCFG_TABLE VALUES (10, 'application/vnd.syncml.dm+xml', 'X-Wap-Application-Id: x-wap-application:push.syncml.dm', '', 0, 10, 0);
286 INSERT INTO MSG_PUSHCFG_TABLE VALUES (11, 'application/vnd.syncml.notification', 'X-Wap-Application-Id: x-wap-application:push.syncml.dm', '', 0, 11, 0);
287 INSERT INTO MSG_PUSHCFG_TABLE VALUES (12, 'application/vnd.syncml.ds.notification', 'X-Wap-Application-Id: x-wap-application:push.syncml.ds', '', 0, 12, 0);
288 INSERT INTO MSG_PUSHCFG_TABLE VALUES (13, 'application/vnd.syncml+wbxml', 'X-Wap-Application-Id:x-wap-application:push.syncml', '', 0, 13, 0);
289 INSERT INTO MSG_PUSHCFG_TABLE VALUES (14, 'application/vnd.wap.locc+wbxml', 'X-Wap-Application-Id: x-wap-application:loc.ua', '', 0, 14, 0);
290 INSERT INTO MSG_PUSHCFG_TABLE VALUES (15, 'application/vnd.wap.loc+xml', 'X-Wap-Application-Id: x-wap-application:loc.ua', '', 0, 15, 0);
292 INSERT INTO MSG_PUSHCFG_TABLE VALUES (16, 'application/vnd.oma.dd+xml', 'X-Wap-Application-Id: x-wap-application:loc.ua', '', 0, 16, 0);
293 INSERT INTO MSG_PUSHCFG_TABLE VALUES (17, 'application/vnd.oma.drm.message', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 17, 0);
294 INSERT INTO MSG_PUSHCFG_TABLE VALUES (18, 'application/vnd.oma.drm.content', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 18, 0);
295 INSERT INTO MSG_PUSHCFG_TABLE VALUES (19, 'application/vnd.oma.drm.rights+xml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 19, 0);
296 INSERT INTO MSG_PUSHCFG_TABLE VALUES (20, 'application/vnd.oma.drm.rights+wbxml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 20, 0);
298 INSERT INTO MSG_PUSHCFG_TABLE VALUES (21, 'application/vnd.oma.drm.ro+xml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 21, 0);
299 INSERT INTO MSG_PUSHCFG_TABLE VALUES (22, 'application/vnd.oma.drm.roap-pdu+xml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 22, 0);
300 INSERT INTO MSG_PUSHCFG_TABLE VALUES (23, 'application/vnd.oma.drm.roap-trigger+xml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 23, 0);
301 INSERT INTO MSG_PUSHCFG_TABLE VALUES (24, 'application/vnd.oma.drm.roap-trigger+wbxml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 24, 0);
302 INSERT INTO MSG_PUSHCFG_TABLE VALUES (25, 'text/vnd.wap.connectivity-xml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 26, 0);
304 INSERT INTO MSG_PUSHCFG_TABLE VALUES (26, 'application/vnd.wap.connectivity-wbxml', 'X-Wap-Application-Id: x-wap-samsung:provisioning.ua', '', 0, 27, 0);
305 INSERT INTO MSG_PUSHCFG_TABLE VALUES (27, 'application/x-wap-prov.browser-settings', 'X-Wap-Application-Id: x-wap-samsung:provisioning.ua', '', 0, 28, 0);
306 INSERT INTO MSG_PUSHCFG_TABLE VALUES (28, 'application/x-wap-prov.browser-bookmarks', 'X-Wap-Application-Id: x-wap-samsung:provisioning.ua', '', 0, 29, 0);
307 INSERT INTO MSG_PUSHCFG_TABLE VALUES (29, 'application/x-wap-prov.syncset+xml', 'X-Wap-Application-Id: x-wap-samsung:provisioning.ua', '', 0, 30, 0);
308 INSERT INTO MSG_PUSHCFG_TABLE VALUES (30, 'application/x-wap-prov.syncset+wbxml', 'X-Wap-Application-Id: x-wap-samsung:provisioning.ua', '', 0, 31, 0);
310 INSERT INTO MSG_PUSHCFG_TABLE VALUES (33, 'application/vnd.wv.csp.cir', 'X-Wap-Application-Id: x-wap-application:wv.ua', '', 0, 34, 0);
311 INSERT INTO MSG_PUSHCFG_TABLE VALUES (34, 'application/vnd.omaloc-supl-init', 'X-Wap-Application-Id: x-oma-application:ulp.ua', '', 0, 44, 0);
313 INSERT INTO MSG_CB_CHANNEL_INFO_TABLE VALUES (0, 1, 0, 65535, '', 1);
314 INSERT INTO MSG_CB_CHANNEL_INFO_TABLE VALUES (1, 1, 0, 65535, '', 2);