Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
1.4 kB
20
Indexable
Never
-- Create the Authorize table
CREATE TABLE Authorize (
    id INT PRIMARY KEY,
    role VARCHAR(255),
    url VARCHAR(255)
);

-- Insert data into the Authorize table
INSERT INTO Authorize (id, role, url)
VALUES
    (1, 'manager', '/ChildrenCare/managercustomer'),
    (2, 'manager', '/ChildrenCare/managerslider'),
    (3, 'manager', '/ChildrenCare/feedbacklist'),
    (4, 'manager', '/ChildrenCare/feedbackdetails'),
    (5, 'customer', '/ChildrenCare/blog'),
    (6, 'customer', '/ChildrenCare/blogdetail'),
    (7, 'customer', '/ChildrenCare/changeProfile'),
    (8, 'customer', '/ChildrenCare/changePassword'),
    (9, 'customer', '/ChildrenCare/ReservationDetails'),
    (10, 'customer', '/ChildrenCare/ReservationContact'),
    (11, 'customer', '/ChildrenCare/listservice'),
    (12, 'customer', '/ChildrenCare/Profile.jsp'),
    (13, 'customer', '/ChildrenCare/servicelist');
-- Create the Unauthorize table
CREATE TABLE Unauthorize (
    id INT PRIMARY KEY,
    url VARCHAR(255)
);

-- Insert data into the Unauthorize table
INSERT INTO Unauthorize (id, url)
VALUES
    (1, '/ChildrenCare/ChangePassword'),
    (2, '/ChildrenCare/signupverify'),
    (3, '/ChildrenCare/resetreq'),
    (4, '/ChildrenCare/resetpw'),
    (5, '/ChildrenCare/changeProfile'),
    (6, '/ChildrenCare/login'),
    (7, '/ChildrenCare/logout');