From 8c6666fd8f0c32dccd5b7d645e1381d9aad488f4 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Tue, 25 Sep 2012 08:38:09 +0000 Subject: Update test data. --- Frameworks/PostgresKit/Resources/TestData.sql | 28 ++++++++++++++------------- 1 file changed, 15 insertions(+), 13 deletions(-) (limited to 'Frameworks/PostgresKit') diff --git a/Frameworks/PostgresKit/Resources/TestData.sql b/Frameworks/PostgresKit/Resources/TestData.sql index ebcf6309..d60d202d 100644 --- a/Frameworks/PostgresKit/Resources/TestData.sql +++ b/Frameworks/PostgresKit/Resources/TestData.sql @@ -24,17 +24,18 @@ END CREATE TABLE data_types ( - int_field INT PRIMARY KEY NOT NULL, - smallint_field SMALLINT NOT NULL, - bigint_field BIGINT NOT NULL, - bool_field BOOL NOT NULL, - float_field REAL NOT NULL, - char_field CHAR(5) NOT NULL, - varchar_field VARCHAR(32) NOT NULL, - date_field DATE NOT NULL, - time_field TIME NOT NULL, - timetz_field TIME WITH TIME ZONE NOT NULL, - timstamp_field TIMESTAMP NOT NULL, + int_field INT PRIMARY KEY NOT NULL, + smallint_field SMALLINT NOT NULL, + bigint_field BIGINT NOT NULL, + bool_field BOOL NOT NULL, + float_field REAL NOT NULL, + numeric_field NUMERIC(5, 3) NOT NULL, + char_field CHAR(4) NOT NULL, + varchar_field VARCHAR(32) NOT NULL, + date_field DATE NOT NULL, + time_field TIME NOT NULL, + timetz_field TIME WITH TIME ZONE NOT NULL, + timstamp_field TIMESTAMP NOT NULL, timestamptz_field TIMESTAMP WITH TIME ZONE NOT NULL ); @@ -55,9 +56,10 @@ VALUES ( 2, TRUE, 123456789, + 12345.678, 12345.678, - 'CHARV', - 'VARCHAR_VALUE', + 'CHAR', + 'VARCHAR', '08-04-1987', '02:02:02', '02:02:02 GMT', -- cgit v1.2.3