22 lines
768 B
SQL
22 lines
768 B
SQL
CREATE TABLE `mdt_doc_folders` (
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
|
`name` varchar(128) NOT NULL,
|
|
`created_at` timestamp NOT NULL DEFAULT (now()),
|
|
CONSTRAINT `mdt_doc_folders_id` PRIMARY KEY(`id`)
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE `mdt_documents` (
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
|
`reference` varchar(32) NOT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`content` text,
|
|
`folder_id` int,
|
|
`pinned` boolean NOT NULL DEFAULT false,
|
|
`author_citizenid` varchar(50),
|
|
`author_name` varchar(255),
|
|
`created_at` timestamp NOT NULL DEFAULT (now()),
|
|
`updated_at` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
|
|
CONSTRAINT `mdt_documents_id` PRIMARY KEY(`id`)
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE INDEX `doc_folder_idx` ON `mdt_documents` (`folder_id`); |