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;