|
Lines 4345-4364
DROP TABLE IF EXISTS `cms_pages`;
Link Here
|
| 4345 |
CREATE TABLE `cms_pages` ( |
4345 |
CREATE TABLE `cms_pages` ( |
| 4346 |
`id` int(6) NOT NULL AUTO_INCREMENT, |
4346 |
`id` int(6) NOT NULL AUTO_INCREMENT, |
| 4347 |
`parent` int(6) DEFAULT NULL, |
4347 |
`parent` int(6) DEFAULT NULL, |
| 4348 |
`branchcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, |
4348 |
`branchcode` varchar(10) DEFAULT NULL, |
| 4349 |
`lang` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', |
4349 |
`lang` varchar(25) NOT NULL DEFAULT '', |
| 4350 |
`title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, |
4350 |
`title` varchar(255) DEFAULT NULL, |
| 4351 |
`title_link` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, |
4351 |
`title_link` varchar(64) DEFAULT NULL, |
| 4352 |
`sortorder` int(3) NOT NULL DEFAULT 0, |
4352 |
`sortorder` int(3) NOT NULL DEFAULT 0, |
| 4353 |
`location` tinyint(1) DEFAULT NULL, |
4353 |
`location` tinyint(1) DEFAULT NULL, |
| 4354 |
`publish` tinyint(1) NOT NULL DEFAULT 0, |
4354 |
`publish` tinyint(1) NOT NULL DEFAULT 0, |
| 4355 |
`content` text COLLATE utf8_unicode_ci, |
4355 |
`content` text, |
| 4356 |
PRIMARY KEY (`id`), |
4356 |
PRIMARY KEY (`id`), |
| 4357 |
INDEX `parent_index` (`parent`), |
4357 |
INDEX `parent_index` (`parent`), |
| 4358 |
INDEX `lang_index` (`lang`), |
4358 |
INDEX `lang_index` (`lang`), |
| 4359 |
INDEX `branchcode_index` (`branchcode`), |
4359 |
INDEX `branchcode_index` (`branchcode`), |
| 4360 |
CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
4360 |
CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE |
| 4361 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
4361 |
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 4362 |
|
4362 |
|
| 4363 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
4363 |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
| 4364 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
4364 |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
| 4365 |
- |
|
|