github.com/drud/ddev@v1.21.5-alpha1.0.20230226034409-94fcc4b94453/pkg/ddevapp/testdata/TestDdevImportDB/mariadb/users_with_USE_statement.sql (about)

     1  -- MySQL dump 10.13  Distrib 5.5.54, for debian-linux-gnu (x86_64)
     2  --
     3  -- Host: db    Database: data
     4  -- ------------------------------------------------------
     5  -- Server version	5.7.17-log
     6  
     7  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
     8  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
     9  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    10  /*!40101 SET NAMES utf8 */;
    11  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    12  /*!40103 SET TIME_ZONE='+00:00' */;
    13  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    14  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    15  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    16  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    17  
    18  CREATE DATABASE /*!32312 IF NOT EXISTS*/ `db-should-not-be-created` /*!40100 DEFAULT CHARACTER SET utf8 */;
    19  
    20  USE `db-should-not-be-created`;
    21  --
    22  -- Table structure for table `users`
    23  --
    24  
    25  DROP TABLE IF EXISTS `users`;
    26  /*!40101 SET @saved_cs_client     = @@character_set_client */;
    27  /*!40101 SET character_set_client = utf8 */;
    28  CREATE TABLE `users` (
    29    `uid` int(10) unsigned NOT NULL,
    30    `uuid` varchar(128) CHARACTER SET ascii NOT NULL,
    31    `langcode` varchar(12) CHARACTER SET ascii NOT NULL,
    32    PRIMARY KEY (`uid`),
    33    UNIQUE KEY `user_field__uuid__value` (`uuid`)
    34  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for user entities.';
    35  /*!40101 SET character_set_client = @saved_cs_client */;
    36  
    37  --
    38  -- Dumping data for table `users`
    39  --
    40  
    41  LOCK TABLES `users` WRITE;
    42  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
    43  set autocommit=0;
    44  INSERT INTO `users` VALUES (0,'13751eca-19cf-41c2-90d4-9363f3a07c45','en'),(1,'186efa0a-8aa3-4eeb-90ce-6302fb9c4e07','en');
    45  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
    46  UNLOCK TABLES;
    47  commit;
    48  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    49  
    50  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    51  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    52  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    53  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    54  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    55  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    56  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    57  
    58  -- Dump completed on 2017-05-31 14:03:34