github.com/easysoft/zendata@v0.0.0-20240513203326-705bd5a7fd67/test/unittest/tables.sql (about) 1 CREATE TABLE `biz_project` ( 2 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 3 `created_at` datetime(3) DEFAULT NULL, 4 `name` varchar, 5 `user-name` varchar, 6 `tel_phone` varchar, 7 `desc` longtext, 8 `is_default` longtext, 9 `disabled` tinyint(1) DEFAULT NULL, 10 `disabled_at` datetime(3) DEFAULT NULL, 11 `path` longtext, 12 PRIMARY KEY (`id`) 13 ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4; 14 15 CREATE TABLE `biz_task` ( 16 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, 17 `created_at` datetime(3) DEFAULT NULL, 18 `updated_at` datetime(3) DEFAULT NULL, 19 `deleted_at` datetime(3) DEFAULT NULL, 20 `disabled` tinyint(1) DEFAULT '0', 21 `name` longtext, 22 `project_id` bigint(20) unsigned NOT NULL, 23 `project_name` longtext, 24 `disabled_at` datetime(3) DEFAULT NULL, 25 PRIMARY KEY (`id`), 26 KEY `fk_project_id_idx` (`project_id`), 27 CONSTRAINT `fk_project_id` FOREIGN KEY (`project_id`) REFERENCES `biz_project` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION 28 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;