github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/ccl/importccl/testdata/cockroachdump/dump.sql (about)

     1  CREATE TABLE t (
     2  	i INT NOT NULL,
     3  	t STRING NULL,
     4  	CONSTRAINT "primary" PRIMARY KEY (i ASC),
     5  	INDEX t_t_idx (t ASC),
     6  	FAMILY "primary" (i, t)
     7  );
     8  
     9  CREATE TABLE a (
    10  	i INT NOT NULL,
    11  	CONSTRAINT "primary" PRIMARY KEY (i ASC),
    12  	FAMILY "primary" (i)
    13  );
    14  
    15  INSERT INTO t (i, t) VALUES
    16  	(1, 'test'),
    17  	(2, 'other');
    18  
    19  INSERT INTO a (i) VALUES
    20  	(2);
    21  
    22  ALTER TABLE a ADD CONSTRAINT fk_i_ref_t FOREIGN KEY (i) REFERENCES t (i);
    23  
    24  -- Validate foreign key constraints. These can fail if there was unvalidated data during the dump.
    25  ALTER TABLE a VALIDATE CONSTRAINT fk_i_ref_t;