github.com/dolthub/go-mysql-server@v0.18.0/enginetest/scriptgen/setup/scripts/graph_tables (about) 1 exec 2 CREATE TABLE `bus_routes` ( 3 `origin` varchar(20) NOT NULL, 4 `dst` varchar(20) NOT NULL, 5 PRIMARY KEY (`origin`,`dst`) 6 ) 7 ---- 8 9 exec 10 insert into bus_routes values 11 ('New York', 'Boston'), 12 ('Boston', 'New York'), 13 ('New York', 'Washington'), 14 ('Washington', 'Boston'), 15 ('Washington', 'Raleigh') 16 ---- 17 18 exec 19 CREATE TABLE `parts` ( 20 `part` varchar(20) NOT NULL, 21 `sub_part` varchar(20) NOT NULL, 22 `quantity` bigint NOT NULL, 23 PRIMARY KEY (`part`,`sub_part`) 24 ) 25 ---- 26 27 exec 28 insert into parts values 29 ('pie', 'crust', 1), 30 ('pie', 'filling', 2), 31 ('crust', 'flour', 20), 32 ('crust', 'sugar', 2), 33 ('crust', 'butter', 15), 34 ('crust', 'salt', 15), 35 ('filling', 'sugar', 5), 36 ('filling', 'fruit', 9), 37 ('filling', 'salt', 3), 38 ('filling', 'butter', 3) 39 ----