| | |
|---|
| | | UNLOCK TABLES; |
|---|
| | | |
|---|
| | | -- |
|---|
| | | -- Table structure for table `role` |
|---|
| | | -- Table structure for table `user_role` |
|---|
| | | -- |
|---|
| | | |
|---|
| | | DROP TABLE IF EXISTS `role`; |
|---|
| | | DROP TABLE IF EXISTS `user_role`; |
|---|
| | | /*!40101 SET @saved_cs_client = @@character_set_client */; |
|---|
| | | /*!50503 SET character_set_client = utf8mb4 */; |
|---|
| | | CREATE TABLE `role` ( |
|---|
| | | CREATE TABLE `user_role` ( |
|---|
| | | `id` int(11) NOT NULL AUTO_INCREMENT, |
|---|
| | | `name` varchar(50) NOT NULL, |
|---|
| | | `authority` varchar(50) NOT NULL, |
|---|
| | |
|---|
| | | /*!40101 SET character_set_client = @saved_cs_client */; |
|---|
| | | |
|---|
| | | -- |
|---|
| | | -- Dumping data for table `role` |
|---|
| | | -- Dumping data for table `user_role` |
|---|
| | | -- |
|---|
| | | |
|---|
| | | LOCK TABLES `role` WRITE; |
|---|
| | | /*!40000 ALTER TABLE `role` DISABLE KEYS */; |
|---|
| | | INSERT INTO `role` VALUES (1,'admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57'); |
|---|
| | | /*!40000 ALTER TABLE `role` ENABLE KEYS */; |
|---|
| | | LOCK TABLES `user_role` WRITE; |
|---|
| | | /*!40000 ALTER TABLE `user_role` DISABLE KEYS */; |
|---|
| | | INSERT INTO `user_role` VALUES (1,'admin','0','2021-04-13 14:14:57','2021-04-13 14:14:57'); |
|---|
| | | /*!40000 ALTER TABLE `user_role` ENABLE KEYS */; |
|---|
| | | UNLOCK TABLES; |
|---|
| | | |
|---|
| | | -- |
|---|
| | |
|---|
| | | `enable_hls` bit(1) DEFAULT NULL, |
|---|
| | | `enable_mp4` bit(1) DEFAULT NULL, |
|---|
| | | `enable` bit(1) NOT NULL, |
|---|
| | | `status` bit(1) NOT NULL, |
|---|
| | | `enable_remove_none_reader` bit(1) NOT NULL, |
|---|
| | | `createTime` varchar(50) NOT NULL, |
|---|
| | | PRIMARY KEY (`app`,`stream`) |
|---|
