BEGIN;

-- These tables may already exist. In that case the errors can be ignored.
-- CREATE TABLE IF NOT EXISTS not supported by our postgresql version
CREATE TABLE cmc (
 id serial,

 created timestamp with time zone not null default CURRENT_TIMESTAMP,
 lastupdate timestamp with time zone not null default CURRENT_TIMESTAMP,
 company integer NOT NULL default '1',
 name varchar(255) NOT NULL default '',
 shortname varchar(255) NOT NULL default '',
 code varchar(10) NOT NULL default '',
 description varchar(256) NOT NULL default '',
 PRIMARY KEY  (id)
);

GRANT UPDATE, SELECT, INSERT, DELETE ON cmc TO astium;
GRANT UPDATE, SELECT, INSERT, DELETE ON cmc_id_seq TO astium;

COMMIT;

BEGIN;

CREATE TABLE qprc (
 id serial,

 created timestamp with time zone not null default CURRENT_TIMESTAMP,
 lastupdate timestamp with time zone not null default CURRENT_TIMESTAMP,
 company integer NOT NULL default '1',
 name varchar(255) NOT NULL default '',
 shortname varchar(255) NOT NULL default '',
 code varchar(10) NOT NULL default '',
 description varchar(256) NOT NULL default '',
 PRIMARY KEY  (id)
);

GRANT UPDATE, SELECT, INSERT, DELETE ON qprc TO astium;
GRANT UPDATE, SELECT, INSERT, DELETE ON qprc_id_seq TO astium;

COMMIT;
