16 lines
532 B
SQL
16 lines
532 B
SQL
CREATE TABLE `mdt_laws` (
|
|
`id` int AUTO_INCREMENT NOT NULL,
|
|
`category` varchar(64) NOT NULL DEFAULT 'Allgemein',
|
|
`paragraph` varchar(32) NOT NULL,
|
|
`title` varchar(255) NOT NULL,
|
|
`description` text,
|
|
`fine` int,
|
|
`jail_time` int,
|
|
`sort_order` int NOT NULL DEFAULT 0,
|
|
`created_at` timestamp NOT NULL DEFAULT (now()),
|
|
`updated_at` timestamp NOT NULL DEFAULT (now()) ON UPDATE CURRENT_TIMESTAMP,
|
|
CONSTRAINT `mdt_laws_id` PRIMARY KEY(`id`)
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE INDEX `law_category_idx` ON `mdt_laws` (`category`);
|