ALTER TABLE `geo_projects` ADD `project_code` text DEFAULT '' NOT NULL;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `project_type` text DEFAULT 'client' NOT NULL;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `derivative_keywords_json` text DEFAULT '[]' NOT NULL;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `platforms_json` text DEFAULT '[]' NOT NULL;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `optimization_region` text DEFAULT '' NOT NULL;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `service_scope` text DEFAULT 'domestic' NOT NULL;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `acceptance_rules_json` text DEFAULT '{}' NOT NULL;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `deleted_at` text;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `deleted_by` text;--> statement-breakpoint
ALTER TABLE `geo_projects` ADD `delete_after` text;--> statement-breakpoint
CREATE INDEX `geo_projects_type_idx` ON `geo_projects` (`project_type`);