github.com/square/finch@v0.0.0-20240412205204-6530c03e2b96/test/run/columns/setup.sql (about)

     1  CREATE DATABASE IF NOT EXISTS finch;
     2  
     3  USE finch;
     4  
     5  DROP TABLE IF EXISTS coltest1, coltest2, coltest3;
     6  
     7  CREATE TABLE coltest1 (
     8    a int unsigned not null auto_increment primary key,
     9    b int not null default 0
    10  );
    11  
    12  CREATE TABLE coltest2 (
    13    x int unsigned not null default 0,
    14    y varchar(10) not null default "",
    15    z int not null default 0,
    16    primary key (x)
    17  );
    18  
    19  CREATE TABLE coltest3 (
    20    x int unsigned not null default 0,
    21    y varchar(10) not null default "",
    22    primary key (x)
    23  );