|
Lines 135-143
CREATE TABLE `biblio` ( -- table that stores bibliographic information
Link Here
|
| 135 |
-- |
135 |
-- |
| 136 |
|
136 |
|
| 137 |
DROP TABLE IF EXISTS `biblio_framework`; |
137 |
DROP TABLE IF EXISTS `biblio_framework`; |
| 138 |
CREATE TABLE `biblio_framework` ( |
138 |
CREATE TABLE `biblio_framework` ( -- information about MARC frameworks |
| 139 |
`frameworkcode` varchar(4) NOT NULL default '', |
139 |
`frameworkcode` varchar(4) NOT NULL default '', -- the unique code assigned to the framework |
| 140 |
`frameworktext` varchar(255) NOT NULL default '', |
140 |
`frameworktext` varchar(255) NOT NULL default '', -- the description/name given to the framework |
| 141 |
PRIMARY KEY (`frameworkcode`) |
141 |
PRIMARY KEY (`frameworkcode`) |
| 142 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
142 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
| 143 |
|
143 |
|
| 144 |
- |
|
|