-- Project:           Scheme-PG
-- Author:            David J. Neu, djneu@acm.org
-- Maintainer:        David J. Neu, djneu@acm.org
-- Project Home Page: http://scheme-pg.sourceforge.net
-- Copyright:         Copyright (c) 2004 Universal Technical Resource Services, Inc.
-- License:           MIT License, see license.txt
-- CVS Id:            $Id: create-dbms.txt,v 1.2 2004/09/16 17:43:00 djneu Exp $

CREATE TABLE alpha
(
id integer PRIMARY KEY, 
letter character varying(1)
);

INSERT INTO alpha (id, letter) VALUES (1, 'a');
INSERT INTO alpha (id, letter) VALUES (2, 'b');
INSERT INTO alpha (id, letter) VALUES (3, 'c');
INSERT INTO alpha (id, letter) VALUES (4, 'd');
INSERT INTO alpha (id, letter) VALUES (5, 'e');
INSERT INTO alpha (id, letter) VALUES (6, 'f');
INSERT INTO alpha (id, letter) VALUES (7, 'g');
INSERT INTO alpha (id, letter) VALUES (8, 'h');
INSERT INTO alpha (id, letter) VALUES (9, 'i');
INSERT INTO alpha (id, letter) VALUES (10, 'j');
INSERT INTO alpha (id, letter) VALUES (11, 'k');
INSERT INTO alpha (id, letter) VALUES (12, 'l');
INSERT INTO alpha (id, letter) VALUES (13, 'm');
INSERT INTO alpha (id, letter) VALUES (14, 'n');
INSERT INTO alpha (id, letter) VALUES (15, 'o');
INSERT INTO alpha (id, letter) VALUES (16, 'p');
INSERT INTO alpha (id, letter) VALUES (17, 'q');
INSERT INTO alpha (id, letter) VALUES (18, 'r');
INSERT INTO alpha (id, letter) VALUES (19, 's');
INSERT INTO alpha (id, letter) VALUES (20, 't');
INSERT INTO alpha (id, letter) VALUES (21, 'u');
INSERT INTO alpha (id, letter) VALUES (22, 'v');
INSERT INTO alpha (id, letter) VALUES (23, 'w');
INSERT INTO alpha (id, letter) VALUES (24, 'x');
INSERT INTO alpha (id, letter) VALUES (25, 'y');
INSERT INTO alpha (id, letter) VALUES (26, 'z');

CREATE TABLE test
(
--abigint bigint,
--abigserial bigserial,
--abit bit,
--abit_varying bit varying(10),
aboolean boolean,
--abox box,
abytea bytea,
acharacter_varying character varying(80),
--acharacter character(10),
--acidr cidr,
--acircle circle,
adate date,
adouble_precision double precision,
--ainet inet,    
ainteger integer,
--ainterval interval,
--aline line,
--alseg lseg,
--amacaddr macaddr,
--amoney money,
--anumeric numeric(10,3),
--apath path,
--apoint point,
--apolygon polygon,
--areal real,
--asmallint smallint,
aserial serial,
atext text,
atime_without_time_zone time without time zone,
atime_with_time_zone time with time zone,
atimestamp_without_time_zone timestamp without time zone,
atimestamp_with_time_zone timestamp with time zone
);

INSERT INTO test
(
--abigint,
--abigserial,
--abit,
--abit_varying,
aboolean,
--abox,
--abytea,
acharacter_varying,
--acharacter,
--acidr,
--acircle,
--adate,
adouble_precision,
--ainet,
ainteger,
--ainterval,
--aline,
--alseg,
--amacaddr,
--amoney,
--anumeric,
--apath,
--apoint,
--apolygon,
--areal,
--asmallint,
aserial,
atext,
atime_without_time_zone,
atime_with_time_zone,
atimestamp_without_time_zone,
atimestamp_with_time_zone
)
VALUES
(
--9223372036854775807,
--abigserial,
--abit,
--abit_varying,
'true',
--abox,
--abytea,
'John Doe',
--acharacter,
--acidr,
--acircle,
--adate,
3.14159,
--ainet,
2147483647,
--ainterval,
--aline,
--alseg,
--amacaddr,
--amoney,
--anumeric,
--apath,
--apoint,
--apolygon,
--areal,
--asmallint,
2147483647,
'This is a text field.',
'12:30:01',
'12:30:01 EDT',
'2004-01-01 12:30:01',
'2004-01-01 12:30:01 EST'
);

INSERT INTO test
(
--abigint,
--abigserial,
--abit,
--abit_varying,
aboolean,
--abox,
--abytea,
acharacter_varying,
--acharacter,
--acidr,
--acircle,
--adate,
adouble_precision,
--ainet,
ainteger,
--ainterval,
--aline,
--alseg,
--amacaddr,
--amoney,
--anumeric,
--apath,
--apoint,
--apolygon,
--areal,
--asmallint,
aserial,
atext,
atime_without_time_zone,
atime_with_time_zone,
atimestamp_without_time_zone,
atimestamp_with_time_zone
)
VALUES
(
--9223372036854775807,
--abigserial,
--abit,
--abit_varying,
'true',
--abox,
--abytea,
'John Doe',
--acharacter,
--acidr,
--acircle,
--adate,
3.14159,
--ainet,
-2147483648,
--ainterval,
--aline,
--alseg,
--amacaddr,
--amoney,
--anumeric,
--apath,
--apoint,
--apolygon,
--areal,
--asmallint,
-2147483648,
'This is a text field.',
'12:30:01',
'12:30:01 EDT',
'2004-01-01 12:30:01',
'2004-01-01 12:30:01 EST'
);