|
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 |
- |
|
|