trunk/drizzle/0000_init.sql

DO $$ BEGIN
 CREATE TYPE "public"."command_permission_overwrite_action" AS ENUM('Allow', 'Deny');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
 CREATE TYPE "public"."infraction_delivery_status" AS ENUM('Success', 'Failed', 'Fallback', 'NotDelivered');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
 CREATE TYPE "public"."infraction_type" AS ENUM('Ban', 'Kick', 'Mute', 'Warning', 'MassBan', 'MassKick', 'Unban', 'Unmute', 'BulkDeleteMessage', 'Timeout', 'TimeoutRemove', 'Bean', 'Note', 'Role', 'ModMessage', 'Shot');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
 CREATE TYPE "public"."permission_logic_mode" AS ENUM('And', 'Or');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
DO $$ BEGIN
 CREATE TYPE "public"."verification_method" AS ENUM('discord', 'github', 'google', 'email');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "afk_entries" (
    "id" serial PRIMARY KEY NOT NULL,
    "reason" varchar,
    "user_id" varchar NOT NULL,
    "guild_id" varchar NOT NULL,
    "mentions" varchar[] DEFAULT '{}' NOT NULL,
    "mention_count" integer DEFAULT 0 NOT NULL,
    "global" boolean DEFAULT false NOT NULL,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "channel_locks" (
    "id" serial PRIMARY KEY NOT NULL,
    "guild_id" varchar NOT NULL,
    "channel_id" varchar NOT NULL,
    "permissions" json NOT NULL,
    "created_at" timestamp with time zone DEFAULT now(),
    "updated_at" timestamp with time zone DEFAULT now()
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "command_permission_overwrites" (
    "id" serial PRIMARY KEY NOT NULL,
    "guild_id" varchar NOT NULL,
    "commands" text[] DEFAULT '{}' NOT NULL,
    "required_discord_permissions" json DEFAULT 'null'::json,
    "required_system_permissions" json DEFAULT 'null'::json,
    "required_roles" json DEFAULT 'null'::json,
    "required_users" json DEFAULT 'null'::json,
    "required_channels" json DEFAULT 'null'::json,
    "required_level" integer,
    "disabled" boolean DEFAULT false,
    "on_match" "command_permission_overwrite_action" DEFAULT 'Allow' NOT NULL,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "infractions" (
    "id" serial PRIMARY KEY NOT NULL,
    "type" "infraction_type" NOT NULL,
    "user_id" varchar NOT NULL,
    "moderator_id" varchar NOT NULL,
    "guild_id" varchar NOT NULL,
    "reason" varchar,
    "expires_at" timestamp with time zone,
    "metadata" json,
    "delivery_status" "infraction_delivery_status" DEFAULT 'Success' NOT NULL,
    "queue_id" integer,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "mute_records" (
    "id" serial PRIMARY KEY NOT NULL,
    "member_id" varchar NOT NULL,
    "guild_id" varchar NOT NULL,
    "roles" varchar[] DEFAULT '{}' NOT NULL,
    "created_at" timestamp with time zone DEFAULT now(),
    "updated_at" timestamp with time zone DEFAULT now()
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "permission_levels" (
    "id" serial PRIMARY KEY NOT NULL,
    "guild_id" varchar NOT NULL,
    "level" integer NOT NULL,
    "disabled" boolean DEFAULT false,
    "granted_discord_permissions" text[] DEFAULT '{}' NOT NULL,
    "granted_system_permissions" text[] DEFAULT '{}' NOT NULL,
    "roles" text[] DEFAULT '{}' NOT NULL,
    "users" text[] DEFAULT '{}' NOT NULL,
    "created_at" timestamp with time zone DEFAULT now(),
    "updated_at" timestamp with time zone DEFAULT now()
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "permission_overwrites" (
    "id" serial PRIMARY KEY NOT NULL,
    "name" text,
    "guild_id" varchar NOT NULL,
    "roles" text[] DEFAULT '{}' NOT NULL,
    "users" text[] DEFAULT '{}' NOT NULL,
    "granted_discord_permissions" text[] DEFAULT '{}' NOT NULL,
    "granted_system_permissions" text[] DEFAULT '{}' NOT NULL,
    "priority" integer DEFAULT 0 NOT NULL,
    "merge" boolean DEFAULT true NOT NULL,
    "disabled" boolean DEFAULT false NOT NULL,
    "created_at" timestamp with time zone DEFAULT now(),
    "updated_at" timestamp with time zone DEFAULT now()
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "queues" (
    "id" serial PRIMARY KEY NOT NULL,
    "user_id" varchar NOT NULL,
    "guild_id" varchar NOT NULL,
    "channel_id" varchar,
    "message_id" varchar,
    "name" varchar NOT NULL,
    "repeat" boolean DEFAULT false,
    "data" json DEFAULT '{}'::json,
    "created_at" timestamp with time zone DEFAULT now(),
    "updated_at" timestamp with time zone DEFAULT now(),
    "runs_at" timestamp with time zone
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "reaction_roles" (
    "id" serial PRIMARY KEY NOT NULL,
    "emoji" varchar,
    "is_built_in_emoji" boolean DEFAULT false NOT NULL,
    "guild_id" varchar NOT NULL,
    "channel_id" varchar NOT NULL,
    "message_id" varchar NOT NULL,
    "roles" varchar[] DEFAULT '{}' NOT NULL,
    "required_roles" varchar[] DEFAULT '{}' NOT NULL,
    "blacklisted_users" varchar[] DEFAULT '{}' NOT NULL,
    "required_permissions" varchar[] DEFAULT '{}' NOT NULL,
    "level" integer,
    "single" boolean DEFAULT false NOT NULL,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "snippets" (
    "id" serial PRIMARY KEY NOT NULL,
    "name" varchar,
    "user_id" varchar NOT NULL,
    "guild_id" varchar NOT NULL,
    "aliases" varchar[] DEFAULT '{}' NOT NULL,
    "roles" varchar[] DEFAULT '{}' NOT NULL,
    "channels" varchar[] DEFAULT '{}' NOT NULL,
    "users" varchar[] DEFAULT '{}' NOT NULL,
    "attachments" varchar[] DEFAULT ARRAY[]::varchar[] NOT NULL,
    "content" varchar[] DEFAULT ARRAY[]::varchar[] NOT NULL,
    "randomize" boolean DEFAULT false NOT NULL,
    "permissions" varchar[] DEFAULT ARRAY[]::varchar[] NOT NULL,
    "permission_mode" "permission_logic_mode" DEFAULT 'And' NOT NULL,
    "level" integer,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "users" (
    "id" serial PRIMARY KEY NOT NULL,
    "name" varchar,
    "username" varchar NOT NULL,
    "discord_id" varchar NOT NULL,
    "github_id" varchar,
    "guilds" varchar[] DEFAULT '{}' NOT NULL,
    "password" varchar NOT NULL,
    "token" varchar,
    "recovery_token" varchar,
    "recovery_code" varchar,
    "recovery_attempts" integer DEFAULT 0 NOT NULL,
    "recovery_token_expires_at" timestamp with time zone,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "token_expires_at" timestamp with time zone,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "verification_entries" (
    "id" serial PRIMARY KEY NOT NULL,
    "user_id" varchar NOT NULL,
    "guild_id" varchar NOT NULL,
    "code" varchar NOT NULL,
    "attempts" integer DEFAULT 0 NOT NULL,
    "metadata" json DEFAULT '{}'::json NOT NULL,
    "expires_at" timestamp with time zone NOT NULL,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL,
    CONSTRAINT "verification_entries_code_unique" UNIQUE("code")
);
--> statement-breakpoint
CREATE TABLE IF NOT EXISTS "verification_records" (
    "id" serial PRIMARY KEY NOT NULL,
    "guild_id" varchar NOT NULL,
    "user_id" varchar NOT NULL,
    "discord_id" varchar,
    "github_id" varchar,
    "google_id" varchar,
    "email" varchar,
    "method" "verification_method" NOT NULL,
    "created_at" timestamp with time zone DEFAULT now() NOT NULL,
    "updated_at" timestamp with time zone DEFAULT now() NOT NULL
);
1	DO $$ BEGIN
2	CREATE TYPE "public"."command_permission_overwrite_action" AS ENUM('Allow', 'Deny');
3	EXCEPTION
4	WHEN duplicate_object THEN null;
5	END $$;
6	--> statement-breakpoint
7	DO $$ BEGIN
8	CREATE TYPE "public"."infraction_delivery_status" AS ENUM('Success', 'Failed', 'Fallback', 'NotDelivered');
9	EXCEPTION
10	WHEN duplicate_object THEN null;
11	END $$;
12	--> statement-breakpoint
13	DO $$ BEGIN
14	CREATE TYPE "public"."infraction_type" AS ENUM('Ban', 'Kick', 'Mute', 'Warning', 'MassBan', 'MassKick', 'Unban', 'Unmute', 'BulkDeleteMessage', 'Timeout', 'TimeoutRemove', 'Bean', 'Note', 'Role', 'ModMessage', 'Shot');
15	EXCEPTION
16	WHEN duplicate_object THEN null;
17	END $$;
18	--> statement-breakpoint
19	DO $$ BEGIN
20	CREATE TYPE "public"."permission_logic_mode" AS ENUM('And', 'Or');
21	EXCEPTION
22	WHEN duplicate_object THEN null;
23	END $$;
24	--> statement-breakpoint
25	DO $$ BEGIN
26	CREATE TYPE "public"."verification_method" AS ENUM('discord', 'github', 'google', 'email');
27	EXCEPTION
28	WHEN duplicate_object THEN null;
29	END $$;
30	--> statement-breakpoint
31	CREATE TABLE IF NOT EXISTS "afk_entries" (
32	"id" serial PRIMARY KEY NOT NULL,
33	"reason" varchar,
34	"user_id" varchar NOT NULL,
35	"guild_id" varchar NOT NULL,
36	"mentions" varchar[] DEFAULT '{}' NOT NULL,
37	"mention_count" integer DEFAULT 0 NOT NULL,
38	"global" boolean DEFAULT false NOT NULL,
39	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
40	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
41	);
42	--> statement-breakpoint
43	CREATE TABLE IF NOT EXISTS "channel_locks" (
44	"id" serial PRIMARY KEY NOT NULL,
45	"guild_id" varchar NOT NULL,
46	"channel_id" varchar NOT NULL,
47	"permissions" json NOT NULL,
48	"created_at" timestamp with time zone DEFAULT now(),
49	"updated_at" timestamp with time zone DEFAULT now()
50	);
51	--> statement-breakpoint
52	CREATE TABLE IF NOT EXISTS "command_permission_overwrites" (
53	"id" serial PRIMARY KEY NOT NULL,
54	"guild_id" varchar NOT NULL,
55	"commands" text[] DEFAULT '{}' NOT NULL,
56	"required_discord_permissions" json DEFAULT 'null'::json,
57	"required_system_permissions" json DEFAULT 'null'::json,
58	"required_roles" json DEFAULT 'null'::json,
59	"required_users" json DEFAULT 'null'::json,
60	"required_channels" json DEFAULT 'null'::json,
61	"required_level" integer,
62	"disabled" boolean DEFAULT false,
63	"on_match" "command_permission_overwrite_action" DEFAULT 'Allow' NOT NULL,
64	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
65	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
66	);
67	--> statement-breakpoint
68	CREATE TABLE IF NOT EXISTS "infractions" (
69	"id" serial PRIMARY KEY NOT NULL,
70	"type" "infraction_type" NOT NULL,
71	"user_id" varchar NOT NULL,
72	"moderator_id" varchar NOT NULL,
73	"guild_id" varchar NOT NULL,
74	"reason" varchar,
75	"expires_at" timestamp with time zone,
76	"metadata" json,
77	"delivery_status" "infraction_delivery_status" DEFAULT 'Success' NOT NULL,
78	"queue_id" integer,
79	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
80	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
81	);
82	--> statement-breakpoint
83	CREATE TABLE IF NOT EXISTS "mute_records" (
84	"id" serial PRIMARY KEY NOT NULL,
85	"member_id" varchar NOT NULL,
86	"guild_id" varchar NOT NULL,
87	"roles" varchar[] DEFAULT '{}' NOT NULL,
88	"created_at" timestamp with time zone DEFAULT now(),
89	"updated_at" timestamp with time zone DEFAULT now()
90	);
91	--> statement-breakpoint
92	CREATE TABLE IF NOT EXISTS "permission_levels" (
93	"id" serial PRIMARY KEY NOT NULL,
94	"guild_id" varchar NOT NULL,
95	"level" integer NOT NULL,
96	"disabled" boolean DEFAULT false,
97	"granted_discord_permissions" text[] DEFAULT '{}' NOT NULL,
98	"granted_system_permissions" text[] DEFAULT '{}' NOT NULL,
99	"roles" text[] DEFAULT '{}' NOT NULL,
100	"users" text[] DEFAULT '{}' NOT NULL,
101	"created_at" timestamp with time zone DEFAULT now(),
102	"updated_at" timestamp with time zone DEFAULT now()
103	);
104	--> statement-breakpoint
105	CREATE TABLE IF NOT EXISTS "permission_overwrites" (
106	"id" serial PRIMARY KEY NOT NULL,
107	"name" text,
108	"guild_id" varchar NOT NULL,
109	"roles" text[] DEFAULT '{}' NOT NULL,
110	"users" text[] DEFAULT '{}' NOT NULL,
111	"granted_discord_permissions" text[] DEFAULT '{}' NOT NULL,
112	"granted_system_permissions" text[] DEFAULT '{}' NOT NULL,
113	"priority" integer DEFAULT 0 NOT NULL,
114	"merge" boolean DEFAULT true NOT NULL,
115	"disabled" boolean DEFAULT false NOT NULL,
116	"created_at" timestamp with time zone DEFAULT now(),
117	"updated_at" timestamp with time zone DEFAULT now()
118	);
119	--> statement-breakpoint
120	CREATE TABLE IF NOT EXISTS "queues" (
121	"id" serial PRIMARY KEY NOT NULL,
122	"user_id" varchar NOT NULL,
123	"guild_id" varchar NOT NULL,
124	"channel_id" varchar,
125	"message_id" varchar,
126	"name" varchar NOT NULL,
127	"repeat" boolean DEFAULT false,
128	"data" json DEFAULT '{}'::json,
129	"created_at" timestamp with time zone DEFAULT now(),
130	"updated_at" timestamp with time zone DEFAULT now(),
131	"runs_at" timestamp with time zone
132	);
133	--> statement-breakpoint
134	CREATE TABLE IF NOT EXISTS "reaction_roles" (
135	"id" serial PRIMARY KEY NOT NULL,
136	"emoji" varchar,
137	"is_built_in_emoji" boolean DEFAULT false NOT NULL,
138	"guild_id" varchar NOT NULL,
139	"channel_id" varchar NOT NULL,
140	"message_id" varchar NOT NULL,
141	"roles" varchar[] DEFAULT '{}' NOT NULL,
142	"required_roles" varchar[] DEFAULT '{}' NOT NULL,
143	"blacklisted_users" varchar[] DEFAULT '{}' NOT NULL,
144	"required_permissions" varchar[] DEFAULT '{}' NOT NULL,
145	"level" integer,
146	"single" boolean DEFAULT false NOT NULL,
147	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
148	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
149	);
150	--> statement-breakpoint
151	CREATE TABLE IF NOT EXISTS "snippets" (
152	"id" serial PRIMARY KEY NOT NULL,
153	"name" varchar,
154	"user_id" varchar NOT NULL,
155	"guild_id" varchar NOT NULL,
156	"aliases" varchar[] DEFAULT '{}' NOT NULL,
157	"roles" varchar[] DEFAULT '{}' NOT NULL,
158	"channels" varchar[] DEFAULT '{}' NOT NULL,
159	"users" varchar[] DEFAULT '{}' NOT NULL,
160	"attachments" varchar[] DEFAULT ARRAY[]::varchar[] NOT NULL,
161	"content" varchar[] DEFAULT ARRAY[]::varchar[] NOT NULL,
162	"randomize" boolean DEFAULT false NOT NULL,
163	"permissions" varchar[] DEFAULT ARRAY[]::varchar[] NOT NULL,
164	"permission_mode" "permission_logic_mode" DEFAULT 'And' NOT NULL,
165	"level" integer,
166	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
167	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
168	);
169	--> statement-breakpoint
170	CREATE TABLE IF NOT EXISTS "users" (
171	"id" serial PRIMARY KEY NOT NULL,
172	"name" varchar,
173	"username" varchar NOT NULL,
174	"discord_id" varchar NOT NULL,
175	"github_id" varchar,
176	"guilds" varchar[] DEFAULT '{}' NOT NULL,
177	"password" varchar NOT NULL,
178	"token" varchar,
179	"recovery_token" varchar,
180	"recovery_code" varchar,
181	"recovery_attempts" integer DEFAULT 0 NOT NULL,
182	"recovery_token_expires_at" timestamp with time zone,
183	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
184	"token_expires_at" timestamp with time zone,
185	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
186	);
187	--> statement-breakpoint
188	CREATE TABLE IF NOT EXISTS "verification_entries" (
189	"id" serial PRIMARY KEY NOT NULL,
190	"user_id" varchar NOT NULL,
191	"guild_id" varchar NOT NULL,
192	"code" varchar NOT NULL,
193	"attempts" integer DEFAULT 0 NOT NULL,
194	"metadata" json DEFAULT '{}'::json NOT NULL,
195	"expires_at" timestamp with time zone NOT NULL,
196	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
197	"updated_at" timestamp with time zone DEFAULT now() NOT NULL,
198	CONSTRAINT "verification_entries_code_unique" UNIQUE("code")
199	);
200	--> statement-breakpoint
201	CREATE TABLE IF NOT EXISTS "verification_records" (
202	"id" serial PRIMARY KEY NOT NULL,
203	"guild_id" varchar NOT NULL,
204	"user_id" varchar NOT NULL,
205	"discord_id" varchar,
206	"github_id" varchar,
207	"google_id" varchar,
208	"email" varchar,
209	"method" "verification_method" NOT NULL,
210	"created_at" timestamp with time zone DEFAULT now() NOT NULL,
211	"updated_at" timestamp with time zone DEFAULT now() NOT NULL
212	);