CREATE TABLE `course_products` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`creator_email` text NOT NULL,
	`title` text NOT NULL,
	`description` text NOT NULL,
	`category` text NOT NULL,
	`outcome` text NOT NULL,
	`project_title` text NOT NULL,
	`lesson_count` integer DEFAULT 6 NOT NULL,
	`price_pence` integer NOT NULL,
	`status` text DEFAULT 'published' NOT NULL,
	`created_at` text NOT NULL
);
--> statement-breakpoint
CREATE TABLE `enrolments` (
	`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
	`learner_email` text NOT NULL,
	`product_id` integer NOT NULL,
	`amount_pence` integer NOT NULL,
	`payment_status` text DEFAULT 'demo' NOT NULL,
	`progress` integer DEFAULT 0 NOT NULL,
	`enrolled_at` text NOT NULL
);
