aboutsummaryrefslogtreecommitdiffstats
path: root/Frameworks/PostgresKit/Resources/TestData.sql
diff options
context:
space:
mode:
authorstuconnolly <stuart02@gmail.com>2012-09-25 08:38:09 +0000
committerstuconnolly <stuart02@gmail.com>2012-09-25 08:38:09 +0000
commit8c6666fd8f0c32dccd5b7d645e1381d9aad488f4 (patch)
treee787f9c6ebcb84647440bdee9f5a6f2a3912857b /Frameworks/PostgresKit/Resources/TestData.sql
parent2d758f56ca2f8d0029daa12884e9a68090682372 (diff)
downloadsequelpro-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.sql28
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',