15
15
"mime_type" varchar(40) default NULL,
16
16
"flags" integer unsigned NOT NULL default '1',
17
17
"track_number" integer default NULL,
18
"service_id" varchar(255) default NULL,
18
19
CONSTRAINT "cds_object_ibfk_1" FOREIGN KEY ("ref_id") REFERENCES "cds_object" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
19
20
CONSTRAINT "cds_object_ibfk_2" FOREIGN KEY ("parent_id") REFERENCES "cds_object" ("id") ON DELETE CASCADE ON UPDATE CASCADE
21
INSERT INTO "mt_cds_object" VALUES(-1, NULL, -1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL);
22
INSERT INTO "mt_cds_object" VALUES(0, NULL, -1, 1, 'object.container', 'Root', NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL);
23
INSERT INTO "mt_cds_object" VALUES(1, NULL, 0, 1, 'object.container', 'PC Directory', NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL);
22
INSERT INTO "mt_cds_object" VALUES(-1, NULL, -1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL, NULL);
23
INSERT INTO "mt_cds_object" VALUES(0, NULL, -1, 1, 'object.container', 'Root', NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL, NULL);
24
INSERT INTO "mt_cds_object" VALUES(1, NULL, 0, 1, 'object.container', 'PC Directory', NULL, NULL, NULL, NULL, NULL, 0, NULL, 9, NULL, NULL);
24
25
CREATE TABLE "mt_cds_active_item" (
25
26
"id" integer primary key,
26
27
"action" varchar(255) NOT NULL,
31
32
"key" varchar(40) primary key NOT NULL,
32
33
"value" varchar(255) NOT NULL
34
INSERT INTO "mt_internal_setting" VALUES('db_version', '2');
35
INSERT INTO "mt_internal_setting" VALUES('db_version', '3');
35
36
CREATE TABLE "mt_autoscan" (
36
37
"id" integer primary key,
37
38
"obj_id" integer default NULL,