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 4201-4220 DROP TABLE IF EXISTS `cms_pages`; Link Here
4201
 CREATE TABLE `cms_pages` (
4201
 CREATE TABLE `cms_pages` (
4202
  `id` int(6) NOT NULL AUTO_INCREMENT,
4202
  `id` int(6) NOT NULL AUTO_INCREMENT,
4203
  `parent` int(6) DEFAULT NULL,
4203
  `parent` int(6) DEFAULT NULL,
4204
  `branchcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
4204
  `branchcode` varchar(10) DEFAULT NULL,
4205
  `lang` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
4205
  `lang` varchar(25) NOT NULL DEFAULT '',
4206
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
4206
  `title` varchar(255) DEFAULT NULL,
4207
  `title_link` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
4207
  `title_link` varchar(64) DEFAULT NULL,
4208
  `sortorder` int(3) NOT NULL DEFAULT 0,
4208
  `sortorder` int(3) NOT NULL DEFAULT 0,
4209
  `location` tinyint(1) DEFAULT NULL,
4209
  `location` tinyint(1) DEFAULT NULL,
4210
  `publish` tinyint(1) NOT NULL DEFAULT 0,
4210
  `publish` tinyint(1) NOT NULL DEFAULT 0,
4211
  `content` text COLLATE utf8_unicode_ci,
4211
  `content` text,
4212
  PRIMARY KEY (`id`),
4212
  PRIMARY KEY (`id`),
4213
  INDEX `parent_index` (`parent`),
4213
  INDEX `parent_index` (`parent`),
4214
  INDEX `lang_index` (`lang`),
4214
  INDEX `lang_index` (`lang`),
4215
  INDEX `branchcode_index` (`branchcode`),
4215
  INDEX `branchcode_index` (`branchcode`),
4216
  CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
4216
  CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
4217
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4217
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4218
4218
4219
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4219
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
4220
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4220
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
4221
- 

Return to bug 15326