mysql创建数据库

:~$ mysql -uroot -p

Enter password: 

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.21-0ubuntu0.16.04.1 (Ubuntu)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases

    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

创建数据库

mysql> create database autotest

    -> ;
Query OK, 1 row affected (0.00 sec)

进入数据库

mysql> use autotest

Database changed

mysql> CREATE TABLE IF NOT EXISTS `project`(

    ->    `id` INT UNSIGNED AUTO_INCREMENT,
    ->    `project_name` VARCHAR(100) NOT NULL,
    ->    `project_code` VARCHAR(40) NOT NULL,
    ->    `enable` int DEFAULT 1,
    ->    `create_date` DATE NOT NULL,
    ->    `update_date` DATE NOT NULL,
    ->    PRIMARY KEY ( `id` )
    -> )ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.02 sec)


mysql> 
mysql> 
mysql> CREATE TABLE IF NOT EXISTS `test_module`(
    ->    `id` INT UNSIGNED AUTO_INCREMENT,
    ->    `module_name` VARCHAR(100) NOT NULL,
    ->    `parent_module_id` INT NULL,
    ->    `project_id` INT UNSIGNED NOT NULL,
    ->    `type` VARCHAR(50) NOT NULL,
    ->    `sequence` VARCHAR(18) NOT NULL,
    ->    `level` INT NOT NULL,
    ->    `enable` INT NOT NULL DEFAULT 1,
    ->    `create_date` DATE NOT NULL,
    ->    `update_date` DATE NOT NULL,
    ->    PRIMARY KEY ( `id` ),
    ->    FOREIGN KEY (project_id)
    ->         REFERENCES project(id)
    ->         ON DELETE CASCADE
    -> )ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.03 sec)


mysql> 
mysql> 
mysql> CREATE TABLE IF NOT EXISTS `test_case`(
    ->    `id` INT UNSIGNED AUTO_INCREMENT,
    ->    `test_case_id` VARCHAR(100) NOT NULL,
    ->    `test_module_id` INT UNSIGNED NULL,
    ->    `case_name` VARCHAR(300) NOT NULL,
    ->    `menu_module_value` VARCHAR(100) NOT NULL,
    ->    `menu_function_value` VARCHAR(100) NOT NULL,
    ->    `class_module_name` VARCHAR(100) NOT NULL,
    ->    `class_function_name` VARCHAR(100) NOT NULL DEFAULT 1,
    ->    `enable` INT NOT NULL DEFAULT 1,
    ->    `create_date` DATE NOT NULL,
    ->    `update_date` DATE NOT NULL,
    ->    PRIMARY KEY ( `id` ),
    ->    FOREIGN KEY (test_module_id)
    ->         REFERENCES test_module(id)
    ->         ON DELETE CASCADE
    -> )ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.03 sec)


mysql> 
mysql> CREATE TABLE IF NOT EXISTS `test_case_step`(
    ->    `id` INT UNSIGNED AUTO_INCREMENT,
    ->    `test_case_id` INT UNSIGNED NOT NULL,
    ->    `sub_step` INT UNSIGNED NULL,
    ->    `step_type` INT NOT NULL DEFAULT 1,
    ->    `step_id` VARCHAR(50) NOT NULL,
    ->    `seq` VARCHAR(20) NOT NULL,
    ->    `wait_element_located` VARCHAR(100) NOT NULL,
    ->    `element_xpth` VARCHAR(100) NOT NULL ,
    ->    `element_action` VARCHAR(100) NULL,
    ->    `clean` VARCHAR(100) NULL,
    ->    `element_value` VARCHAR(100) NULL,
    ->    `pause_sec` DATE NOT NULL,
    ->    `create_date` DATE NOT NULL,
    ->    `update_date` DATE NOT NULL,
    ->    PRIMARY KEY ( `id` ),
    ->    FOREIGN KEY (test_case_id)
    ->         REFERENCES test_case(id)
    ->         ON DELETE CASCADE
    -> )ENGINE=InnoDB DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.02 sec)


mysql> show tables
    -> ;
+--------------------+
| Tables_in_autotest |
+--------------------+
| project            |
| test_case          |
| test_case_step     |
| test_module        |
+--------------------+
4 rows in set (0.00 sec)


mysql> exit
Bye
barry_bai@szx4apln631598:~$ mvn -version
Apache Maven 3.3.9 (bb52d8502b132ec0a5a3f4c09453c07478323dc5; 2015-11-11T00:41:47+08:00)
Maven home: /home/barry_bai/JavaSoftwares/apache-maven-3.3.9
Java version: 1.8.0_121, vendor: Oracle Corporation
Java home: /home/barry_bai/JavaSoftwares/jdk1.8.0_121/jre
Default locale: zh_CN, platform encoding: UTF-8
OS name: "linux", version: "4.13.0-36-generic", arch: "amd64", family: "unix"
barry_bai@szx4apln631598:~$ ^C
barry_bai@szx4apln631598:~$