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

Return to bug 15326