metadata_tree.sql
2.19 KB
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
60
61
62
63
64
65
66
ALTER TABLE `document_fields` ADD COLUMN `has_lookuptree` tinyint(1) default NULL;
ALTER TABLE `document_fields` ADD COLUMN `parent_fieldset` int(11) default NULL;
ALTER TABLE `metadata_lookup` ADD COLUMN `treeorg_parent` int(11) default NULL;
CREATE TABLE `document_fieldsets` (
`id` int(11) NOT NULL default '0',
`name` char(255) NOT NULL default '',
`namespace` char(255) NOT NULL default '',
`mandatory` tinyint(4) NOT NULL default '0',
`is_conditional` tinyint(1) NOT NULL default '0',
`master_field` int(11) default NULL,
UNIQUE KEY `id` (`id`)
) TYPE=InnoDB;
CREATE TABLE `document_type_fieldsets_link` (
`id` int(11) NOT NULL default '0',
`document_type_id` int(11) NOT NULL default '0',
`fieldset_id` int(11) NOT NULL default '0',
`is_mandatory` tinyint(1) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) TYPE=InnoDB;
CREATE TABLE `metadata_lookup_condition` (
`id` int(11) NOT NULL default '0',
`document_field_id` int(11) NOT NULL default '0',
`metadata_lookup_id` int(11) NOT NULL default '0',
`name` char(255) default NULL,
UNIQUE KEY `id` (`id`)
) TYPE=InnoDB;
CREATE TABLE `metadata_lookup_condition_chain` (
`id` int(11) NOT NULL default '0',
`parent_condition` int(11) default NULL,
`child_condition` int(11) NOT NULL default '0',
UNIQUE KEY `id` (`id`)
) TYPE=InnoDB;
CREATE TABLE `metadata_lookup_tree` (
`id` int(11) NOT NULL default '0',
`document_field_id` int(11) NOT NULL default '0',
`name` char(255) default NULL,
`metadata_lookup_tree_parent` int(11) default NULL,
UNIQUE KEY `id` (`id`),
KEY `metadata_lookup_tree_parent` (`metadata_lookup_tree_parent`),
KEY `document_field_id` (`document_field_id`)
) TYPE=InnoDB;
CREATE TABLE `zseq_document_fieldsets` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `zseq_metadata_lookup_condition` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `zseq_metadata_lookup_condition_chain` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `zseq_metadata_lookup_tree` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;