|
Lines 4176-4182
DROP TABLE IF EXISTS `illrequestattributes`;
Link Here
|
| 4176 |
CREATE TABLE illrequestattributes ( |
4176 |
CREATE TABLE illrequestattributes ( |
| 4177 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
4177 |
illrequest_id bigint(20) unsigned NOT NULL, -- ILL request number |
| 4178 |
type varchar(200) NOT NULL, -- API ILL property name |
4178 |
type varchar(200) NOT NULL, -- API ILL property name |
| 4179 |
value MEDIUMTEXT NOT NULL, -- API ILL property value |
4179 |
value MEDIUMTEXT NOT NULL, -- API ILL property value |
|
|
4180 |
readonly tinyint(1) NOT NULL DEFAULT 1, -- Is this attribute read only |
| 4180 |
PRIMARY KEY (`illrequest_id`, `type` (191)), |
4181 |
PRIMARY KEY (`illrequest_id`, `type` (191)), |
| 4181 |
CONSTRAINT `illrequestattributes_ifk` |
4182 |
CONSTRAINT `illrequestattributes_ifk` |
| 4182 |
FOREIGN KEY (illrequest_id) |
4183 |
FOREIGN KEY (illrequest_id) |
| 4183 |
- |
|
|