/
githubmirror
/
GoFrame
Обзор
Документация
Войти
/
githubmirror
/
GoFrame
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
contrib/drivers/mysql/testdata/with_multiple_depends.sql
32 строки
1 KB
John Guo
move ut cases from package gdb to contrib/drivers/mysql
10 май 2022, 10:38
10 май 2022, 10:38
dc6a923
Код
Авторство
О чём код?
CREATE TABLE `table_a` ( `id` int(11) NOT NULL AUTO_INCREMENT, `alias` varchar(255) NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB; INSERT INTO `table_a` VALUES (1, 'table_a_test1'); INSERT INTO `table_a` VALUES (2, 'table_a_test2'); CREATE TABLE `table_b` ( `id` int(11) NOT NULL AUTO_INCREMENT, `table_a_id` int(11) NOT NULL, `alias` varchar(255) NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB; INSERT INTO `table_b` VALUES (10, 1, 'table_b_test1'); INSERT INTO `table_b` VALUES (20, 2, 'table_b_test2'); INSERT INTO `table_b` VALUES (30, 1, 'table_b_test3'); INSERT INTO `table_b` VALUES (40, 2, 'table_b_test4'); CREATE TABLE `table_c` ( `id` int(11) NOT NULL AUTO_INCREMENT, `table_b_id` int(11) NOT NULL, `alias` varchar(255) NULL DEFAULT '', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB; INSERT INTO `table_c` VALUES (100, 10, 'table_c_test1'); INSERT INTO `table_c` VALUES (200, 10, 'table_c_test2'); INSERT INTO `table_c` VALUES (300, 20, 'table_c_test3'); INSERT INTO `table_c` VALUES (400, 30, 'table_c_test4');