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 4454-4473 DROP TABLE IF EXISTS `cms_pages`; Link Here
4454
 CREATE TABLE `cms_pages` (
4454
 CREATE TABLE `cms_pages` (
4455
  `id` int(6) NOT NULL AUTO_INCREMENT,
4455
  `id` int(6) NOT NULL AUTO_INCREMENT,
4456
  `parent` int(6) DEFAULT NULL,
4456
  `parent` int(6) DEFAULT NULL,
4457
  `branchcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
4457
  `branchcode` varchar(10) DEFAULT NULL,
4458
  `lang` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
4458
  `lang` varchar(25) NOT NULL DEFAULT '',
4459
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
4459
  `title` varchar(255) DEFAULT NULL,
4460
  `title_link` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
4460
  `title_link` varchar(64) DEFAULT NULL,
4461
  `sortorder` int(3) NOT NULL DEFAULT 0,
4461
  `sortorder` int(3) NOT NULL DEFAULT 0,
4462
  `location` tinyint(1) DEFAULT NULL,
4462
  `location` tinyint(1) DEFAULT NULL,
4463
  `publish` tinyint(1) NOT NULL DEFAULT 0,
4463
  `publish` tinyint(1) NOT NULL DEFAULT 0,
4464
  `content` text COLLATE utf8_unicode_ci,
4464
  `content` text,
4465
  PRIMARY KEY (`id`),
4465
  PRIMARY KEY (`id`),
4466
  INDEX `parent_index` (`parent`),
4466
  INDEX `parent_index` (`parent`),
4467
  INDEX `lang_index` (`lang`),
4467
  INDEX `lang_index` (`lang`),
4468
  INDEX `branchcode_index` (`branchcode`),
4468
  INDEX `branchcode_index` (`branchcode`),
4469
  CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
4469
  CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
4470
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8mb4_unicode_ci;
4470
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4471
4471
4472
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4472
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4473
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4473
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4474
- 

Return to bug 15326