Upgraders Testing/Create tables (PostgreSQL)

Script for 2.40/2.3x

/************************C_ROOM TABLE******************************/

CREATE TABLE C_ROOM
(
 C_ROOM_ID  	     numeric(10)                 NOT NULL,
 AD_CLIENT_ID       numeric(10)                 NOT NULL,
 AD_ORG_ID          numeric(10)                 NOT NULL,
 ISACTIVE           character(1)               NOT NULL DEFAULT 'Y'::bpchar,
 CREATED            timestamp without time zone NOT NULL DEFAULT now(),
 CREATEDBY          numeric(10)                 NOT NULL,
 UPDATED            timestamp without time zone NOT NULL DEFAULT now(),
 UPDATEDBY          numeric(10)                 NOT NULL,
 NAME               character varying(60)              NOT NULL,
 DESCRIPTION        character varying(255),
 ROOMTYPE	     character(2),
 LOCATION	     character varying(255),
 CONSTRAINT c_room_key PRIMARY KEY (c_room_id),
 CONSTRAINT adclient_c_room FOREIGN KEY (ad_client_id)
     REFERENCES ad_client (ad_client_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT c_room_org FOREIGN KEY (ad_org_id)
     REFERENCES ad_org (ad_org_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT c_room_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE c_room OWNER TO tad;
COMMENT ON COLUMN c_room.description IS '--OBTG:NVARCHAR--';
COMMENT ON COLUMN c_room.name IS '--OBTG:NVARCHAR--';
COMMENT ON COLUMN c_room.location IS '--OBTG:NVARCHAR--';


/*********************************************C_ROOMSCHEDULE***************************/

CREATE TABLE C_ROOMSCHEDULE
(
 C_ROOMSCHEDULE_ID  numeric(10)                 NOT NULL,
 AD_CLIENT_ID       numeric(10)                 NOT NULL,
 AD_ORG_ID          numeric(10)                 NOT NULL,
 ISACTIVE           character(1)               NOT NULL DEFAULT 'Y'::bpchar,
 CREATED            timestamp without time zone NOT NULL DEFAULT now(),
 CREATEDBY          numeric(10)                 NOT NULL,
 UPDATED            timestamp without time zone NOT NULL DEFAULT now(),
 UPDATEDBY          numeric(10)                 NOT NULL,
 C_ROOM_ID	     numeric(10)			NOT NULL,
 TOPIC        	     character varying(255),
 RESERVATIONDATE    timestamp without time zone			NOT NULL,
 STARTTIME          timestamp without time zone			NOT NULL,
 ENDTIME            timestamp without time zone			NOT NULL,
 AD_USER_ID         numeric(10),
 FREQUENCY          character(2),
 CONSTRAINT c_roomschedule_key PRIMARY KEY (c_roomschedule_id),
 CONSTRAINT adclient_c_roomschedule FOREIGN KEY (ad_client_id)
     REFERENCES ad_client (ad_client_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT c_roomschedule_org FOREIGN KEY (ad_org_id)
     REFERENCES ad_org (ad_org_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT c_roomschedule_room FOREIGN KEY (c_room_id)
     REFERENCES c_room (c_room_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT c_roomschedule_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE c_roomschedule OWNER TO tad;


/***********************************************C_ROOMATTEND*********************************/

CREATE TABLE C_ROOMATTEND
(
 C_ROOMATTEND_ID           numeric(10)          NOT NULL,
 AD_CLIENT_ID              numeric(10)          NOT NULL,
 AD_ORG_ID                 numeric(10)          NOT NULL,
 ISACTIVE                  character(1)        NOT NULL DEFAULT 'Y'::bpchar,
 CREATED                   timestamp without time zone                DEFAULT now()               NOT NULL,
 CREATEDBY                 numeric(10)          NOT NULL,
 UPDATED                   timestamp without time zone                DEFAULT now()               NOT NULL,
 UPDATEDBY                 numeric(10)          NOT NULL,
 C_ROOMSCHEDULE_ID            numeric(10)		NOT NULL,
 MEETINGROLE               character varying(255),
 TYPEATTENDER              character(2),
 DEPARTMENT                character(2),
 AD_USER_ID                numeric(10),
 C_BPARTNER_ID             numeric(10),
 CONSTRAINT c_roomattend_key PRIMARY KEY (c_roomattend_id),
 CONSTRAINT adclient_c_roomattend FOREIGN KEY (ad_client_id)
     REFERENCES ad_client (ad_client_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT c_roomattend_org FOREIGN KEY (ad_org_id)
     REFERENCES ad_org (ad_org_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT auser_c_roomattend FOREIGN KEY (ad_user_id)
     REFERENCES ad_user (ad_user_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT bpartner_c_roomattend FOREIGN KEY (c_bpartner_id)
     REFERENCES c_bpartner (c_bpartner_id) MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION,
 CONSTRAINT c_roomattend_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE c_roomattend OWNER TO tad;
COMMENT ON COLUMN c_roomattend.typeattender IS '--OBTG:NVARCHAR--';

Script for 2.50 or higher

/************************C_ROOM TABLE******************************/
CREATE TABLE C_ROOM
(
C_ROOM_ID  	     character varying(32)                 NOT NULL,
AD_CLIENT_ID       character varying(32)                 NOT NULL,
AD_ORG_ID          character varying(32)                 NOT NULL,
ISACTIVE           character(1)               NOT NULL DEFAULT 'Y'::bpchar,
CREATED            timestamp without time zone NOT NULL DEFAULT now(),
CREATEDBY          character varying(32)                NOT NULL,
UPDATED            timestamp without time zone NOT NULL DEFAULT now(),
UPDATEDBY          character varying(32)                 NOT NULL,
NAME               character varying(60)              NOT NULL,
DESCRIPTION        character varying(255),
ROOMTYPE	     character(2),
LOCATION	     character varying(255),
CONSTRAINT c_room_key PRIMARY KEY (c_room_id),
CONSTRAINT adclient_c_room FOREIGN KEY (ad_client_id)
    REFERENCES ad_client (ad_client_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT c_room_org FOREIGN KEY (ad_org_id)
    REFERENCES ad_org (ad_org_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT c_room_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE c_room OWNER TO tad;
COMMENT ON COLUMN c_room.description IS '--OBTG:NVARCHAR--';
COMMENT ON COLUMN c_room.name IS '--OBTG:NVARCHAR--';
COMMENT ON COLUMN c_room.location IS '--OBTG:NVARCHAR--';


/*********************************************C_ROOMSCHEDULE***************************/

CREATE TABLE C_ROOMSCHEDULE
(
C_ROOMSCHEDULE_ID  character varying(32)                 NOT NULL,
AD_CLIENT_ID       character varying(32)                 NOT NULL,
AD_ORG_ID          character varying(32)                 NOT NULL,
ISACTIVE           character(1)               NOT NULL DEFAULT 'Y'::bpchar,
CREATED            timestamp without time zone NOT NULL DEFAULT now(),
CREATEDBY          character varying(32)                 NOT NULL,
UPDATED            timestamp without time zone NOT NULL DEFAULT now(),
UPDATEDBY          character varying(32)                NOT NULL,
C_ROOM_ID	     character varying(32)			NOT NULL,
TOPIC        	     character varying(255),
RESERVATIONDATE    timestamp without time zone			NOT NULL,
STARTTIME          timestamp without time zone			NOT NULL,
ENDTIME            timestamp without time zone			NOT NULL,
AD_USER_ID         character varying(32),
FREQUENCY          character(2),
CONSTRAINT c_roomschedule_key PRIMARY KEY (c_roomschedule_id),
CONSTRAINT adclient_c_roomschedule FOREIGN KEY (ad_client_id)
    REFERENCES ad_client (ad_client_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT c_roomschedule_org FOREIGN KEY (ad_org_id)
    REFERENCES ad_org (ad_org_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT c_roomschedule_room FOREIGN KEY (c_room_id)
    REFERENCES c_room (c_room_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT c_roomschedule_isactive_check CHECK (isactive = ANY  (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE c_roomschedule OWNER TO tad;


/***********************************************C_ROOMATTEND*********************************/

CREATE TABLE C_ROOMATTEND
(
C_ROOMATTEND_ID           character varying(32)          NOT NULL,
AD_CLIENT_ID              character varying(32)          NOT NULL,
AD_ORG_ID                 character varying(32)          NOT NULL,
ISACTIVE                  character(1)        NOT NULL DEFAULT 'Y'::bpchar,
CREATED                   timestamp without time zone                DEFAULT now()               NOT NULL,
CREATEDBY                 character varying(32)         NOT NULL,
UPDATED                   timestamp without time zone                DEFAULT now()               NOT NULL,
UPDATEDBY                 character varying(32)          NOT NULL,
C_ROOMSCHEDULE_ID            character varying(32)		NOT NULL,
MEETINGROLE               character varying(255),
TYPEATTENDER              character(2),
DEPARTMENT                character(2),
AD_USER_ID                character varying(32),
C_BPARTNER_ID             character varying(32),
CONSTRAINT c_roomattend_key PRIMARY KEY (c_roomattend_id),
CONSTRAINT adclient_c_roomattend FOREIGN KEY (ad_client_id)
    REFERENCES ad_client (ad_client_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT c_roomattend_org FOREIGN KEY (ad_org_id)
    REFERENCES ad_org (ad_org_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT auser_c_roomattend FOREIGN KEY (ad_user_id)
    REFERENCES ad_user (ad_user_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT bpartner_c_roomattend FOREIGN KEY (c_bpartner_id)
    REFERENCES c_bpartner (c_bpartner_id) MATCH SIMPLE
    ON UPDATE NO ACTION ON DELETE NO ACTION,
CONSTRAINT c_roomattend_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))
)
WITH (OIDS=FALSE);
ALTER TABLE c_roomattend OWNER TO tad;
COMMENT ON COLUMN c_roomattend.typeattender IS '--OBTG:NVARCHAR--';