diff options
| author | stuconnolly <stuart02@gmail.com> | 2012-09-25 08:38:09 +0000 |
|---|---|---|
| committer | stuconnolly <stuart02@gmail.com> | 2012-09-25 08:38:09 +0000 |
| commit | 8c6666fd8f0c32dccd5b7d645e1381d9aad488f4 (patch) | |
| tree | e787f9c6ebcb84647440bdee9f5a6f2a3912857b /Frameworks/PostgresKit/Resources/TestData.sql | |
| parent | 2d758f56ca2f8d0029daa12884e9a68090682372 (diff) | |
| download | sequelpro-8c6666fd8f0c32dccd5b7d645e1381d9aad488f4.tar.gz sequelpro-8c6666fd8f0c32dccd5b7d645e1381d9aad488f4.tar.bz2 sequelpro-8c6666fd8f0c32dccd5b7d645e1381d9aad488f4.zip | |
Update test data.
Diffstat (limited to 'Frameworks/PostgresKit/Resources/TestData.sql')
| -rw-r--r-- | Frameworks/PostgresKit/Resources/TestData.sql | 28 |
1 files changed, 15 insertions, 13 deletions
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', |