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 5365-5384 DROP TABLE IF EXISTS `cms_pages`; Link Here
5365
 CREATE TABLE `cms_pages` (
5365
 CREATE TABLE `cms_pages` (
5366
  `id` int(6) NOT NULL AUTO_INCREMENT,
5366
  `id` int(6) NOT NULL AUTO_INCREMENT,
5367
  `parent` int(6) DEFAULT NULL,
5367
  `parent` int(6) DEFAULT NULL,
5368
  `branchcode` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
5368
  `branchcode` varchar(10) DEFAULT NULL,
5369
  `lang` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
5369
  `lang` varchar(25) NOT NULL DEFAULT '',
5370
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
5370
  `title` varchar(255) DEFAULT NULL,
5371
  `title_link` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
5371
  `title_link` varchar(64) DEFAULT NULL,
5372
  `sortorder` int(3) NOT NULL DEFAULT 0,
5372
  `sortorder` int(3) NOT NULL DEFAULT 0,
5373
  `location` tinyint(1) DEFAULT NULL,
5373
  `location` tinyint(1) DEFAULT NULL,
5374
  `publish` tinyint(1) NOT NULL DEFAULT 0,
5374
  `publish` tinyint(1) NOT NULL DEFAULT 0,
5375
  `content` text COLLATE utf8_unicode_ci,
5375
  `content` text,
5376
  PRIMARY KEY (`id`),
5376
  PRIMARY KEY (`id`),
5377
  INDEX `parent_index` (`parent`),
5377
  INDEX `parent_index` (`parent`),
5378
  INDEX `lang_index` (`lang`),
5378
  INDEX `lang_index` (`lang`),
5379
  INDEX `branchcode_index` (`branchcode`),
5379
  INDEX `branchcode_index` (`branchcode`),
5380
  CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
5380
  CONSTRAINT `pages_branchcode_ibfk` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE
5381
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8mb4_unicode_ci;
5381
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5382
5382
5383
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
5383
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
5384
5384
5385
- 

Return to bug 15326