diff options
author | Feideus <erwan.ulrich@gmail.com> | 2018-07-02 11:26:00 +0200 |
---|---|---|
committer | Feideus <erwan.ulrich@gmail.com> | 2018-07-02 11:26:00 +0200 |
commit | 22c22d3252bdc8008c5f931f4b452e5a3505342b (patch) | |
tree | f8d39b5798aa699c89296e1342ea0ef092f1d46a /sample_database | |
parent | 2e2b4a80d793390f0bc10b96ef52a18975541711 (diff) | |
download | schemafuzz-22c22d3252bdc8008c5f931f4b452e5a3505342b.tar.gz schemafuzz-22c22d3252bdc8008c5f931f4b452e5a3505342b.tar.bz2 schemafuzz-22c22d3252bdc8008c5f931f4b452e5a3505342b.zip |
db setup script, bugg fixing and minor optimisation
Diffstat (limited to 'sample_database')
-rw-r--r-- | sample_database/pagila-0.10.1/setup_test_table.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/sample_database/pagila-0.10.1/setup_test_table.sql b/sample_database/pagila-0.10.1/setup_test_table.sql new file mode 100644 index 0000000..afcd341 --- /dev/null +++ b/sample_database/pagila-0.10.1/setup_test_table.sql @@ -0,0 +1,15 @@ +DROP TABLE actual_test_table; + +CREATE TABLE actual_test_table ( + address_id integer DEFAULT nextval('address_address_id_seq'::regclass) NOT NULL, + address character varying(50) NOT NULL, + address2 character varying(50), + district character varying(20) NOT NULL, + city_id smallint NOT NULL, + postal_code character varying(10), + phone character varying(20) NOT NULL + ); + +INSERT INTO actual_test_table VALUES (0 ,23, 'Workhaven Lane' ,'Alberta' ,300,93360 ,14033335567); +INSERT INTO actual_test_table VALUES (4 ,1411, 'Lillydale Drive' ,'QLD' ,576 ,88888,6172235589); +INSERT INTO actual_test_table VALUES (5 ,1913, 'Hanoi Way' ,'Nagasaki' ,463 ,42420,28303384290); |