|
Lines 58-64
CREATE TABLE `auth_subfield_structure` (
Link Here
|
| 58 |
`frameworkcode` varchar(10) NOT NULL default '', |
58 |
`frameworkcode` varchar(10) NOT NULL default '', |
| 59 |
`defaultvalue` TEXT DEFAULT '', |
59 |
`defaultvalue` TEXT DEFAULT '', |
| 60 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
60 |
PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), |
| 61 |
KEY `tab` (`authtypecode`,`tab`) |
61 |
KEY `tab` (`authtypecode`,`tab`), |
|
|
62 |
CONSTRAINT `auth_subfield_structure_ibfk_1` FOREIGN KEY (`authtypecode`) REFERENCES `auth_types` (`authtypecode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 62 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
63 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
| 63 |
|
64 |
|
| 64 |
-- |
65 |
-- |