22
22
`mime_type` varchar(40) default NULL,
23
23
`flags` int(11) unsigned NOT NULL default '1',
24
24
`track_number` int(11) default NULL,
25
`service_id` varchar(255) default NULL,
25
26
PRIMARY KEY (`id`),
26
27
KEY `cds_object_ref_id` (`ref_id`),
27
28
KEY `cds_object_parent_id` (`parent_id`,`object_type`,`dc_title`),
28
29
KEY `cds_object_object_type` (`object_type`),
29
30
KEY `location_parent` (`location_hash`,`parent_id`),
30
31
KEY `cds_object_track_number` (`track_number`),
32
KEY `cds_object_service_id` (`service_id`),
31
33
CONSTRAINT `mt_cds_object_ibfk_1` FOREIGN KEY (`ref_id`) REFERENCES `mt_cds_object` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
32
34
CONSTRAINT `mt_cds_object_ibfk_2` FOREIGN KEY (`parent_id`) REFERENCES `mt_cds_object` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
33
35
) ENGINE=MyISAM CHARSET=utf8;
34
INSERT INTO `mt_cds_object` VALUES (-1,NULL,-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,9,NULL);
35
INSERT INTO `mt_cds_object` VALUES (0,NULL,-1,1,'object.container','Root',NULL,NULL,NULL,NULL,NULL,0,NULL,9,NULL);
36
INSERT INTO `mt_cds_object` VALUES (-1,NULL,-1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,9,NULL,NULL);
37
INSERT INTO `mt_cds_object` VALUES (0,NULL,-1,1,'object.container','Root',NULL,NULL,NULL,NULL,NULL,0,NULL,9,NULL,NULL);
36
38
UPDATE `mt_cds_object` SET `id`='0' WHERE `id`='1';
37
INSERT INTO `mt_cds_object` VALUES (1,NULL,0,1,'object.container','PC Directory',NULL,NULL,NULL,NULL,NULL,0,NULL,9,NULL);
39
INSERT INTO `mt_cds_object` VALUES (1,NULL,0,1,'object.container','PC Directory',NULL,NULL,NULL,NULL,NULL,0,NULL,9,NULL,NULL);
38
40
CREATE TABLE `mt_cds_active_item` (
39
41
`id` int(11) NOT NULL,
40
42
`action` varchar(255) NOT NULL,