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

(-)a/installer/data/mysql/atomicupdate/library_groups.sql (+12 lines)
Line 0 Link Here
1
CREATE TABLE library_groups (
2
    id INT(11) NOT NULL auto_increment,    -- unique id for each group
3
    parent_id INT(11) NULL DEFAULT NULL,   -- if this is a child group, the id of the parent group
4
    branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group
5
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
6
    description TEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
7
    created_on DATETIME NOT NULL,          -- Date and time of creation
8
    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
9
    PRIMARY KEY id ( id ),
10
    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
11
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
12
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-1 / +17 lines)
Lines 3955-3960 CREATE TABLE deletedbiblio_metadata ( Link Here
3955
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3955
    CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE
3956
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3956
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3957
3957
3958
--
3959
-- Table structure for table 'library_groups'
3960
--
3961
3962
CREATE TABLE library_groups (
3963
    id INT(11) NOT NULL auto_increment,    -- unique id for each group
3964
    parent_id INT(11) NULL DEFAULT NULL,   -- if this is a child group, the id of the parent group
3965
    branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group
3966
    title VARCHAR(100) NULL DEFAULT NULL,     -- Short description of the goup
3967
    description TEXT NULL DEFAULT NULL,    -- Longer explanation of the group, if necessary
3968
    created_on DATETIME NOT NULL,          -- Date and time of creation
3969
    updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last
3970
    PRIMARY KEY id ( id ),
3971
    FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE,
3972
    FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE
3973
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
3974
3958
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3975
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
3959
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3976
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
3960
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3977
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
3961
- 

Return to bug 15707