View | Details | Raw Unified | Return to bug 17216
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_17216_1_add_table.sql (+38 lines)
Line 0 Link Here
1
CREATE TABLE authorised_value_categories (
2
    category_name VARCHAR(32) NOT NULL,
3
    primary key (category_name)
4
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
5
6
-- Add authorised value categories
7
INSERT INTO authorised_value_categories (category_name )
8
    SELECT DISTINCT category FROM authorised_values;
9
10
-- Add special categories
11
INSERT IGNORE INTO authorised_value_categories( category_name )
12
    VALUES
13
    ('Asort1'),
14
    ('Asort2'),
15
    ('Bsort1'),
16
    ('Bsort2'),
17
    ('SUGGEST'),
18
    ('DAMAGED'),
19
    ('LOST'),
20
    ('REPORT_GROUP'),
21
    ('REPORT_SUBGROUP'),
22
    ('DEPARTMENT'),
23
    ('TERM'),
24
    ('SUGGEST_STATUS'),
25
    ('ITEMTYPECAT');
26
27
-- Add very special categories
28
INSERT IGNORE INTO authorised_value_categories( category_name )
29
    VALUES
30
    ('branches'),
31
    ('itemtypes'),
32
    ('cn_source');
33
34
-- Update the FK
35
ALTER TABLE items_search_fields
36
    DROP FOREIGN KEY items_search_fields_authorised_values_category;
37
ALTER TABLE items_search_fields
38
    ADD CONSTRAINT `items_search_fields_authorised_values_category` FOREIGN KEY (`authorised_values_category`) REFERENCES `authorised_value_categories` (`category_name`) ON DELETE SET NULL ON UPDATE CASCADE;
(-)a/installer/data/mysql/en/mandatory/auth_values.sql (+21 lines)
Lines 1-2 Link Here
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
1
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','0','No','No');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
2
INSERT INTO authorised_values (category,authorised_value,lib,lib_opac) VALUES ('YES_NO','1','Yes','Yes');
3
INSERT IGNORE INTO authorised_value_categories( category_name )
4
    VALUES
5
    ('Asort1'),
6
    ('Asort2'),
7
    ('Bsort1'),
8
    ('Bsort2'),
9
    ('SUGGEST'),
10
    ('DAMAGED'),
11
    ('LOST'),
12
    ('REPORT_GROUP'),
13
    ('REPORT_SUBGROUP'),
14
    ('DEPARTMENT'),
15
    ('TERM'),
16
    ('SUGGEST_STATUS'),
17
    ('ITEMTYPECAT');
18
INSERT IGNORE INTO authorised_value_categories( category_name )
19
    VALUES
20
    ('branches'),
21
    ('itemtypes'),
22
    ('cn_source');
23
(-)a/installer/data/mysql/kohastructure.sql (-2 / +12 lines)
Lines 92-97 CREATE TABLE `auth_tag_structure` ( Link Here
92
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
92
  CONSTRAINT `auth_tag_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE
93
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
93
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
94
94
95
96
--
97
-- Table structure for table `authorised_value_categories`
98
--
99
100
DROP TABLE IF EXISTS `authorised_value_categories`;
101
CREATE TABLE `authorised_value_categories` (
102
  `category_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
103
  PRIMARY KEY (`category_name`)
104
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
105
95
--
106
--
96
-- Table structure for table `authorised_values`
107
-- Table structure for table `authorised_values`
97
--
108
--
Lines 3571-3577 CREATE TABLE items_search_fields ( Link Here
3571
  authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
3582
  authorised_values_category VARCHAR(32) NULL DEFAULT NULL,
3572
  PRIMARY KEY(name),
3583
  PRIMARY KEY(name),
3573
  CONSTRAINT items_search_fields_authorised_values_category
3584
  CONSTRAINT items_search_fields_authorised_values_category
3574
    FOREIGN KEY (authorised_values_category) REFERENCES authorised_values (category)
3585
    FOREIGN KEY (authorised_values_category) REFERENCES authorised_value_categories (category_name)
3575
    ON DELETE SET NULL ON UPDATE CASCADE
3586
    ON DELETE SET NULL ON UPDATE CASCADE
3576
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3587
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3577
3588
3578
- 

Return to bug 17216