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