create_project_permissions.sql

10 lines | 264 B Blame History Raw Download
CREATE TABLE project_permissions (
	project_id VARCHAR(64) NOT NULL,
	modified_time BIGINT NOT NULL,
	name VARCHAR(64) NOT NULL,
	permissions INT NOT NULL,
	isGroup BOOLEAN NOT NULL,
	PRIMARY KEY (project_id, name),
	INDEX project_id (project_id)
) ENGINE=InnoDB;