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 5993-6025 CREATE TABLE `sessions` ( Link Here
5993
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6020
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
5994
/*!40101 SET character_set_client = @saved_cs_client */;
6021
/*!40101 SET character_set_client = @saved_cs_client */;
5995
6022
5996
--
5997
-- Table structure for table `file_transports`
5998
--
5999
6000
DROP TABLE IF EXISTS `file_transports`;
6001
/*!40101 SET @saved_cs_client     = @@character_set_client */;
6002
/*!40101 SET character_set_client = utf8 */;
6003
CREATE TABLE `file_transports` (
6004
  `file_transport_id` int(11) NOT NULL AUTO_INCREMENT,
6005
  `name` varchar(80) NOT NULL,
6006
  `host` varchar(80) NOT NULL DEFAULT 'localhost',
6007
  `port` int(11) NOT NULL DEFAULT 22,
6008
  `transport` enum('ftp','sftp') NOT NULL DEFAULT 'sftp',
6009
  `passive` tinyint(1) NOT NULL DEFAULT 1,
6010
  `user_name` varchar(80) DEFAULT NULL,
6011
  `password` mediumtext DEFAULT NULL,
6012
  `key_file` mediumtext DEFAULT NULL,
6013
  `auth_mode` enum('password','key_file','noauth') NOT NULL DEFAULT 'password',
6014
  `download_directory` mediumtext DEFAULT NULL,
6015
  `upload_directory` mediumtext DEFAULT NULL,
6016
  `status` longtext DEFAULT NULL,
6017
  `debug` tinyint(1) NOT NULL DEFAULT 0,
6018
  PRIMARY KEY (`file_transport_id`),
6019
  KEY `host_idx` (`host`)
6020
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
6021
/*!40101 SET character_set_client = @saved_cs_client */;
6022
6023
--
6023
--
6024
-- Table structure for table `sms_providers`
6024
-- Table structure for table `sms_providers`
6025
--
6025
--
6026
- 

Return to bug 39190