fieldsets.sql
1.9 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
ALTER TABLE `document_type_fieldsets_link` DROP COLUMN `is_mandatory`; # was tinyint(1) NOT NULL default '0'
ALTER TABLE `folders` ADD COLUMN `restrict_document_types` tinyint(1) NOT NULL default '0';
CREATE TABLE `field_behaviours` (
`id` int(11) NOT NULL default '0',
`name` char(255) NOT NULL default '',
`human_name` char(100) NOT NULL default '',
`field_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `field_id` (`field_id`),
KEY `name` (`name`),
CONSTRAINT `field_behaviours_ibfk_1` FOREIGN KEY (`field_id`) REFERENCES `document_fields` (`id`)
) TYPE=InnoDB;
CREATE TABLE `field_orders` (
`parent_field_id` int(11) NOT NULL default '0',
`child_field_id` int(11) NOT NULL default '0',
`fieldset_id` int(11) NOT NULL default '0',
UNIQUE KEY `child_field` (`child_field_id`),
KEY `parent_field` (`parent_field_id`),
KEY `fieldset_id` (`fieldset_id`)
) TYPE=InnoDB;
CREATE TABLE `field_value_instances` (
`id` int(11) NOT NULL default '0',
`field_id` int(11) NOT NULL default '0',
`field_value_id` int(11) NOT NULL default '0',
`behaviour_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `field_id` (`field_id`),
KEY `field_value_id` (`field_value_id`),
KEY `behaviour_id` (`behaviour_id`)
) TYPE=InnoDB;
CREATE TABLE `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,
`is_generic` tinyint(1) NOT NULL default '0',
UNIQUE KEY `id` (`id`),
KEY `is_generic` (`is_generic`)
) TYPE=InnoDB;
CREATE TABLE `zseq_document_type_fieldsets_link` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
CREATE TABLE `zseq_fieldsets` (
`id` int(10) unsigned NOT NULL auto_increment,
PRIMARY KEY (`id`)
) TYPE=MyISAM;