functionalities

CREATE TABLE functionalities
(
    id SERIAL NOT NULL ,
    name character varying,
    creation_date timestamp without time zone NOT NULL DEFAULT now(),
    created_by integer NOT NULL,
    last_updated_by integer NOT NULL,
    last_update_date timestamp without time zone NOT NULL DEFAULT now(),
    row_status character varying(1) NOT NULL DEFAULT 'A'::character varying,
    CONSTRAINT functionalities_pkey PRIMARY KEY (id)
);

SELECT pg_sleep(0.5);


CREATE TABLE role_functionalities
(
    id SERIAL NOT NULL ,
    functionality_id integer,
    role_id integer,
    creation_date timestamp without time zone NOT NULL DEFAULT now(),
    created_by integer NOT NULL,
    last_updated_by integer NOT NULL,
    last_update_date timestamp without time zone NOT NULL DEFAULT now(),
    row_status character varying(1) NOT NULL DEFAULT 'A'::character varying,
    CONSTRAINT roles_functionalities_pkey PRIMARY KEY (id)
);

SELECT pg_sleep(0.5);

ALTER TABLE role_functionalities
ADD CONSTRAINT role_functionalities_functionality_id_fkey FOREIGN KEY (functionality_id)
REFERENCES functionalities (id) ;

ALTER TABLE role_functionalities
ADD CONSTRAINT role_functionalities_role_id_fkey FOREIGN KEY (role_id)
REFERENCES roles (id) ;

SELECT pg_sleep(0.5);



INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (1, 'Dashboard', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (2, 'Settings', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (21, 'Users', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (22, 'Roles', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (23, 'Support Tables', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (24, 'Divisions', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (25, 'Branches', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (26, 'My Team', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (27, 'System', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (3, 'Contacts', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (31, 'All Contacts', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (32, 'Map of States', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (33, 'My Lead', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (4, 'Red Flag', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (41, 'Red Flagged', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (42, 'Red Flag Resolved', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (5, 'Calendar', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (6, 'Help Requests', 1, 1);
INSERT INTO functionalities (id, name, created_by, last_updated_by) VALUES (7, 'Last Contact Report', 1, 1);

SELECT pg_sleep(0.5);



INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (1,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (2,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (21,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (22,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (23,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (24,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (25,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (26,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (27,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (3,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (31,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (32, 1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (33, 1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (4,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (41,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (42,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (5,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (6,  1, 1, 1);
INSERT INTO role_functionalities (functionality_id,  created_by, last_updated_by, role_id) VALUES (7, 1, 1, 1);