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

(-)a/installer/data/mysql/atomicupdate/bug_35761-add_SFTP_tables_and_perm.pl (-2 / +2 lines)
Lines 19-25 return { Link Here
19
            $dbh->do(
19
            $dbh->do(
20
                q {
20
                q {
21
                    CREATE TABLE `file_transports` (
21
                    CREATE TABLE `file_transports` (
22
                    `id` int(11) NOT NULL AUTO_INCREMENT,
22
                    `file_transport_id` int(11) NOT NULL AUTO_INCREMENT,
23
                    `name` varchar(80) NOT NULL,
23
                    `name` varchar(80) NOT NULL,
24
                    `host` varchar(80) NOT NULL DEFAULT 'localhost',
24
                    `host` varchar(80) NOT NULL DEFAULT 'localhost',
25
                    `port` int(11) NOT NULL DEFAULT 22,
25
                    `port` int(11) NOT NULL DEFAULT 22,
Lines 33-39 return { Link Here
33
                    `upload_directory` mediumtext DEFAULT NULL,
33
                    `upload_directory` mediumtext DEFAULT NULL,
34
                    `status` longtext DEFAULT NULL,
34
                    `status` longtext DEFAULT NULL,
35
                    `debug` tinyint(1) NOT NULL DEFAULT 0,
35
                    `debug` tinyint(1) NOT NULL DEFAULT 0,
36
                    PRIMARY KEY (`id`),
36
                    PRIMARY KEY (`file_transport_id`),
37
                    KEY `host_idx` (`host`)
37
                    KEY `host_idx` (`host`)
38
                    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
38
                    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
39
                }
39
                }
(-)a/installer/data/mysql/kohastructure.sql (-3 / +2 lines)
Lines 5974-5980 DROP TABLE IF EXISTS `file_transports`; Link Here
5974
/*!40101 SET @saved_cs_client     = @@character_set_client */;
5974
/*!40101 SET @saved_cs_client     = @@character_set_client */;
5975
/*!40101 SET character_set_client = utf8 */;
5975
/*!40101 SET character_set_client = utf8 */;
5976
CREATE TABLE `file_transports` (
5976
CREATE TABLE `file_transports` (
5977
  `id` int(11) NOT NULL AUTO_INCREMENT,
5977
  `file_transport_id` int(11) NOT NULL AUTO_INCREMENT,
5978
  `name` varchar(80) NOT NULL,
5978
  `name` varchar(80) NOT NULL,
5979
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
5979
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
5980
  `port` int(11) NOT NULL DEFAULT 22,
5980
  `port` int(11) NOT NULL DEFAULT 22,
Lines 5988-5994 CREATE TABLE `file_transports` ( Link Here
5988
  `upload_directory` mediumtext DEFAULT NULL,
5988
  `upload_directory` mediumtext DEFAULT NULL,
5989
  `status` longtext DEFAULT NULL,
5989
  `status` longtext DEFAULT NULL,
5990
  `debug` tinyint(1) NOT NULL DEFAULT 0,
5990
  `debug` tinyint(1) NOT NULL DEFAULT 0,
5991
  PRIMARY KEY (`id`),
5991
  PRIMARY KEY (`file_transport_id`),
5992
  KEY `host_idx` (`host`)
5992
  KEY `host_idx` (`host`)
5993
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5993
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5994
/*!40101 SET character_set_client = @saved_cs_client */;
5994
/*!40101 SET character_set_client = @saved_cs_client */;
5995
- 

Return to bug 39190