92 lines
3.0 KiB
MySQL
92 lines
3.0 KiB
MySQL
|
/*
|
||
|
|
Warnings:
|
||
|
|
|
||
|
|
- You are about to drop the `content` table. If the table is not empty, all the data it contains will be lost.
|
||
|
|
- You are about to drop the `handle` table. If the table is not empty, all the data it contains will be lost.
|
||
|
|
- You are about to drop the `registerChannel` table. If the table is not empty, all the data it contains will be lost.
|
||
|
|
- You are about to drop the `user` table. If the table is not empty, all the data it contains will be lost.
|
||
|
|
|
||
|
|
*/
|
||
|
|
-- DropForeignKey
|
||
|
|
ALTER TABLE `content` DROP FOREIGN KEY `content_handleId_fkey`;
|
||
|
|
|
||
|
|
-- DropForeignKey
|
||
|
|
ALTER TABLE `handle` DROP FOREIGN KEY `handle_userId_fkey`;
|
||
|
|
|
||
|
|
-- DropTable
|
||
|
|
DROP TABLE `content`;
|
||
|
|
|
||
|
|
-- DropTable
|
||
|
|
DROP TABLE `handle`;
|
||
|
|
|
||
|
|
-- DropTable
|
||
|
|
DROP TABLE `registerChannel`;
|
||
|
|
|
||
|
|
-- DropTable
|
||
|
|
DROP TABLE `user`;
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE `User` (
|
||
|
|
`id` VARCHAR(191) NOT NULL,
|
||
|
|
`email` VARCHAR(191) NOT NULL,
|
||
|
|
`icon` VARCHAR(191) NOT NULL DEFAULT '',
|
||
|
|
`isApproved` BOOLEAN NOT NULL DEFAULT false,
|
||
|
|
`createtime` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
||
|
|
`RegisgerCode` VARCHAR(191) NOT NULL DEFAULT '',
|
||
|
|
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE `RegisterChannel` (
|
||
|
|
`id` VARCHAR(191) NOT NULL,
|
||
|
|
`handle` VARCHAR(191) NOT NULL,
|
||
|
|
`userId` VARCHAR(191) NOT NULL,
|
||
|
|
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE `Handle` (
|
||
|
|
`id` VARCHAR(191) NOT NULL,
|
||
|
|
`handle` VARCHAR(191) NOT NULL,
|
||
|
|
`constPerView` DOUBLE NOT NULL DEFAULT 1,
|
||
|
|
|
||
|
|
UNIQUE INDEX `Handle_handle_key`(`handle`),
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE `Content` (
|
||
|
|
`id` VARCHAR(191) NOT NULL,
|
||
|
|
`subject` VARCHAR(191) NOT NULL,
|
||
|
|
`pubDate` DATETIME(3) NOT NULL,
|
||
|
|
`handleId` VARCHAR(191) NOT NULL,
|
||
|
|
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE `_HandleToUser` (
|
||
|
|
`A` VARCHAR(191) NOT NULL,
|
||
|
|
`B` VARCHAR(191) NOT NULL,
|
||
|
|
|
||
|
|
UNIQUE INDEX `_HandleToUser_AB_unique`(`A`, `B`),
|
||
|
|
INDEX `_HandleToUser_B_index`(`B`)
|
||
|
|
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE `RegisterChannel` ADD CONSTRAINT `RegisterChannel_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `User`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE `Content` ADD CONSTRAINT `Content_handleId_fkey` FOREIGN KEY (`handleId`) REFERENCES `Handle`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE `contentDayView` ADD CONSTRAINT `contentDayView_contentId_fkey` FOREIGN KEY (`contentId`) REFERENCES `Content`(`id`) ON DELETE RESTRICT ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE `_HandleToUser` ADD CONSTRAINT `_HandleToUser_A_fkey` FOREIGN KEY (`A`) REFERENCES `Handle`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE `_HandleToUser` ADD CONSTRAINT `_HandleToUser_B_fkey` FOREIGN KEY (`B`) REFERENCES `User`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;
|