CREATE TABLE `training_content` (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `owner_email` text NOT NULL,
  `title` text NOT NULL,
  `format` text NOT NULL,
  `launch_url` text,
  `package_key` text,
  `package_name` text,
  `status` text DEFAULT 'ready' NOT NULL,
  `created_at` text NOT NULL
);
--> statement-breakpoint
CREATE TABLE `content_launches` (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `content_id` integer NOT NULL,
  `learner_email` text NOT NULL,
  `completion_status` text DEFAULT 'launched' NOT NULL,
  `score` integer,
  `launched_at` text NOT NULL
);
--> statement-breakpoint
CREATE TABLE `survey_responses` (
  `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
  `learner_email` text NOT NULL,
  `course_title` text NOT NULL,
  `rating` integer NOT NULL,
  `confidence` integer NOT NULL,
  `comment` text DEFAULT '' NOT NULL,
  `created_at` text NOT NULL
);
