github.com/pingcap/tiflow@v0.0.0-20240520035814-5bf52d54e205/dm/tests/adjust_gtid/data/db1.prepare.sql (about)

     1  drop database if exists `adjust_gtid`;
     2  create database `adjust_gtid`;
     3  use `adjust_gtid`;
     4  create table t1 (
     5      id int NOT NULL AUTO_INCREMENT,
     6      name varchar(20),
     7      dt datetime,
     8      ts timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
     9      PRIMARY KEY (id));
    10  -- test ANSI_QUOTES works with quote in string
    11  insert into t1 (id, name, dt, ts) values (1, 'ar"ya', now(), now()), (2, 'catelyn', '2021-05-11 10:01:05', '2021-05-11 10:01:05');
    12  
    13  -- test sql_mode=NO_AUTO_VALUE_ON_ZERO
    14  insert into t1 (id, name) values (0, 'lalala');
    15  
    16  -- test block-allow-list
    17  drop database if exists `ignore_db`;
    18  create database `ignore_db`;
    19  use `ignore_db`;
    20  create table `ignore_table`(id int);