/usr/share/mediatomb/sqlite3.sql is in mediatomb-common 0.12.1-5ubuntu2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 | BEGIN TRANSACTION;
CREATE TABLE "mt_cds_object" (
"id" integer primary key,
"ref_id" integer default NULL,
"parent_id" integer NOT NULL default '0',
"object_type" tinyint unsigned NOT NULL,
"upnp_class" varchar(80) default NULL,
"dc_title" varchar(255) default NULL,
"location" text default NULL,
"location_hash" integer unsigned default NULL,
"metadata" text default NULL,
"auxdata" text default NULL,
"resources" text default NULL,
"update_id" integer NOT NULL default '0',
"mime_type" varchar(40) default NULL,
"flags" integer unsigned NOT NULL default '1',
"track_number" integer default NULL,
"service_id" varchar(255) default NULL,
CONSTRAINT "cds_object_ibfk_1" FOREIGN KEY ("ref_id") REFERENCES "cds_object" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT "cds_object_ibfk_2" FOREIGN KEY ("parent_id") REFERENCES "cds_object" ("id") ON DELETE CASCADE ON UPDATE CASCADE
);
INSERT INTO "mt_cds_object" VALUES(-1, NULL, -1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL, NULL);
INSERT INTO "mt_cds_object" VALUES(0, NULL, -1, 1, 'object.container', 'Root', NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL, NULL);
INSERT INTO "mt_cds_object" VALUES(1, NULL, 0, 1, 'object.container', 'PC Directory', NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL, NULL);
CREATE TABLE "mt_cds_active_item" (
"id" integer primary key,
"action" varchar(255) NOT NULL,
"state" varchar(255) NOT NULL,
CONSTRAINT "mt_cds_active_item_ibfk_1" FOREIGN KEY ("id") REFERENCES "mt_cds_object" ("id") ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE TABLE "mt_internal_setting" (
"key" varchar(40) primary key NOT NULL,
"value" varchar(255) NOT NULL
);
INSERT INTO "mt_internal_setting" VALUES('db_version', '3');
CREATE TABLE "mt_autoscan" (
"id" integer primary key,
"obj_id" integer default NULL,
"scan_level" varchar(10) NOT NULL,
"scan_mode" varchar(10) NOT NULL,
"recursive" tinyint unsigned NOT NULL,
"hidden" tinyint unsigned NOT NULL,
"interval" integer unsigned default NULL,
"last_modified" integer unsigned default NULL,
"persistent" tinyint unsigned NOT NULL default '0',
"location" text default NULL,
"path_ids" text default NULL,
"touched" tinyint unsigned NOT NULL default '1',
CONSTRAINT "mt_autoscan_id" FOREIGN KEY ("obj_id") REFERENCES "mt_cds_object" ("id") ON DELETE CASCADE ON UPDATE CASCADE
);
CREATE INDEX mt_cds_object_ref_id ON mt_cds_object(ref_id);
CREATE INDEX mt_cds_object_parent_id ON mt_cds_object(parent_id,object_type,dc_title);
CREATE INDEX mt_object_type ON mt_cds_object(object_type);
CREATE INDEX mt_location_parent ON mt_cds_object(location_hash,parent_id);
CREATE INDEX mt_track_number ON mt_cds_object(track_number);
CREATE INDEX mt_internal_setting_key ON mt_internal_setting(key);
CREATE UNIQUE INDEX mt_autoscan_obj_id ON mt_autoscan(obj_id);
CREATE INDEX mt_cds_object_service_id ON mt_cds_object(service_id);
COMMIT;
|