28 lines
1.1 KiB
SQL
28 lines
1.1 KiB
SQL
CREATE TABLE `test` (
|
|
`id` bigint(20) NOT NULL,
|
|
`test_value` int(11) NOT NULL,
|
|
`local_date` date DEFAULT NULL,
|
|
`starting_time` time DEFAULT NULL,
|
|
`ending_time` time DEFAULT NULL,
|
|
`starting_date_time` datetime(6) DEFAULT NULL,
|
|
`ending_date_time` datetime(6) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
|
|
CREATE TABLE `tasks` (
|
|
`taskid` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
`deadline` date DEFAULT NULL,
|
|
`eta` int(11) NOT NULL,
|
|
`start_date` date DEFAULT NULL,
|
|
`task_name` varchar(255) DEFAULT NULL,
|
|
`work_time` int(11) NOT NULL,
|
|
`parent` bigint(20) DEFAULT NULL,
|
|
`taskgroup_id` bigint(20) DEFAULT NULL,
|
|
PRIMARY KEY (`taskid`),
|
|
KEY `FKamiednrmm0puy94sf1o3q84bp` (`parent`),
|
|
KEY `FKk2et8snwh68sf7p6n6ltmk638` (`taskgroup_id`),
|
|
CONSTRAINT `FKamiednrmm0puy94sf1o3q84bp` FOREIGN KEY (`parent`) REFERENCES `tasks` (`taskid`),
|
|
CONSTRAINT `FKk2et8snwh68sf7p6n6ltmk638` FOREIGN KEY (`taskgroup_id`) REFERENCES `taskgroups` (`taskgroupid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci
|
|
|