a26st1H7

1(node:5728) [SEQUELIZE0004] DeprecationWarning: A boolean value was passed to options.operatorsAliases. This is a no-op with v5 and should be removed.
2Executing (default): DROP TABLE IF EXISTS `Contact`;
3Executing (default): DROP TABLE IF EXISTS `Member`;
4Executing (default): DROP TABLE IF EXISTS `notifications`;
5Executing (default): DROP TABLE IF EXISTS `invitees`;
6Executing (default): DROP TABLE IF EXISTS `notes`;
7Executing (default): DROP TABLE IF EXISTS `entries`;
8Executing (default): DROP TABLE IF EXISTS `settings`;
9Executing (default): DROP TABLE IF EXISTS `gangs`;
10Executing (default): DROP TABLE IF EXISTS `events`;
11Executing (default): DROP TABLE IF EXISTS `categories`;
12Executing (default): DROP TABLE IF EXISTS `adms`;
13Executing (default): DROP TABLE IF EXISTS `profiles`;
14Executing (default): DROP TABLE IF EXISTS `calendars`;
15Executing (default): DROP TABLE IF EXISTS `accounts`;
16Executing (default): DROP TABLE IF EXISTS `accounts`;
17Executing (default): CREATE TABLE IF NOT EXISTS `accounts` (`AccID` INTEGER auto_increment , `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`AccID`)) ENGINE=InnoDB;
18Executing (default): SHOW INDEX FROM `accounts`
19Executing (default): DROP TABLE IF EXISTS `calendars`;
20Executing (default): CREATE TABLE IF NOT EXISTS `calendars` (`CalID` INTEGER auto_increment , `View` INTEGER NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `accountAccID` INTEGER, PRIMARY KEY (`CalID`), FOREIGN KEY (`accountAccID`) REFERENCES `accounts` (`AccID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
21Executing (default): SHOW INDEX FROM `calendars`
22Executing (default): DROP TABLE IF EXISTS `profiles`;
23Executing (default): CREATE TABLE IF NOT EXISTS `profiles` (`ProID` INTEGER auto_increment , `FirstName` VARCHAR(255) NOT NULL, `LastName` VARCHAR(255) NOT NULL, `Email` VARCHAR(255) NOT NULL, `Password` VARCHAR(255) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `accountAccID` INTEGER, PRIMARY KEY (`ProID`), FOREIGN KEY (`accountAccID`) REFERENCES `accounts` (`AccID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
24Executing (default): SHOW INDEX FROM `profiles`
25Executing (default): DROP TABLE IF EXISTS `adms`;
26Executing (default): CREATE TABLE IF NOT EXISTS `adms` (`AdmID` INTEGER auto_increment , `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `accountAccID` INTEGER, PRIMARY KEY (`AdmID`), FOREIGN KEY (`accountAccID`) REFERENCES `accounts` (`AccID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
27Executing (default): SHOW INDEX FROM `adms`
28Executing (default): DROP TABLE IF EXISTS `categories`;
29Executing (default): CREATE TABLE IF NOT EXISTS `categories` (`CatID` INTEGER auto_increment , `Name` VARCHAR(255) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `accountAccID` INTEGER, PRIMARY KEY (`CatID`), FOREIGN KEY (`accountAccID`) REFERENCES `accounts` (`AccID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
30Executing (default): SHOW INDEX FROM `categories`
31Executing (default): DROP TABLE IF EXISTS `events`;
32Executing (default): CREATE TABLE IF NOT EXISTS `events` (`EveID` INTEGER auto_increment , `Title` VARCHAR(255) NOT NULL, `SDate` DATETIME NOT NULL, `EDate` DATETIME NOT NULL, `STime` VARCHAR(255) NOT NULL, `ETime` VARCHAR(255) NOT NULL, `Venue` VARCHAR(255) NOT NULL, `Information` VARCHAR(255) NOT NULL, `Priority` INTEGER NOT NULL, `Rep` INTEGER NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `admAdmID` INTEGER, `calendarCalID` INTEGER, `categoryCatID` INTEGER, PRIMARY KEY (`EveID`), FOREIGN KEY (`admAdmID`) REFERENCES `adms` (`AdmID`) ON DELETE SET NULL ON UPDATE CASCADE, FOREIGN KEY (`calendarCalID`) REFERENCES `calendars` (`CalID`) ON DELETE SET NULL ON UPDATE CASCADE, FOREIGN KEY (`categoryCatID`) REFERENCES `categories` (`CatID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
33Executing (default): SHOW INDEX FROM `events`
34Executing (default): DROP TABLE IF EXISTS `gangs`;
35Executing (default): CREATE TABLE IF NOT EXISTS `gangs` (`GanID` INTEGER auto_increment , `GangName` VARCHAR(255) NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `admAdmID` INTEGER, PRIMARY KEY (`GanID`), FOREIGN KEY (`admAdmID`) REFERENCES `adms` (`AdmID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
36Executing (default): SHOW INDEX FROM `gangs`
37Executing (default): DROP TABLE IF EXISTS `settings`;
38Executing (default): CREATE TABLE IF NOT EXISTS `settings` (`SetID` INTEGER auto_increment , `ProView` INTEGER NOT NULL, `CalView` INTEGER NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `accountAccID` INTEGER, PRIMARY KEY (`SetID`), FOREIGN KEY (`accountAccID`) REFERENCES `accounts` (`AccID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
39Executing (default): SHOW INDEX FROM `settings`
40Executing (default): DROP TABLE IF EXISTS `entries`;
41Executing (default): CREATE TABLE IF NOT EXISTS `entries` (`EntID` INTEGER auto_increment , `Content` VARCHAR(255) NOT NULL, `Date` DATETIME NOT NULL, `Time` DATETIME NOT NULL, `Reminder` INTEGER NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `categoryCatID` INTEGER, `calendarCalID` INTEGER, `noteNotID` INTEGER, PRIMARY KEY (`EntID`), FOREIGN KEY (`categoryCatID`) REFERENCES `categories` (`CatID`) ON DELETE SET NULL ON UPDATE CASCADE, FOREIGN KEY (`calendarCalID`) REFERENCES `calendars` (`CalID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
42Executing (default): SHOW INDEX FROM `entries`
43Executing (default): DROP TABLE IF EXISTS `notes`;
44Executing (default): CREATE TABLE IF NOT EXISTS `notes` (`NotID` INTEGER auto_increment , `Text` VARCHAR(255) NOT NULL, `Tag` VARCHAR(255) NOT NULL , `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `profileProID` INTEGER, `entryEntID` INTEGER, PRIMARY KEY (`NotID`, `Tag`), FOREIGN KEY (`profileProID`) REFERENCES `profiles` (`ProID`) ON DELETE SET NULL ON UPDATE CASCADE, FOREIGN KEY (`entryEntID`) REFERENCES `entries` (`EntID`) ON DELETE SET NULL ON UPDATE CASCADE) ENGINE=InnoDB;
45Unhandled rejection SequelizeDatabaseError: Specified key was too long; max key length is 767 bytes
46    at Query.formatError (/home/adminuser/Documents/node_modules/sequelize/lib/dialects/mysql/query.js:241:16)
47    at Query.handler [as onResult] (/home/adminuser/Documents/node_modules/sequelize/lib/dialects/mysql/query.js:48:23)
48    at Query.execute (/home/adminuser/Documents/node_modules/mysql2/lib/commands/command.js:30:14)
49    at Connection.handlePacket (/home/adminuser/Documents/node_modules/mysql2/lib/connection.js:449:32)
50    at PacketParser.Connection.packetParser.p [as onPacket] (/home/adminuser/Documents/node_modules/mysql2/lib/connection.js:72:12)
51    at PacketParser.executeStart (/home/adminuser/Documents/node_modules/mysql2/lib/packet_parser.js:75:16)
52    at Socket.Connection.stream.on.data (/home/adminuser/Documents/node_modules/mysql2/lib/connection.js:79:25)
53    at Socket.emit (events.js:193:13)
54    at addChunk (_stream_readable.js:296:12)
55    at readableAddChunk (_stream_readable.js:277:11)
56    at Socket.Readable.push (_stream_readable.js:232:10)
57    at TCP.onStreamRead (internal/stream_base_commons.js:150:17)