Lines 3249-3256
CREATE TABLE categories_branches( -- association table between categories and br
Link Here
|
3249 |
|
3249 |
|
3250 |
DROP TABLE IF EXISTS authorised_values_branches; |
3250 |
DROP TABLE IF EXISTS authorised_values_branches; |
3251 |
CREATE TABLE authorised_values_branches( -- association table between authorised_values and branches |
3251 |
CREATE TABLE authorised_values_branches( -- association table between authorised_values and branches |
3252 |
av_id INTEGER, |
3252 |
av_id INT(11) NOT NULL, |
3253 |
branchcode VARCHAR(10), |
3253 |
branchcode VARCHAR(10) NOT NULL, |
3254 |
FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE, |
3254 |
FOREIGN KEY (av_id) REFERENCES authorised_values(id) ON DELETE CASCADE, |
3255 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE |
3255 |
FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE |
3256 |
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3256 |
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
3257 |
- |
|
|