Lines 3970-3976
CREATE TABLE library_groups (
Link Here
|
3970 |
updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last |
3970 |
updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last |
3971 |
PRIMARY KEY id ( id ), |
3971 |
PRIMARY KEY id ( id ), |
3972 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
3972 |
FOREIGN KEY (parent_id) REFERENCES library_groups(id) ON UPDATE CASCADE ON DELETE CASCADE, |
3973 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE |
3973 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON UPDATE CASCADE ON DELETE CASCADE, |
|
|
3974 |
UNIQUE( title ) |
3974 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3975 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3975 |
|
3976 |
|
3976 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3977 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3977 |
- |
|
|