From 5c2d27f75d2bacfc040b180e2d814df796929472 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期二, 25 一月 2022 16:23:29 +0800 Subject: [PATCH] 兼容mysql5低版本 --- sql/mysql.sql | 16 ++++++++-------- 1 files changed, 8 insertions(+), 8 deletions(-) diff --git a/sql/mysql.sql b/sql/mysql.sql index 36905c8..6569375 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -397,13 +397,13 @@ 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, @@ -414,13 +414,13 @@ /*!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; -- -- Gitblit v1.8.0