Facebook
From js, 2 Months ago, written in SQL.
Embed
Download Paste or View Raw
Hits: 74
  1. CREATE TABLE `online_courses` (
  2.   `id` INT(11) NOT NULL,
  3.   `title` VARCHAR(255) DEFAULT NULL,
  4.   `description` text DEFAULT NULL,
  5.   `teacher_id` INT(11) DEFAULT NULL,
  6.   `outcomes` text DEFAULT NULL,
  7.   `course_thumbnail` VARCHAR(100) DEFAULT NULL,
  8.   `course_provider` VARCHAR(100) DEFAULT NULL,
  9.   `course_url` VARCHAR(255) DEFAULT NULL,
  10.   `video_id` text DEFAULT NULL,
  11.   `price` FLOAT(10,2) NOT NULL DEFAULT 0.00,
  12.   `discount` FLOAT(10,2) NOT NULL DEFAULT 0.00,
  13.   `free_course` tinyint(1) DEFAULT NULL COMMENT '0=paid,1=free',
  14.   `view_count` INT(11) DEFAULT NULL,
  15.   `status` tinyint(1) DEFAULT 0,
  16.   `created_by` INT(11) DEFAULT NULL,
  17.   `created_date` datetime DEFAULT CURRENT_TIMESTAMP(),
  18.   `updated_date` datetime DEFAULT CURRENT_TIMESTAMP()
  19. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;