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

(-)a/installer/data/mysql/kohastructure.sql (-28 / +27 lines)
Lines 3475-3480 CREATE TABLE `export_format` ( Link Here
3475
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
3475
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
3476
/*!40101 SET character_set_client = @saved_cs_client */;
3476
/*!40101 SET character_set_client = @saved_cs_client */;
3477
3477
3478
--
3479
-- Table structure for table `file_transports`
3480
--
3481
3482
DROP TABLE IF EXISTS `file_transports`;
3483
/*!40101 SET @saved_cs_client     = @@character_set_client */;
3484
/*!40101 SET character_set_client = utf8mb4 */;
3485
CREATE TABLE `file_transports` (
3486
  `file_transport_id` int(11) NOT NULL AUTO_INCREMENT,
3487
  `name` varchar(80) NOT NULL,
3488
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
3489
  `port` int(11) NOT NULL DEFAULT 22,
3490
  `transport` enum('ftp','sftp') NOT NULL DEFAULT 'sftp',
3491
  `passive` tinyint(1) NOT NULL DEFAULT 1,
3492
  `user_name` varchar(80) DEFAULT NULL,
3493
  `password` mediumtext DEFAULT NULL,
3494
  `key_file` mediumtext DEFAULT NULL,
3495
  `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password',
3496
  `download_directory` mediumtext DEFAULT NULL,
3497
  `upload_directory` mediumtext DEFAULT NULL,
3498
  `status` longtext DEFAULT NULL,
3499
  `debug` tinyint(1) NOT NULL DEFAULT 0,
3500
  PRIMARY KEY (`file_transport_id`),
3501
  KEY `host_idx` (`host`)
3502
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
3503
/*!40101 SET character_set_client = @saved_cs_client */;
3504
3478
--
3505
--
3479
-- Table structure for table `hold_cancellation_requests`
3506
-- Table structure for table `hold_cancellation_requests`
3480
--
3507
--
Lines 5991-6023 CREATE TABLE `sessions` ( Link Here
5991
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6018
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5992
/*!40101 SET character_set_client = @saved_cs_client */;
6019
/*!40101 SET character_set_client = @saved_cs_client */;
5993
6020
5994
--
5995
-- Table structure for table `file_transports`
5996
--
5997
5998
DROP TABLE IF EXISTS `file_transports`;
5999
/*!40101 SET @saved_cs_client     = @@character_set_client */;
6000
/*!40101 SET character_set_client = utf8 */;
6001
CREATE TABLE `file_transports` (
6002
  `file_transport_id` int(11) NOT NULL AUTO_INCREMENT,
6003
  `name` varchar(80) NOT NULL,
6004
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
6005
  `port` int(11) NOT NULL DEFAULT 22,
6006
  `transport` enum('ftp','sftp') NOT NULL DEFAULT 'sftp',
6007
  `passive` tinyint(1) NOT NULL DEFAULT 1,
6008
  `user_name` varchar(80) DEFAULT NULL,
6009
  `password` mediumtext DEFAULT NULL,
6010
  `key_file` mediumtext DEFAULT NULL,
6011
  `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password',
6012
  `download_directory` mediumtext DEFAULT NULL,
6013
  `upload_directory` mediumtext DEFAULT NULL,
6014
  `status` longtext DEFAULT NULL,
6015
  `debug` tinyint(1) NOT NULL DEFAULT 0,
6016
  PRIMARY KEY (`file_transport_id`),
6017
  KEY `host_idx` (`host`)
6018
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6019
/*!40101 SET character_set_client = @saved_cs_client */;
6020
6021
--
6021
--
6022
-- Table structure for table `sms_providers`
6022
-- Table structure for table `sms_providers`
6023
--
6023
--
6024
- 

Return to bug 39190