|
Lines 3516-3521
CREATE TABLE patron_lists (
Link Here
|
| 3516 |
patron_list_id int(11) NOT NULL AUTO_INCREMENT, -- unique identifier |
3516 |
patron_list_id int(11) NOT NULL AUTO_INCREMENT, -- unique identifier |
| 3517 |
name varchar(255) CHARACTER SET utf8mb4 NOT NULL, -- the list's name |
3517 |
name varchar(255) CHARACTER SET utf8mb4 NOT NULL, -- the list's name |
| 3518 |
owner int(11) NOT NULL, -- borrowernumber of the list creator |
3518 |
owner int(11) NOT NULL, -- borrowernumber of the list creator |
|
|
3519 |
shared tinyint(1) default 0, |
| 3519 |
PRIMARY KEY (patron_list_id), |
3520 |
PRIMARY KEY (patron_list_id), |
| 3520 |
KEY owner (owner) |
3521 |
KEY owner (owner) |
| 3521 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
3522 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 3522 |
- |
|
|