CREATE TABLE role_verification (
	id VARCHAR(255) PRIMARY KEY,
	email VARCHAR(255) NOT NULL,
	verification_code  VARCHAR(6) NOT NULL,
	type VARCHAR(255) NOT NULL,
	entity VARCHAR(255) NOT NULL,
	verification_type VARCHAR(255) NOT NULL,
	date TIMESTAMP NOT NULL
);

GRANT ALL PRIVILEGES ON TABLE role_verification TO postgresi2;

CREATE TABLE registered_service (
 id SERIAL PRIMARY KEY,
 client_id VARCHAR(255) NOT NULL,
 owner VARCHAR(255) NOT NULL,
 name VARCHAR(255) NOT NULL,
 creation_date TIMESTAMP NOT NULL,
 registration_access_token TEXT NOT NULL,
 key_type VARCHAR(255)
);

GRANT ALL PRIVILEGES ON TABLE registered_service TO postgresi2;
GRANT USAGE, SELECT ON SEQUENCE registered_service_id_seq TO postgresi2;