Lines 4103-4108
CREATE TABLE IF NOT EXISTS club_fields (
Link Here
|
4103 |
CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE |
4103 |
CONSTRAINT club_fields_ibfk_4 FOREIGN KEY (club_id) REFERENCES clubs (id) ON DELETE CASCADE ON UPDATE CASCADE |
4104 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4104 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4105 |
|
4105 |
|
|
|
4106 |
-- |
4107 |
-- Table structure for table `illrequests` |
4108 |
-- |
4109 |
|
4110 |
DROP TABLE IF EXISTS `illrequests`; |
4111 |
CREATE TABLE illrequests ( |
4112 |
illrequest_id serial PRIMARY KEY, -- ILL request number |
4113 |
borrowernumber integer DEFAULT NULL, -- Patron associated with request |
4114 |
biblio_id integer DEFAULT NULL, -- Potential bib linked to request |
4115 |
branchcode varchar(50) NOT NULL, -- The branch associated with the request |
4116 |
status varchar(50) DEFAULT NULL, -- Current Koha status of request |
4117 |
placed date DEFAULT NULL, -- Date the request was placed |
4118 |
replied date DEFAULT NULL, -- Last API response |
4119 |
updated timestamp DEFAULT CURRENT_TIMESTAMP -- Last modification to request |
4120 |
ON UPDATE CURRENT_TIMESTAMP, |
4121 |
completed date DEFAULT NULL, -- Date the request was completed |
4122 |
medium varchar(30) DEFAULT NULL, -- The Koha request type |
4123 |
accessurl varchar(500) DEFAULT NULL, -- Potential URL for accessing item |
4124 |
cost varchar(20) DEFAULT NULL, -- Cost of request |
4125 |
notesopac text DEFAULT NULL, -- Patron notes attached to request |
4126 |
notesstaff text DEFAULT NULL, -- Staff notes attached to request |
4127 |
orderid varchar(50) DEFAULT NULL, -- Backend id attached to request |
4128 |
backend varchar(20) DEFAULT NULL, -- The backend used to create request |
4129 |
CONSTRAINT `illrequests_bnfk` |
4130 |
FOREIGN KEY (`borrowernumber`) |
4131 |
REFERENCES `borrowers` (`borrowernumber`) |
4132 |
ON UPDATE CASCADE ON DELETE CASCADE, |
4133 |
CONSTRAINT `illrequests_bcfk_2` |
4134 |
FOREIGN KEY (`branchcode`) |
4135 |
REFERENCES `branches` (`branchcode`) |
4136 |
ON UPDATE CASCADE ON DELETE CASCADE |
4137 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4138 |
|
4139 |
-- |
4140 |
-- Table structure for table `illrequestattributes` |
4141 |
-- |
4142 |
|
4143 |
DROP TABLE IF EXISTS `illrequestattributes`; |
4144 |
CREATE TABLE illrequestattributes ( |
4145 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
4146 |
type varchar(200) NOT NULL, -- API ILL property name |
4147 |
value text NOT NULL, -- API ILL property value |
4148 |
PRIMARY KEY (`illrequest_id`,`type`), |
4149 |
CONSTRAINT `illrequestattributes_ifk` |
4150 |
FOREIGN KEY (illrequest_id) |
4151 |
REFERENCES `illrequests` (`illrequest_id`) |
4152 |
ON UPDATE CASCADE ON DELETE CASCADE |
4153 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4154 |
|
4106 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4155 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4107 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4156 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4108 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
4157 |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |