CREATE TABLE `profiles` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`owner_id` text NOT NULL,
	`username` text NOT NULL,
	`profile_type` text DEFAULT 'personal' NOT NULL,
	`category` text DEFAULT 'Entrepreneur' NOT NULL,
	`payload` text DEFAULT '{}' NOT NULL,
	`created_at` text NOT NULL,
	`updated_at` text NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `idx_profiles_owner` ON `profiles` (`owner_id`);--> statement-breakpoint
CREATE UNIQUE INDEX `idx_profiles_username` ON `profiles` (`username`);--> statement-breakpoint
CREATE TABLE `submissions` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`owner_id` text NOT NULL,
	`kind` text NOT NULL,
	`payload` text NOT NULL,
	`status` text DEFAULT 'new' NOT NULL,
	`created_at` text NOT NULL
);
--> statement-breakpoint
CREATE INDEX `idx_submissions_owner_kind` ON `submissions` (`owner_id`,`kind`);