CREATE TABLE  IF NOT EXISTS group_access (
	cat_cd	character varying(10) NOT NULL,
	subcat_cd	character varying(10) NOT NULL,
	group_cd	character varying(10) NOT NULL,
	writeable	character varying(1)  DEFAULT 't' NOT NULL
) type=innodb;

GRANT ALL ON masters.group_access TO nobody;
FLUSH PRIVILEGES;

CREATE TABLE IF NOT EXISTS facility_category (
        fac_cat_cd character varying(10) NOT NULL,
        fac_cat_name character varying(100) NOT NULL,
        enable CHARACTER VARYING(1) DEFAULT 't' NOT NULL,
        CONSTRAINT facility_category_fac_cat_cd PRIMARY KEY(fac_cat_cd)
) type=innodb;

GRANT ALL ON masters.facility_category TO nobody;
FLUSH PRIVILEGES;

ALTER TABLE facilities ADD COLUMN fac_cat_cd character varying(10);

ALTER TABLE group_master ADD CONSTRAINT group_master_group_cd PRIMARY KEY(group_cd);
ALTER TABLE group_master ADD COLUMN public_flg character varying(1) DEFAULT 't' NOT NULL;
ALTER TABLE group_master ALTER COLUMN public_flg SET DEFAULT 'f';

INSERT INTO facility_category (fac_cat_cd, fac_cat_name, enable) VALUES('1', 'Default', 't');

UPDATE facilities SET fac_cat_cd = '1';

UPDATE group_master SET public_flg = 'f';