data

Data

Mysql Database Connection Source

root:123456@tcp(127.0.0.1:3306)/kratos_shop?charset=utf8mb4&parseTime=True&loc=Local

创建数据库

mysql> CREATE DATABASE kratos_shop;
Query OK, 1 row affected (0.01 sec)

创建数据库后，启动程序 ent 会自动创建数据库表(太牛逼了)

mysql> CREATE DATABASE kratos_shop;
Query OK, 1 row affected (0.01 sec)

mysql> show tables;
+-----------------------+
| Tables_in_kratos_shop |
+-----------------------+
| addresses             |
| cards                 |
| users                 |
+-----------------------+
3 rows in set (0.00 sec)

mysql> desc users;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| id            | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| username      | varchar(191) | NO   | UNI | NULL    |                |
| password_hash | varchar(255) | NO   |     | NULL    |                |
| created_at    | datetime     | NO   |     | NULL    |                |
| updated_at    | datetime     | NO   |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+
5 rows in set (0.01 sec)

mysql> desc cards;
+------------+--------------+------+-----+---------+----------------+
| Field      | Type         | Null | Key | Default | Extra          |
+------------+--------------+------+-----+---------+----------------+
| id         | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| name       | varchar(255) | NO   |     | NULL    |                |
| card_no    | varchar(255) | NO   |     | NULL    |                |
| ccv        | varchar(255) | NO   |     | NULL    |                |
| expires    | varchar(255) | NO   |     | NULL    |                |
| created_at | datetime     | NO   |     | NULL    |                |
| updated_at | datetime     | NO   |     | NULL    |                |
| user_cards | bigint(20)   | YES  |     | NULL    |                |
+------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

mysql> desc addresses;
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | bigint(20)   | NO   | PRI | NULL    | auto_increment |
| name           | varchar(255) | NO   |     | NULL    |                |
| mobile         | varchar(255) | NO   |     | NULL    |                |
| address        | varchar(255) | NO   |     | NULL    |                |
| post_code      | varchar(255) | NO   |     | NULL    |                |
| created_at     | datetime     | NO   |     | NULL    |                |
| updated_at     | datetime     | NO   |     | NULL    |                |
| user_addresses | bigint(20)   | YES  |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)