CREATE TABLE "domains" (
	"id" varchar(255) PRIMARY KEY,
	"friendly_name" varchar(255),
	"support_email" varchar(255),
	"created_at" datetime,
	"updated_at" datetime
);
CREATE TABLE "tenants" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"domain_id" varchar(255),
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("domain_id") REFERENCES "domains" ("id")
);
CREATE TABLE "resource_types" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"domain_id" varchar(255),
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("domain_id") REFERENCES "domains" ("id")
);
CREATE TABLE "role_templates" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"domain_id" varchar(255),
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("domain_id") REFERENCES "domains" ("id")
);
CREATE TABLE "actions" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"resource_type_id" int,
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("resource_type_id") REFERENCES "resource_types" ("id")
);
CREATE TABLE "role_template_permissions" (
	"id" int PRIMARY KEY,
	"resource_path" varchar(255),
	"action_id" int,
	"allow_deny" varchar(255),
	"role_template_id" int,
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("action_id") REFERENCES "actions" ("id"),
	FOREIGN KEY("role_template_id") REFERENCES "role_templates" ("id")
);
CREATE TABLE "roles" (
	"id" int PRIMARY KEY,
	"name" varchar(255),
	"tenant_id" int,
	"inherits_role_id" int,
	"role_template_id" int,
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("tenant_id") REFERENCES "tenants" ("id"),
	FOREIGN KEY("inherits_role_id") REFERENCES "roles" ("id"),
	FOREIGN KEY("role_template_id") REFERENCES "role_templates" ("id")
);
CREATE TABLE "role_permissions" (
	"id" int PRIMARY KEY,
	"resource_path" varchar(255),
	"action_id" int,
	"allow_deny" varchar(255),
	"role_id" int,
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("action_id") REFERENCES "actions" ("id"),
	FOREIGN KEY("role_id") REFERENCES "roles" ("id")
);
CREATE TABLE "role_trust" (
	"id" int PRIMARY KEY,
	"usertype" varchar(255),
	"identifier" varchar(255),
	"role_id" int,
	"created_at" datetime,
	"updated_at" datetime,
	FOREIGN KEY("role_id") REFERENCES "roles" ("id")
);