CREATE TABLE `pos_api_keys` (
	`id` text PRIMARY KEY NOT NULL,
	`restaurant_id` text NOT NULL,
	`label` text NOT NULL,
	`key_hash` text NOT NULL,
	`created_at` text DEFAULT CURRENT_TIMESTAMP NOT NULL,
	`last_used_at` text,
	`is_active` integer DEFAULT 1 NOT NULL,
	FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE UNIQUE INDEX `pos_api_keys_key_hash_unique` ON `pos_api_keys` (`key_hash`);
--> statement-breakpoint
CREATE INDEX `idx_pos_api_keys_restaurant_active` ON `pos_api_keys` (`restaurant_id`,`is_active`);
--> statement-breakpoint
ALTER TABLE `restaurant_settings` ADD `pos_webhook_url` text;
--> statement-breakpoint
ALTER TABLE `restaurant_settings` ADD `pos_webhook_secret` text;
--> statement-breakpoint
ALTER TABLE `tickets` ADD `pos_synced_at` text;
--> statement-breakpoint
PRAGMA optimize;