github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/ccl/backupccl/testdata/restore_old_versions/create.sql (about)

     1  -- The below SQL is used to create the data that is then exported with BACKUP
     2  -- for use in the RestoreOldVersions test. Each of t1, t2, and t3 should contain
     3  -- the same rows when ordered by k.
     4  
     5  CREATE DATABASE test;
     6  
     7  SET database = test;
     8  
     9  -- t1 gets some modifications.
    10  
    11  CREATE TABLE t1 (k INT8 PRIMARY KEY, v1 INT8);
    12  
    13  ALTER TABLE t1 ADD COLUMN v2 INT8;
    14  
    15  CREATE INDEX t1_v2 ON t1 (v2);
    16  
    17  -- t2 is an unmodified table.
    18  
    19  CREATE TABLE t2 (k INT8 PRIMARY KEY, v1 INT8, v2 INT8);
    20  
    21  -- t3 and t4 are interleaved.
    22  
    23  CREATE TABLE t3 (k INT8 PRIMARY KEY);
    24  
    25  CREATE TABLE t4 (k INT8 PRIMARY KEY, v1 INT8, v2 INT8, CONSTRAINT fk_t3 FOREIGN KEY (k) REFERENCES t3)
    26      INTERLEAVE IN PARENT t3 (k);
    27  
    28  INSERT INTO t1 VALUES (1, 1, 1), (2, 2, 2), (3, 3, 3);
    29  
    30  INSERT INTO t2 VALUES (1, 1, 1), (2, 2, 2), (3, 3, 3);
    31  
    32  INSERT INTO t3 VALUES (1), (2), (3);
    33  
    34  INSERT INTO t4 VALUES (1, 1, 1), (2, 2, 2), (3, 3, 3);
    35