Sha256: 06635ccf4cfe3d609b5fff1b4337d6a8dd64b3e1d109c7f75bdb5ec1f54e957f
Contents?: true
Size: 949 Bytes
Versions: 8
Compression:
Stored size: 949 Bytes
Contents
DROP TABLE IF EXISTS empty;
CREATE TABLE empty (
id INT,
value VARCHAR(200));
DROP TABLE IF EXISTS one;
CREATE TABLE one (
id INT,
value VARCHAR(200));
INSERT INTO one (id, value) VALUES (42, '你好, Dave.');
DROP TABLE IF EXISTS "some";
CREATE TABLE "some" (
id INT,
value VARCHAR(100));
INSERT INTO "some" (id, value) VALUES (1, 'Bah'), (2, 'Hah'), (3, '你好, Dave.');
DROP TABLE IF EXISTS typey;
CREATE TABLE typey (
korea BOOLEAN DEFAULT TRUE,
japan DECIMAL(19,3),
china BYTEA);
INSERT INTO typey (korea, japan, china) VALUES (true, 1234567890123456.789, E'WHAT\\000'), (false, -1234567890123456.789, E'HUH\\001\\002');
DROP TABLE IF EXISTS autoid;
CREATE TABLE autoid (
id SERIAL PRIMARY KEY NOT NULL,
value VARCHAR(100));
DROP TABLE IF EXISTS times;
CREATE TABLE times (
id SERIAL PRIMARY KEY NOT NULL,
time TIMESTAMP WITHOUT TIME ZONE NOT NULL);
INSERT INTO times (time) VALUES ('2012-11-10T19:45:00Z');
Version data entries
8 entries across 8 versions & 1 rubygems