55 lines
5.5 KiB
MySQL
55 lines
5.5 KiB
MySQL
|
-- MySQL dump 10.13 Distrib 8.0.33, for macos13.3 (arm64)
|
||
|
|
--
|
||
|
|
-- Host: 127.0.0.1 Database: portal_dev
|
||
|
|
-- ------------------------------------------------------
|
||
|
|
-- Server version 8.0.34-0ubuntu0.20.04.1
|
||
|
|
|
||
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
||
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
||
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
||
|
|
/*!50503 SET NAMES utf8mb4 */;
|
||
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
||
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
||
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
||
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
||
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
||
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Table structure for table `phinxlog`
|
||
|
|
--
|
||
|
|
|
||
|
|
DROP TABLE IF EXISTS `phinxlog`;
|
||
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
||
|
|
CREATE TABLE `phinxlog` (
|
||
|
|
`version` bigint NOT NULL,
|
||
|
|
`migration_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
|
||
|
|
`start_time` timestamp NULL DEFAULT NULL,
|
||
|
|
`end_time` timestamp NULL DEFAULT NULL,
|
||
|
|
`breakpoint` tinyint(1) NOT NULL DEFAULT '0',
|
||
|
|
PRIMARY KEY (`version`)
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
||
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
||
|
|
|
||
|
|
--
|
||
|
|
-- Dumping data for table `phinxlog`
|
||
|
|
--
|
||
|
|
|
||
|
|
LOCK TABLES `phinxlog` WRITE;
|
||
|
|
/*!40000 ALTER TABLE `phinxlog` DISABLE KEYS */;
|
||
|
|
INSERT INTO `phinxlog` VALUES (20210918124810,'EventsAutomationUpdate','2021-09-18 13:10:36','2021-09-18 13:10:36',0),(20210918131542,'InstancesAutomationUpdate','2021-09-18 13:17:38','2021-09-18 13:17:38',0),(20210918131933,'AddEventFeedback','2021-09-18 13:28:37','2021-09-18 13:28:38',0),(20210918234041,'AddDealerBooth','2021-09-18 23:56:19','2021-09-18 23:56:20',0),(20210919000022,'AddDealerBoothTags','2021-09-19 00:10:19','2021-09-19 00:10:20',0),(20210919001148,'AddDealerBoothTagLinks','2021-09-19 00:19:16','2021-09-19 00:19:17',0),(20210922152406,'EventsAutomationFieldUpdate','2021-09-28 01:02:54','2021-09-28 01:02:54',0),(20210925232232,'AddAttendeeBans','2021-09-28 00:45:39','2021-09-28 00:45:39',0),(20211011015555,'CreateDealerBookmarkTable','2021-10-11 06:02:51','2021-10-11 06:02:52',0),(20211011015613,'CreateAttendeeLocationsTable','2021-10-11 06:02:52','2021-10-11 06:02:53',0),(20211011015625,'UpdateJoinHistoryTableWithTrigger','2021-10-11 06:13:32','2021-10-11 06:13:32',0),(20211011021746,'CreateFriendsTable','2021-10-11 06:13:32','2021-10-11 06:13:32',0),(20211013011218,'AddNSFWColumnToDealersBoothTable','2021-10-15 01:51:29','2021-10-15 01:51:30',0),(20211013014703,'AddReceiptIDToPaymentsTable','2021-10-15 01:51:30','2021-10-15 01:51:30',0),(20211013040013,'AddPayPalEmailToPaymentTable','2021-10-15 01:51:30','2021-10-15 01:51:30',0),(20211013085053,'AddTwitchAndYoutubeToDealersBooth','2021-10-15 01:51:30','2021-10-15 01:51:30',0),(20211029013645,'AddAvatarsAndDiscordIDToDealerBooth','2021-10-29 04:45:59','2021-10-29 04:45:59',0),(20211102060513,'AddDealerMetricsTable','2021-11-02 08:05:45','2021-11-02 08:05:45',0),(20211103015441,'AddSessionsTable','2021-11-03 18:57:07','2021-11-03 18:57:07',0),(20211103185142,'AddIndexToJoinHistoryTable','2021-11-03 18:57:07','2021-11-03 19:02:14',0),(20220205234357,'CreatePermissionTables','2022-04-05 21:16:20','2022-04-05 21:16:20',0),(20220206005116,'AddPermissionKeys','2022-04-05 21:16:20','2022-04-05 21:16:20',0),(20220328215853,'AddAttendeePatronsTable','2022-04-06 00:16:22','2022-04-06 00:16:22',0),(20220329095257,'UpdateJoinHistoryTable','2022-05-01 19:59:27','2022-05-01 19:59:27',0),(20220329095311,'CreateModerationLogTable','2022-05-01 19:59:27','2022-05-01 19:59:27',0),(20220412182628,'CreatePaymentWebhookEventTable','2022-05-01 19:59:27','2022-05-01 19:59:28',0),(20220429120859,'CreateFilesTable','2022-05-31 02:05:20','2022-05-31 02:05:20',0),(20220429120909,'CreateFilePermissionsTable','2022-05-31 02:05:20','2022-05-31 02:05:21',0),(20220429120916,'CreateFileAccessLogsTable','2022-05-31 02:05:21','2022-05-31 02:05:21',0),(20220524123925,'CreateNewFilePermissions','2022-05-31 02:05:21','2022-05-31 02:05:21',0),(20220605145118,'MakeEventSubtypeRequired','2022-06-13 02:51:39','2022-06-13 02:51:39',0),(20220605145133,'CreateServiceAccountTable','2022-06-13 02:51:39','2022-06-13 02:51:39',0),(20220605145142,'CreateServiceAccountPermissionsTable','2022-06-13 02:51:39','2022-06-13 02:51:39',0),(20220610005213,'AddRestrictedAndSupporterFieldsToInstanceAndEventTable','2022-06-13 02:51:39','2022-06-13 02:51:40',0),(20220611034231,'AddSupporterInviteBypassPermission','2022-06-13 02:51:40','2022-06-13 02:51:40',0),(20220611134015,'CreateTaintInstancePermission','2022-06-13 02:51:40','2022-06-13 02:51:40',0),(20220611171131,'AddViewUserRestrictedPermission','2022-06-13 02:51:40','2022-06-13 02:51:40',0),(20220617012205,'CreateDonationMessageTable','2022-06-18 21:19:31','2022-06-18 21:19:31',0);
|
||
|
|
/*!40000 ALTER TABLE `phinxlog` ENABLE KEYS */;
|
||
|
|
UNLOCK TABLES;
|
||
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
||
|
|
|
||
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
||
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
||
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
||
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
||
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
||
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
||
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
||
|
|
|
||
|
|
-- Dump completed on 2023-09-26 20:24:44
|