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 ''
17 CREATE TABLE MSG_ADDRESS_TABLE
19 ADDRESS_ID INTEGER PRIMARY KEY ,
20 CONV_ID INTEGER NOT NULL ,
21 ADDRESS_TYPE INTEGER ,
22 RECIPIENT_TYPE INTEGER ,
23 ADDRESS_VAL TEXT NOT NULL DEFAULT '' ,
25 ADDR_BOOK_ID INTEGER ,
26 FIRST_NAME TEXT NOT NULL DEFAULT '' ,
27 LAST_NAME TEXT NOT NULL DEFAULT '' ,
28 MIDDLE_NAME TEXT NOT NULL DEFAULT '' ,
29 PREFIX TEXT NOT NULL DEFAULT '' ,
30 SUFFIX TEXT NOT NULL DEFAULT '' ,
31 IMAGE_PATH TEXT NOT NULL DEFAULT '' ,
34 FOREIGN KEY (CONV_ID) REFERENCES MSG_CONVERSATION_TABLE (CONV_ID)
37 CREATE TABLE MSG_FOLDER_TABLE
39 FOLDER_ID INTEGER PRIMARY KEY ,
40 FOLDER_NAME TEXT NOT NULL ,
41 FOLDER_TYPE INTEGER DEFAULT 0
44 CREATE TABLE MSG_MESSAGE_TABLE
46 MSG_ID INTEGER PRIMARY KEY ,
47 CONV_ID INTEGER NOT NULL ,
48 FOLDER_ID INTEGER NOT NULL ,
49 STORAGE_ID INTEGER NOT NULL ,
50 MAIN_TYPE INTEGER NOT NULL ,
51 SUB_TYPE INTEGER NOT NULL ,
52 DISPLAY_TIME DATETIME ,
53 DATA_SIZE INTEGER DEFAULT 0 ,
54 NETWORK_STATUS INTEGER DEFAULT 0 ,
55 READ_STATUS INTEGER DEFAULT 0 ,
56 PROTECTED INTEGER DEFAULT 0 ,
57 PRIORITY INTEGER DEFAULT 0 ,
58 MSG_DIRECTION INTEGER NOT NULL ,
59 SCHEDULED_TIME DATETIME ,
60 BACKUP INTEGER DEFAULT 0 ,
61 SUBJECT TEXT NOT NULL DEFAULT '' ,
62 MSG_DATA TEXT NOT NULL DEFAULT '' ,
63 THUMB_PATH TEXT NOT NULL DEFAULT '' ,
64 MSG_TEXT TEXT NOT NULL DEFAULT '' ,
65 ATTACHMENT_COUNT INTEGER DEFAULT 0 ,
66 SIM_INDEX INTEGER DEFAULT 0 ,
68 DPM_RESTRICTED INTERGER DEFAULT 0 ,
70 FOREIGN KEY (CONV_ID) REFERENCES MSG_CONVERSATION_TABLE (CONV_ID) ,
71 FOREIGN KEY (FOLDER_ID) REFERENCES MSG_FOLDER_TABLE (FOLDER_ID)
74 CREATE TABLE MSG_SIM_TABLE
78 MSG_ID INTEGER NOT NULL ,
80 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
83 CREATE TABLE MSG_PUSH_TABLE
85 MSG_ID INTEGER PRIMARY KEY ,
89 ID TEXT NOT NULL DEFAULT '' ,
90 HREF TEXT NOT NULL DEFAULT '' ,
91 CONTENT TEXT NOT NULL DEFAULT '' ,
93 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
96 CREATE TABLE MSG_CBMSG_TABLE
98 MSG_ID INTEGER PRIMARY KEY ,
99 CB_MSG_ID INTEGER NOT NULL ,
101 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
104 CREATE TABLE MSG_SYNCML_TABLE
106 MSG_ID INTEGER PRIMARY KEY ,
107 EXT_ID INTEGER NOT NULL ,
108 PINCODE INTEGER NOT NULL ,
110 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
113 CREATE TABLE MSG_SCHEDULED_TABLE
115 MSG_ID INTEGER PRIMARY KEY ,
116 ALARM_ID INTEGER NOT NULL ,
118 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
121 CREATE TABLE MSG_SMS_SENDOPT_TABLE
123 MSG_ID INTEGER PRIMARY KEY ,
124 DELREP_REQ INTEGER NOT NULL ,
125 KEEP_COPY INTEGER NOT NULL ,
126 REPLY_PATH INTEGER NOT NULL ,
127 ENCODE_TYPE INTEGER NOT NULL ,
129 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
132 CREATE TABLE MSG_FILTER_TABLE
134 FILTER_ID INTEGER PRIMARY KEY ,
135 FILTER_TYPE INTEGER NOT NULL ,
136 FILTER_VALUE TEXT NOT NULL ,
137 FILTER_ACTIVE INTEGER DEFAULT 0
140 CREATE TABLE MSG_MMS_MESSAGE_TABLE
142 MSG_ID INTEGER PRIMARY KEY ,
143 TRANSACTION_ID TEXT NOT NULL DEFAULT '' ,
144 MESSAGE_ID TEXT NOT NULL DEFAULT '' ,
145 FWD_MESSAGE_ID TEXT NOT NULL DEFAULT '' ,
146 CONTENTS_LOCATION TEXT NOT NULL DEFAULT '' ,
147 FILE_PATH TEXT NOT NULL DEFAULT '' ,
148 VERSION INTEGER NOT NULL ,
149 DATA_TYPE INTEGER DEFAULT -1 ,
151 HIDE_ADDRESS INTEGER DEFAULT 0 ,
152 ASK_DELIVERY_REPORT INTEGER DEFAULT 0 ,
153 REPORT_ALLOWED INTEGER DEFAULT 0 ,
154 READ_REPORT_ALLOWED_TYPE INTEGER DEFAULT 0 ,
155 ASK_READ_REPLY INTEGER DEFAULT 0 ,
156 READ INTEGER DEFAULT 0 ,
157 READ_REPORT_SEND_STATUS INTEGER DEFAULT 0 ,
158 READ_REPORT_SENT INTEGER DEFAULT 0 ,
159 PRIORITY INTEGER DEFAULT 0 ,
160 KEEP_COPY INTEGER DEFAULT 0 ,
161 MSG_SIZE INTEGER NOT NULL ,
162 MSG_CLASS INTEGER DEFAULT -1 ,
163 EXPIRY_TIME DATETIME ,
164 CUSTOM_DELIVERY_TIME INTEGER DEFAULT 0 ,
165 DELIVERY_TIME DATETIME ,
166 MSG_STATUS INTEGER DEFAULT -1 ,
168 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
171 CREATE TABLE MSG_MMS_PREVIEW_INFO_TABLE
173 MSG_ID INTEGER NOT NULL ,
178 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
181 CREATE TABLE MSG_SMS_REPORT_TABLE
183 MSG_ID INTEGER NOT NULL ,
184 ADDRESS_VAL TEXT NOT NULL DEFAULT '' ,
186 STATUS_TYPE INTEGER ,
187 STATUS INTEGER DEFAULT 0 ,
191 CREATE TABLE MSG_REPORT_TABLE
193 MSG_ID INTEGER NOT NULL ,
194 ADDRESS_VAL TEXT NOT NULL DEFAULT '' ,
195 STATUS_TYPE INTEGER ,
196 STATUS INTEGER DEFAULT 0 ,
200 CREATE TABLE MSG_PUSHCFG_TABLE
202 PUSH_ID INTEGER PRIMARY KEY ,
203 CONTENT_TYPE TEXT NOT NULL DEFAULT '' ,
204 APP_ID TEXT NOT NULL DEFAULT '' ,
205 PKG_NAME TEXT NOT NULL DEFAULT '' ,
211 CREATE TABLE MSG_TMP_MSGID_TABLE
216 CREATE TABLE MSG_CB_CHANNEL_INFO_TABLE
218 CHANNEL_ID INTEGER PRIMARY KEY AUTOINCREMENT,
219 CHANNEL_ACTIVATION INTEGER DEFAULT 0,
220 CHANNEL_FROM INTEGER DEFAULT 0,
221 CHANNEL_TO INTEGER DEFAULT 0,
222 CHANNEL_NAME TEXT NOT NULL DEFAULT '',
223 SIM_INDEX INTEGER DEFAULT 0
226 CREATE TABLE MSG_MULTIPART_TABLE
228 _ID INTEGER PRIMARY KEY AUTOINCREMENT,
229 MSG_ID INTEGER NOT NULL ,
230 SEQ INTEGER DEFAULT 0,
235 CONTENT_LOCATION TEXT,
238 TCS_LEVEL INTEGER DEFAULT -1,
239 MALWARE_ALLOW INTEGER DEFAULT 0,
240 THUMB_FILE_PATH TEXT,
242 FOREIGN KEY(MSG_ID) REFERENCES MSG_MESSAGE_TABLE(MSG_ID)
245 CREATE TABLE MSG_ADDRESS_TEMP_TABLE
247 ADDRESS_VAL TEXT NOT NULL DEFAULT ''
250 CREATE INDEX MSG_CONVERSATION_INDEX ON MSG_CONVERSATION_TABLE(CONV_ID);
251 CREATE INDEX MSG_FOLDER_INDEX ON MSG_FOLDER_TABLE(FOLDER_ID);
252 CREATE INDEX MSG_MESSAGE_INDEX ON MSG_MESSAGE_TABLE(MSG_ID, CONV_ID, FOLDER_ID);
254 INSERT INTO MSG_FOLDER_TABLE VALUES (1, 'INBOX', 1);
255 INSERT INTO MSG_FOLDER_TABLE VALUES (2, 'OUTBOX', 2);
256 INSERT INTO MSG_FOLDER_TABLE VALUES (3, 'SENTBOX', 2);
257 INSERT INTO MSG_FOLDER_TABLE VALUES (4, 'DRAFT', 3);
258 INSERT INTO MSG_FOLDER_TABLE VALUES (5, 'CBMSGBOX', 1);
259 INSERT INTO MSG_FOLDER_TABLE VALUES (6, 'SPAMBOX', 4);
261 INSERT INTO MSG_PUSHCFG_TABLE VALUES (1, 'text/vnd.wap.si', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 1, 0);
262 INSERT INTO MSG_PUSHCFG_TABLE VALUES (2, 'application/vnd.wap.sic', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 2, 0);
263 INSERT INTO MSG_PUSHCFG_TABLE VALUES (3, 'text/vnd.wap.sl', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 3, 0);
264 INSERT INTO MSG_PUSHCFG_TABLE VALUES (4, 'application/vnd.wap.slc', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 4, 0);
265 INSERT INTO MSG_PUSHCFG_TABLE VALUES (5, 'text/vnd.wap.co', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 5, 0);
267 INSERT INTO MSG_PUSHCFG_TABLE VALUES (6, 'application/vnd.wap.coc', 'X-Wap-Application-Id: x-wap-application:wml.ua', '', 0, 6, 0);
269 INSERT INTO MSG_PUSHCFG_TABLE VALUES (7, 'application/vnd.wap.mms-message', 'X-Wap-Application-Id: x-wap-application:mms.ua', '', 0, 7, 0);
270 INSERT INTO MSG_PUSHCFG_TABLE VALUES (8, 'application/vnd.wap.sia', 'X-Wap-Application-Id: x-wap-application:push.sia', '', 0, 8, 0);
271 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);
272 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);
274 INSERT INTO MSG_PUSHCFG_TABLE VALUES (11, 'application/vnd.syncml.notification', 'X-Wap-Application-Id: x-wap-application:push.syncml.dm', '', 0, 11, 0);
275 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);
276 INSERT INTO MSG_PUSHCFG_TABLE VALUES (13, 'application/vnd.syncml+wbxml', 'X-Wap-Application-Id:x-wap-application:push.syncml', '', 0, 13, 0);
277 INSERT INTO MSG_PUSHCFG_TABLE VALUES (14, 'application/vnd.wap.locc+wbxml', 'X-Wap-Application-Id: x-wap-application:loc.ua', '', 0, 14, 0);
278 INSERT INTO MSG_PUSHCFG_TABLE VALUES (15, 'application/vnd.wap.loc+xml', 'X-Wap-Application-Id: x-wap-application:loc.ua', '', 0, 15, 0);
280 INSERT INTO MSG_PUSHCFG_TABLE VALUES (16, 'application/vnd.oma.dd+xml', 'X-Wap-Application-Id: x-wap-application:loc.ua', '', 0, 16, 0);
281 INSERT INTO MSG_PUSHCFG_TABLE VALUES (17, 'application/vnd.oma.drm.message', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 17, 0);
282 INSERT INTO MSG_PUSHCFG_TABLE VALUES (18, 'application/vnd.oma.drm.content', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 18, 0);
283 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);
284 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);
286 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);
287 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);
288 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);
289 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);
290 INSERT INTO MSG_PUSHCFG_TABLE VALUES (25, 'text/vnd.wap.connectivity-xml', 'X-Wap-Application-Id: x-wap-application:drm.ua', '', 0, 26, 0);
292 INSERT INTO MSG_PUSHCFG_TABLE VALUES (26, 'application/vnd.wap.connectivity-wbxml', 'X-Wap-Application-Id: x-wap-samsung:provisioning.ua', '', 0, 27, 0);
293 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);
294 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);
295 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);
296 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);
298 INSERT INTO MSG_PUSHCFG_TABLE VALUES (33, 'application/vnd.wv.csp.cir', 'X-Wap-Application-Id: x-wap-application:wv.ua', '', 0, 34, 0);
299 INSERT INTO MSG_PUSHCFG_TABLE VALUES (34, 'application/vnd.omaloc-supl-init', 'X-Wap-Application-Id: x-oma-application:ulp.ua', '', 0, 44, 0);
301 INSERT INTO MSG_CB_CHANNEL_INFO_TABLE VALUES (0, 1, 0, 65535, '', 1);
302 INSERT INTO MSG_CB_CHANNEL_INFO_TABLE VALUES (1, 1, 0, 65535, '', 2);