View | Details | Raw Unified | Return to bug 15326
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug15326-add_cms_pages.sql (-6 / +6 lines)
Lines 1-17 Link Here
1
 CREATE TABLE `cms_pages` (
1
 CREATE TABLE `cms_pages` (
2
  `id` int(6) NOT NULL AUTO_INCREMENT,
2
  `id` int(6) NOT NULL AUTO_INCREMENT,
3
  `parent` int(6) DEFAULT NULL,
3
  `parent` int(6) DEFAULT NULL,
4
  `branchcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
4
  `branchcode` varchar(10) DEFAULT NULL,
5
  `lang` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
5
  `lang` varchar(25) NOT NULL DEFAULT '',
6
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
6
  `title` varchar(255) DEFAULT NULL,
7
  `title_link` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
7
  `title_link` varchar(64) DEFAULT NULL,
8
  `sortorder` int(3) NOT NULL DEFAULT 0,
8
  `sortorder` int(3) NOT NULL DEFAULT 0,
9
  `location` tinyint(1) DEFAULT NULL,
9
  `location` tinyint(1) DEFAULT NULL,
10
  `publish` tinyint(1) NOT NULL DEFAULT 0,
10
  `publish` tinyint(1) NOT NULL DEFAULT 0,
11
  `content` text COLLATE utf8_unicode_ci,
11
  `content` text,
12
  PRIMARY KEY (`id`),
12
  PRIMARY KEY (`id`),
13
  INDEX `parent_index` (`parent`),
13
  INDEX `parent_index` (`parent`),
14
  INDEX `lang_index` (`lang`),
14
  INDEX `lang_index` (`lang`),
15
  INDEX `branchcode_index` (`branchcode`),
15
  INDEX `branchcode_index` (`branchcode`),
16
  CONSTRAINT `cmspages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
16
  CONSTRAINT `cmspages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
17
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
17
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
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
- 

Return to bug 15326