github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/comment/annotion.sql (about)

     1  create database if not exists test;
     2  use test;
     3  drop table if exists tlonglonglong;
     4  # 版本:220608 无外键 有自增长 有所有默认值 图片表取消自增长
     5  
     6  # add table01
     7  CREATE TABLE table01(
     8                                c1 BIGINT NOT NULL AUTO_INCREMENT,
     9                                c2 VARCHAR(200) NULL,
    10                                c3 VARCHAR(200) NULL,
    11                                c4 VARCHAR(200) NULL,
    12                                c5 VARCHAR(200) NULL,
    13                                c6 TINYINT NULL,
    14                                c7 DATETIME NULL,
    15                                c8 VARCHAR(200) NULL,
    16                                c9 TINYINT NOT NULL,
    17                                PRIMARY KEY (`c1`) USING BTREE
    18  )ENGINE=INNODB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
    19  
    20  show tables;
    21  show create table table01;
    22  drop table table01;
    23  
    24  # add table02
    25  drop table if exists table02;
    26  create table table02(id int PRIMARY KEY,name VARCHAR(255),age int);
    27  insert into table02 values(1,"Abby", 24);
    28  insert into table02 values(2,"Bob", 25);
    29  insert into table02 values(3,"Carol", 23);
    30  insert into table02 values(4,"Dora", 29);
    31  create unique index idx on table02(name);
    32  select * from table02;
    33  show create table table02;
    34  drop table table02;
    35  
    36  # drop database
    37  drop database test;