|
Lines 3358-3364
DROP TABLE IF EXISTS uploaded_files;
Link Here
|
| 3358 |
CREATE TABLE uploaded_files ( |
3358 |
CREATE TABLE uploaded_files ( |
| 3359 |
id CHAR(40) NOT NULL PRIMARY KEY, |
3359 |
id CHAR(40) NOT NULL PRIMARY KEY, |
| 3360 |
filename TEXT NOT NULL, |
3360 |
filename TEXT NOT NULL, |
| 3361 |
dir TEXT NOT NULL |
3361 |
dir TEXT NOT NULL, |
|
|
3362 |
filesize int, |
| 3363 |
dtcreated timestamp NOT NULL default CURRENT_TIMESTAMP, |
| 3364 |
owner int, |
| 3365 |
FOREIGN KEY (owner) REFERENCES borrowers (borrowernumber) |
| 3362 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3366 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 3363 |
|
3367 |
|
| 3364 |
-- |
3368 |
-- |
| 3365 |
- |
|
|