... | ... | @@ -29,7 +29,7 @@ then add the user: `CREATE USER 'username''@'%' identified by 'password';` |
|
|
create the database: `CREATE DATABASE pyblog;`
|
|
|
create the tables:
|
|
|
```sql
|
|
|
CREATE TABLE IF NOT EXISTS pyblog_contents (
|
|
|
CREATE TABLE IF NOT EXISTS pyblog.pyblog_contents (
|
|
|
id INT NOT NULL AUTO_INCREMENT,
|
|
|
author VARCHAR(30) NOT NULL,
|
|
|
content VARCHAR(1000) NOT NULL,
|
... | ... | @@ -38,7 +38,7 @@ CREATE TABLE IF NOT EXISTS pyblog_contents ( |
|
|
```
|
|
|
and:
|
|
|
```sql
|
|
|
CREATE TABLE IF NOT EXISTS pyblog_users (
|
|
|
CREATE TABLE IF NOT EXISTS pyblog.pyblog_users (
|
|
|
uuid INT NOT NULL AUTO_INCREMENT,
|
|
|
name VARCHAR(30) NOT NULL,
|
|
|
bio VARCHAR(100) NOT NULL,
|
... | ... | |