|
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 |
- |
|
|