
-- ----------------------------
-- Records of file_types
-- ----------------------------
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('7z', 'archive', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('aiff', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('amr', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('asf', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('au', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('avi', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('bin', 'file', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('bmp', 'image', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('cab', 'archive', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('css', 'text', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('csv', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('divx', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('djvu', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('doc', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('docm', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('docx', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('dot', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('dotm', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('dotx', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('eml', 'message', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('epub', 'ebook', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('exe', 'application', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('flac', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('fodp', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('fods', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('fodt', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('gif', 'image', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('gz', 'archive', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('htm', 'text', 'html');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('html', 'text', 'html');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ical', 'calendar', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('icalendar', 'calendar', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ics', 'calendar', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ifb', 'calendar', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('jpeg', 'image', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('jpg', 'image', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('js', 'script', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('m4a', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('mht', 'text', 'html');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('mkv', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('mov', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('mp3', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('mp4', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('mpeg', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('msg', 'message', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('odp', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ods', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('odt', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ogg', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('otp', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ots', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ott', 'document', 'text');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('pdf', 'document', 'pdf');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('png', 'image', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('pot', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('potm', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('potx', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('pps', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ppsm', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ppsx', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('ppt', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('pptm', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('pptx', 'document', 'presentation');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('py', 'script', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('rar', 'archive', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('rtf', 'document', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('svf', 'image', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('tar', 'archive', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('tiff', 'image', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('txt', 'text', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('vcard', 'card', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('vcf', 'card', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('wav', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('waw', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('wma', 'audio', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('wmv', 'video', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xls', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xlsm', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xlsx', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xlt', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xltm', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xltx', 'document', 'spreadsheet');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xml', 'text', 'xml');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('xps', 'document', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('z', 'archive', '');
INSERT INTO "core"."file_types" ("extension", "type", "subtype") VALUES ('zip', 'archive', '');

-- ----------------------------
-- Records of languages
-- ----------------------------
INSERT INTO "core"."languages" ("language_tag") VALUES ('en_EN');
INSERT INTO "core"."languages" ("language_tag") VALUES ('it_IT');
INSERT INTO "core"."languages" ("language_tag") VALUES ('es_ES');
INSERT INTO "core"."languages" ("language_tag") VALUES ('de_DE');
INSERT INTO "core"."languages" ("language_tag") VALUES ('hr_HR');
INSERT INTO "core"."languages" ("language_tag") VALUES ('hu_HU');

-- ----------------------------
-- Records of local_vault
-- ----------------------------
INSERT INTO "core"."local_vault" VALUES ('*', 'admin', 'PLAIN', '1234');

-- ----------------------------
-- Records of media_types
-- ----------------------------
INSERT INTO "core"."media_types" VALUES ('eml', 'message/rfc822');

-- ----------------------------
-- Records of media_types
-- ----------------------------
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'devices.sync.shell.uri', 'sh://localhost');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'dropbox.appkey', '5jzeukj99hzcawj');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'dropbox.appsecret', 'aud3y9v7mu4l4go');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'googledrive.clientid', '542484747748-iorv72fth410dbr9p185emqjs8ejmekl.apps.googleusercontent.com');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'googledrive.clientsecret', 'mAOLSBaSNZ8Z87eLBwYgDIpG');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'otp.enabled', 'true');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'php.path', '/sonicle/bin/');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'smtp.host', 'localhost');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'smtp.port', '25');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'syslog.enabled', 'false');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'zpush.path', '/sonicle/z-push/');
INSERT INTO "core"."settings" VALUES ('com.sonicle.webtop.core', 'home.path', '/sonicle/sonicle/webtop5/');

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO "core"."users" VALUES ('*', 'admin', 'U', 't', '991f72dc-2b96-4340-b88f-53506b160519', 'Administrator', 'K2U4CN57AEQ73QB5');

-- ----------------------------
-- Records of users_info
-- ----------------------------
INSERT INTO "core"."users_info" VALUES ('*', 'admin', NULL, NULL, 'System', 'Admin', NULL, NULL, 'admin@locahlost', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
