-- Table structure for table `club_wise_theme`
--

CREATE TABLE `club_wise_theme` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` int(11) NOT NULL,
  `logo_url` text NOT NULL,
  `sidebar_color` varchar(64) NOT NULL,
  `navigation_color` varchar(64) NOT NULL,
  `icon_color` varchar(64) NOT NULL,
  `button_bgcolor` varchar(64) NOT NULL,
  `button_text` varchar(64) NOT NULL,
  `button_ic_color` varchar(64) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `logo_text` varchar(64) DEFAULT NULL,
  `logo_text_color` varchar(64) DEFAULT NULL,
  `create_button_bgcolor` varchar(255) DEFAULT NULL,
  `create_button_text` varchar(255) DEFAULT NULL,
  `create_button_ic_color` varchar(255) DEFAULT NULL,
  `cancel_button_bgcolor` varchar(255) DEFAULT NULL,
  `cancel_button_text` varchar(255) DEFAULT NULL,
  `cancel_button_ic_color` varchar(255) DEFAULT NULL,
  `is_image_converted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `club_wise_theme`
--

INSERT INTO `club_wise_theme` VALUES
(2,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2022/October/Images/logo.png','c40808','e8efc9','ecedb6','08577f','b6f9fb','a1f2f5',0,'LOGO Text','ebf3f3','null','null','null','null','null','null',1),
(3,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/January/Images/logo.png','9f2d2d','ad7d7d','8d2c2c','813d3d','b84444','ab2e2e',0,'Tineon','d44c4c','b31010','cc3737','a30202','ffffff','ffffff','ffffff',1),
(4,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/footer-logo2.png','1522be','efec4e','ecad13','155493','edd9d9','edb4b4',0,'VEREIN CLOUD','9dddd3','0a541d','ede5e5','f5ecec','930c0c','e7cccc','e0cbcb',1),
(5,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/logo-small.png','871414','ea9f9f','deb0b0','0a6874','c49393','b89d9d',0,'','c58686','0a6874','e2cfcf','e2d4d4','0a6874','eec8c8','eac9c9',1),
(6,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/February/Images/2830logo.png','f00000','fdf7f7','faf9f9','131d82','fafafa','fff6f6',0,'','f9f2f2','131d82','f0dbdb','ecd2d2','ff0564','f9f7f7','330000',1),
(7,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/Download.png','3d5a97','ffffff','ffffff','74bdea','ffffff','ffffff',0,'dWERK','3d5a97','74bdea','ffffff','ffffff','ef0d0d','ffffff','ffffff',1),
(8,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/logo_touchiv.png','97959a','ffffff','ffffff','4aa3e5','ffffff','ffffff',0,'','97959a','439642','ffffff','ffffff','d32d20','ffffff','ffffff',1),
(9,141,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Documents/1200px-DFB_Logo_2017.svg.png','202751','ffffff','ffffff','202751','ffffff','ffffff',1,'dwerk','ffffff','202751','ffffff','ffffff','ffffff','e74867','e74867',1),
(10,2830,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/March/Images/Logo%20Tineon.png','ffffff','5d5d5d','5d5d5d','02c300','ffffff','ffffff',1,'','','02c300','ffffff','ffffff','ff0000','ffffff','ffffff',1),
(11,2684,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/April/Documents/Bildschirmfoto%202023-04-24%20um%2018.06.58.png','3d5a97','ffffff','ffffff','74bdea','ffffff','ffffff',1,'dWERK ','ffffff','74bdea','ffffff','ffffff','2456ca','ffffff','ffffff',1),
(12,2830,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/May/Documents/1200px-DFB_Logo_2017.svg.png','4aa56e','ffffff','ffffff','4aa56e','ffffff','ffffff',0,'','4aa56e','4aa56e','ffffff','ffffff','4aa56e','ffffff','ffffff',1),
(13,2661,'https://minio.staging.verein.cloud/tineon/Leipzig/2023/June/Images/Neues%20Projekt.png','4aa56e','ffffff','ffffff','4aa56e','ffffff','ffffff',1,'','4aa56e','4aa56e','ffffff','ffffff','4aa56e','ffffff','ffffff',1);

--
-- Table structure for table `course_external_instructor`
--

CREATE TABLE `course_external_instructor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `instructor_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `course_external_instructor`
--

INSERT INTO `course_external_instructor` VALUES
(7,5,12),
(8,7,14),
(9,4,11),
(10,4,6),
(11,9,15),
(12,9,14),
(13,9,13),
(16,13,16),
(21,17,17),
(25,1,19),
(26,1,17),
(28,18,20),
(36,22,22),
(37,22,20),
(42,16,16),
(47,21,22),
(50,29,26);

--
-- Table structure for table `course_group`
--

CREATE TABLE `course_group` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `course_group`
--


--
-- Table structure for table `course_images`
--

CREATE TABLE `course_images` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) NOT NULL,
  `course_image` longtext NOT NULL,
  `course_document` longtext NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `course_images`
--

INSERT INTO `course_images` VALUES
(1,30,'[BLOB]','','2023-08-07 05:44:46',NULL),
(2,29,'[BLOB]','/tineon/Leipzig/2023/June/Documents/Test.txt','2023-08-07 05:44:46','2023-08-07 05:44:46'),
(3,28,'[BLOB]','','2023-08-07 05:44:47','2023-08-07 05:44:47'),
(4,25,'[BLOB]','','2023-08-07 05:44:47','2023-08-07 05:44:47'),
(5,24,'[BLOB]','','2023-08-07 05:44:47','2023-08-07 05:44:47'),
(6,23,'[BLOB]','','2023-08-07 05:44:47','2023-08-07 05:44:48'),
(7,22,'[BLOB]','','2023-08-07 05:44:48','2023-08-07 05:44:48'),
(8,21,'[BLOB]','','2023-08-07 05:45:44',NULL),
(9,18,'[BLOB]','','2023-08-07 05:45:45','2023-08-07 05:45:45'),
(10,17,'[BLOB]','','2023-08-07 05:45:45','2023-08-07 05:45:45'),
(11,16,'[BLOB]','','2023-08-07 05:45:45','2023-08-07 05:45:45'),
(12,14,'[BLOB]','','2023-08-07 05:45:45','2023-08-07 05:45:45'),
(13,13,'[BLOB]','','2023-08-07 05:45:45','2023-08-07 05:45:46'),
(14,10,'[BLOB]','','2023-08-07 05:45:46','2023-08-07 05:45:46'),
