-- See postgresinit.sql

drop schema public cascade;
create schema public;

-- Table: dept

-- DROP TABLE dept;

CREATE TABLE dept
(
deptno integer NOT NULL,
loc text,
CONSTRAINT dept_pkey PRIMARY KEY (deptno)
)
WITH (
OIDS=FALSE
);

insert into dept(deptno, loc)
values (1,'SAN FRANCISCO'),
(2,'NEW YORK'),
(3,'MIAMI');
