--
-- Host: localhost    Database: NoteEZ
-- ------------------------------------------------------


--
-- Table structure for table `conference_subtitle`
--

CREATE TABLE `conference_subtitle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL,
  `conference_name` text DEFAULT NULL,
  `source_language` varchar(20) DEFAULT NULL,
  `target_language` varchar(20) DEFAULT NULL,
  `conference_content` text DEFAULT NULL,
  `subtitle_path` text DEFAULT NULL,
  `process_time` datetime DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `member_id` (`member_id`),
  CONSTRAINT `conference_subtitle_ibfk_1` FOREIGN KEY (`member_id`) REFERENCES `member` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `conference_subtitle`
--

INSERT INTO `conference_subtitle` VALUES (1,1,'2022-04-04 20:54:36 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 12:54:36'),(2,1,'2022-04-04 20:57:28 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 12:57:28'),(3,1,'2022-04-04 20:59:46 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 12:59:46'),(4,1,'2022-04-04 21:01:32 會議','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 13:01:32'),(5,1,'meeting room test!','cmn-Hant-TW',NULL,NULL,NULL,'2022-04-04 13:02:38');

--
-- Table structure for table `member`
--

CREATE TABLE `member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pwd` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_name` char(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` char(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lang` varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `head_shot` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan` int(11) DEFAULT 1,
  `expiry_date` datetime DEFAULT NULL,
  `limit_people` int(11) DEFAULT 4,
  `verification` int(11) DEFAULT 0,
  `status` int(11) DEFAULT 1,
  `auth_code` varchar(65) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nfcAuth` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `process_time` datetime DEFAULT current_timestamp(),
  `share_url` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `member`
--

INSERT INTO `member` VALUES (1,'zsystem.cloud@gmail.com','$2y$10$b5GIbrzyfeQQSNw5Oy57..E6P4XoX4tTWrcg4JLaOORPO3IlfHxje',NULL,'心統科技',NULL,NULL,NULL,1,NULL,4,0,1,NULL,NULL,'2022-03-24 07:17:38',NULL,'2022-03-24 07:17:38','2022-03-24 07:17:38'),(2,'wapiti2021@mailinator.com','$2y$10$CaFOluo412Hu312A.7vbHOB.xJxPtqme.93DXqFbNWbnnLVOnTWVa',NULL,'default',NULL,NULL,NULL,1,NULL,4,0,1,NULL,NULL,'2022-04-25 18:24:46',NULL,'2022-04-25 18:24:46','2022-04-25 18:24:46');


