CREATE TABLE `evidence` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`owner_email` text NOT NULL,
	`title` text NOT NULL,
	`skill` text NOT NULL,
	`status` text DEFAULT 'growing' NOT NULL,
	`created_at` text NOT NULL
);
--> statement-breakpoint
CREATE TABLE `learner_state` (
	`email` text PRIMARY KEY NOT NULL,
	`display_name` text NOT NULL,
	`pathway` text DEFAULT 'Project management' NOT NULL,
	`project_started` integer DEFAULT false NOT NULL,
	`completed_lessons` integer DEFAULT 3 NOT NULL,
	`portfolio_published` integer DEFAULT false NOT NULL,
	`organisation_name` text DEFAULT 'ConnectPoint Learning' NOT NULL,
	`accent_colour` text DEFAULT '#08a9df' NOT NULL,
	`updated_at` text NOT NULL
);
