/* $Revision: 1.24 $ $Date: 2004/04/30 20:17:41 $

To create the bookstore database, run this file through psql like so:

prompt> psql -f 1_create_main_tables.postgresql bookstore bookstore_user

*/

drop sequence sales_row_num_seq;

create sequence sales_row_num_seq cycle;

drop table sales;

create table sales (
  row_num int not null default nextval('sales_row_num_seq'),
  first_name varchar(35) not null,
  middle_name varchar(35) null,
  last_name varchar(35) not null,
  city varchar(35) not null,
  state char(2) not null,
  zip varchar(5) not null,
  email_address varchar(50) not null,
  product_id int not null,
  product_name varchar(50) not null,
  product_sale_date date not null);

comment on table sales is 'Conains records of books sold from the bookstore.';
comment on column sales.row_num is 'For de-duping purposes.';

-- PLEASE don't regard this as good database design; customers should be
-- foreign keys, as should products.