-- CREATION OF TBTESTE_CALENDAR_ROLES TABLE 09/01/2024
CREATE TABLE TBTESTE_CALENDAR_ROLES (
    ID INTEGER NOT NULL,
    ROLES VARCHAR(50) NOT NULL);

ALTER TABLE TBTESTE_CALENDAR_ROLES
ADD CONSTRAINT PK_TBTESTE_CALENDAR_ROLES
PRIMARY KEY (ID);

CREATE SEQUENCE GEN_TBTESTE_CALENDAR_ROLES_ID;

-- INSERTING IN THE TABLE TBTESTE_CALENDAR_ROLES SOME ROLES 12/01/2024
UPDATE OR INSERT INTO TBTESTE_CALENDAR_ROLES (ID, ROLES)
                                      VALUES (1, 'DEV')
                                    MATCHING (ID, ROLES);
UPDATE OR INSERT INTO TBTESTE_CALENDAR_ROLES (ID, ROLES)
                                      VALUES (2, 'NARUTEIRO')
                                    MATCHING (ID, ROLES);
UPDATE OR INSERT INTO TBTESTE_CALENDAR_ROLES (ID, ROLES)
                                      VALUES (3, '10ANISTA')
                                    MATCHING (ID, ROLES);

COMMIT WORK;

-- INSERTING IN THE TABLE TBTESTE_CALENDAR_ROLES SOME ROLES 12/01/2024
DROP SEQUENCE GEN_TBTESTE_CALENDAR_ROLES_ID;

CREATE SEQUENCE GTBTESTE_CALENDAR_ROLES_ID;

SET GENERATOR GTBTESTE_CALENDAR_ROLES_ID TO 3;
