CREATE TABLE `favorites` (
	`id` text PRIMARY KEY NOT NULL,
	`owner` text NOT NULL,
	`request_id` text NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `favorites_owner_request` ON `favorites` (`owner`,`request_id`);--> statement-breakpoint
CREATE TABLE `ledger` (
	`id` text PRIMARY KEY NOT NULL,
	`owner` text NOT NULL,
	`amount` integer NOT NULL,
	`reason` text NOT NULL,
	`created` integer NOT NULL
);
--> statement-breakpoint
CREATE INDEX `ledger_owner` ON `ledger` (`owner`,`created`);--> statement-breakpoint
CREATE TABLE `messages` (
	`id` text PRIMARY KEY NOT NULL,
	`offer_id` text NOT NULL,
	`sender` text NOT NULL,
	`body` text NOT NULL,
	`created` integer NOT NULL
);
--> statement-breakpoint
CREATE INDEX `messages_offer` ON `messages` (`offer_id`,`created`);--> statement-breakpoint
CREATE TABLE `notifications` (
	`id` text PRIMARY KEY NOT NULL,
	`owner` text NOT NULL,
	`body` text NOT NULL,
	`created` integer NOT NULL
);
--> statement-breakpoint
CREATE INDEX `notifications_owner` ON `notifications` (`owner`,`created`);--> statement-breakpoint
CREATE TABLE `offers` (
	`id` text PRIMARY KEY NOT NULL,
	`request_id` text NOT NULL,
	`sender` text NOT NULL,
	`status` text DEFAULT 'pending' NOT NULL,
	`title` text NOT NULL,
	`payload` text,
	`promoted` integer DEFAULT 0 NOT NULL,
	`created` integer NOT NULL
);
--> statement-breakpoint
CREATE UNIQUE INDEX `offers_sender_request` ON `offers` (`request_id`,`sender`);--> statement-breakpoint
CREATE INDEX `offers_sender` ON `offers` (`sender`);--> statement-breakpoint
CREATE TABLE `profiles` (
	`id` text PRIMARY KEY NOT NULL,
	`name` text NOT NULL,
	`phone` text DEFAULT '' NOT NULL,
	`credits` integer DEFAULT 0 NOT NULL,
	`notify_app` integer DEFAULT 1 NOT NULL,
	`notify_email` integer DEFAULT 0 NOT NULL
);
--> statement-breakpoint
CREATE TABLE `requests` (
	`id` text PRIMARY KEY NOT NULL,
	`owner` text NOT NULL,
	`title` text NOT NULL,
	`type` text NOT NULL,
	`deal` text NOT NULL,
	`city` text NOT NULL,
	`county` text NOT NULL,
	`zone` text DEFAULT '' NOT NULL,
	`budget` integer NOT NULL,
	`area` integer NOT NULL,
	`rooms` integer,
	`floor` text,
	`description` text NOT NULL,
	`urgent` integer DEFAULT 0 NOT NULL,
	`promoted_until` integer DEFAULT 0 NOT NULL,
	`status` text DEFAULT 'active' NOT NULL,
	`created` integer NOT NULL,
	`expires` integer NOT NULL
);
--> statement-breakpoint
CREATE INDEX `requests_owner` ON `requests` (`owner`);--> statement-breakpoint
CREATE INDEX `requests_search` ON `requests` (`status`,`city`,`type`,`expires`);--> statement-breakpoint
CREATE TABLE `settings` (
	`key` text PRIMARY KEY NOT NULL,
	`value` integer NOT NULL
);