Lines 3953-3958
CREATE TABLE deletedbiblio_metadata (
Link Here
|
3953 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3953 |
CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (biblionumber) REFERENCES deletedbiblio (biblionumber) ON DELETE CASCADE ON UPDATE CASCADE |
3954 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3954 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3955 |
|
3955 |
|
|
|
3956 |
-- |
3957 |
-- Table structure for table `illrequests` |
3958 |
-- |
3959 |
|
3960 |
DROP TABLE IF EXISTS `illrequests`; |
3961 |
CREATE TABLE illrequests ( |
3962 |
illrequest_id serial PRIMARY KEY, -- ILL request number |
3963 |
borrowernumber integer DEFAULT NULL, -- Patron associated with request |
3964 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
3965 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
3966 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
3967 |
placed date DEFAULT NULL, -- Date the request was placed |
3968 |
replied date DEFAULT NULL, -- Last API response |
3969 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
3970 |
ON UPDATE CURRENT_TIMESTAMP, |
3971 |
completed date DEFAULT NULL, -- Date the request was completed |
3972 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
3973 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
3974 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
3975 |
notesopac text DEFAULT NULL, -- Patron notes attached to request |
3976 |
notesstaff text DEFAULT NULL, -- Staff notes attached to request |
3977 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
3978 |
backend varchar(20) DEFAULT NULL, -- The backend used to create request |
3979 |
CONSTRAINT `illrequests_bnfk` |
3980 |
FOREIGN KEY (`borrowernumber`) |
3981 |
REFERENCES `borrowers` (`borrowernumber`) |
3982 |
ON UPDATE CASCADE ON DELETE CASCADE, |
3983 |
CONSTRAINT `illrequests_bcfk_2` |
3984 |
FOREIGN KEY (`branchcode`) |
3985 |
REFERENCES `branches` (`branchcode`) |
3986 |
ON UPDATE CASCADE ON DELETE CASCADE |
3987 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3988 |
|
3989 |
-- |
3990 |
-- Table structure for table `illrequestattributes` |
3991 |
-- |
3992 |
|
3993 |
DROP TABLE IF EXISTS `illrequestattributes`; |
3994 |
CREATE TABLE illrequestattributes ( |
3995 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
3996 |
type varchar(200) NOT NULL, -- API ILL property name |
3997 |
value text NOT NULL, -- API ILL property value |
3998 |
PRIMARY KEY (`illrequest_id`,`type`), |
3999 |
CONSTRAINT `illrequestattributes_ifk` |
4000 |
FOREIGN KEY (illrequest_id) |
4001 |
REFERENCES `illrequests` (`illrequest_id`) |
4002 |
ON UPDATE CASCADE ON DELETE CASCADE |
4003 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4004 |
|
3956 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4005 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
3957 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4006 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
3958 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4007 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |