liquibase.harness.change.expectedSql.db2-luw.1initScript.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of liquibase-test-harness Show documentation

Test Harness For Liquibase

The newest version!

DROP TABLE IF EXISTS DB2INST1.authors;

CREATE TABLE DB2INST1.authors (
                                  id INT NOT NULL PRIMARY KEY,
                                  first_name VARCHAR(50) NOT NULL,
                                  last_name VARCHAR(50) NOT NULL,
                                  email VARCHAR(100) NOT NULL,
                                  birthdate DATE NOT NULL,
                                  added TIMESTAMP NOT NULL WITH DEFAULT
);

INSERT INTO DB2INST1.authors VALUES (1,'Eileen','Lubowitz','[email protected]','1991-03-04','2004-05-30 02:08:25');
INSERT INTO DB2INST1.authors VALUES (2,'Tamia','Mayert','[email protected]','2016-03-27','2014-03-21 02:52:00');
INSERT INTO DB2INST1.authors VALUES (3,'Cyril','Funk','[email protected]','1988-04-21','2011-06-24 18:17:48');
INSERT INTO DB2INST1.authors VALUES (4,'Nicolas','Buckridge','[email protected]','2017-02-03','2019-04-22 02:04:41');
INSERT INTO DB2INST1.authors VALUES (5,'Jayden','Walter','[email protected]','2010-02-27','1990-02-04 02:32:00');

DROP TABLE IF EXISTS DB2INST1.posts;

CREATE TABLE DB2INST1.posts (
                                id INT NOT NULL,
                                author_id INT NOT NULL,
                                title VARCHAR(255) NOT NULL,
                                description VARCHAR(500) NOT NULL,
                                content VARCHAR(500) NOT NULL,
                                inserted_date DATE
);

INSERT INTO DB2INST1.posts VALUES (1,1,'temporibus','voluptatum','Fugit non et doloribus repudiandae.','2015-11-18');
INSERT INTO DB2INST1.posts VALUES (2,2,'ea','aut','Tempora molestias maiores provident molestiae sint possimus quasi.','1975-06-08');
INSERT INTO DB2INST1.posts VALUES (3,3,'illum','rerum','Delectus recusandae sit officiis dolor.','1975-02-25');
INSERT INTO DB2INST1.posts VALUES (4,4,'itaque','deleniti','Magni nam optio id recusandae.','2010-07-28');
INSERT INTO DB2INST1.posts VALUES (5,5,'ad','similique','Rerum tempore quis ut nesciunt qui excepturi est.','2006-10-09');