diff options
| author | stuconnolly <stuart02@gmail.com> | 2012-09-26 09:13:37 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2012-09-26 09:13:37 +0000 |
| commit | eadc3430d0d7a4c91402038bfe4b32e9ca571aff (patch) | |
| tree | f22062d323135387b2b2fe760ed7f3fe49414eab /Frameworks/PostgresKit/Resources/TestData.sql | |
| parent | 88263061eb326e58fe882bc91d09f52d3d49628d (diff) | |
| download | sequelpro-eadc3430d0d7a4c91402038bfe4b32e9ca571aff.tar.gz sequelpro-eadc3430d0d7a4c91402038bfe4b32e9ca571aff.tar.bz2 sequelpro-eadc3430d0d7a4c91402038bfe4b32e9ca571aff.zip | |
Update test data.
Diffstat (limited to 'Frameworks/PostgresKit/Resources/TestData.sql')
| -rw-r--r-- | Frameworks/PostgresKit/Resources/TestData.sql | 26 |
1 files changed, 11 insertions, 15 deletions
diff --git a/Frameworks/PostgresKit/Resources/TestData.sql b/Frameworks/PostgresKit/Resources/TestData.sql index d60d202d..c5231414 100644 --- a/Frameworks/PostgresKit/Resources/TestData.sql +++ b/Frameworks/PostgresKit/Resources/TestData.sql @@ -4,23 +4,17 @@ -- -- For the tests to execute successfully this file should -- be run against a blank database called 'pgkit_test' and --- the user 'pgkit_test' with password 'pgkit' should exit: +-- the user 'pgkit_test' with password 'pgkit' should exist: -- -- CREATE DATABASE pgkit_test; -- CREATE USER pgkit_test WITH PASSWORD 'pgkit'; -BEGIN; - SET datestyle = 'DMY'; SET client_encoding = 'UNICODE'; -IF EXISTS ( - SELECT 1 FROM information_schema.tables - WHERE table_name = 'data_types' - AND table_type = 'BASE TABLE' -) - DROP TABLE data_types; -END +BEGIN; + +DROP TABLE IF EXISTS data_types; CREATE TABLE data_types ( @@ -29,7 +23,7 @@ CREATE TABLE data_types bigint_field BIGINT NOT NULL, bool_field BOOL NOT NULL, float_field REAL NOT NULL, - numeric_field NUMERIC(5, 3) NOT NULL, + numeric_field NUMERIC(8, 3) NOT NULL, char_field CHAR(4) NOT NULL, varchar_field VARCHAR(32) NOT NULL, date_field DATE NOT NULL, @@ -42,8 +36,10 @@ CREATE TABLE data_types INSERT INTO data_types ( int_field, smallint_field, + bigint_field, bool_field, - float_field, + float_field, + numeric_field, char_field, varchar_field, date_field, @@ -53,9 +49,9 @@ INSERT INTO data_types ( timestamptz_field) VALUES ( 12345, - 2, - TRUE, + 2, 123456789, + TRUE, 12345.678, 12345.678, 'CHAR', @@ -64,7 +60,7 @@ VALUES ( '02:02:02', '02:02:02 GMT', '08-04-1987 02:02:02', - '08-04-1987 02:02:02 GMT') + '08-04-1987 02:02:02 GMT'); COMMIT; |