root / barchart / trunk / dpri.sql

 drop table stockid cascade;
 create table stockid (ticker character(8) constraint pksid primary key,
                      name   character varying(40) NOT NULL);
 grant select on stockid to public;

 copy stockid from '/home/postgres/tickers.del' using delimiters ':';

 drop table dpri cascade;
 create table dpri  (ticker char(8) NOT NULL,
                    dte   date NOT NULL,
                    open  dec(15,2),
                    high  dec(15,2),
                    low   dec(15,2),
                    close dec(15,2),
                    volume int,
                    Primary Key (ticker,dte));
 grant select on dpri to public;

 drop table port_headers cascade;
 create table port_headers (port_id char(8) Primary Key,
                           name    char(30),
                           owner   char(30));
 create index port_owner on port_headers(owner);

 drop table holdings cascade;
 create table holdings (ticker  char(8) references stockid(ticker),
                       port_id char(8) references port_headers(port_id),
                       units   int);

 drop table trades;
 create table trades (tdate date,
                     type_bs char(2),
                     units int,
                     price);