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

     1  drop database if exists `all_mode`;
     2  create database `all_mode`;
     3  use `all_mode`;
     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 downstream schema contains extra datetime/timestamp column
    17  -- do not use sync-diff to check this table
    18  create table no_diff(id int NOT NULL PRIMARY KEY);
    19  insert into no_diff (id) values (1), (2), (3);
    20  
    21  -- test block-allow-list
    22  drop database if exists `ignore_db`;
    23  create database `ignore_db`;
    24  use `ignore_db`;
    25  create table `ignore_table`(id int);