... | ... | @@ -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 IF NOT EXISTS TABLE pyblog_contents (
|
|
|
CREATE TABLE IF NOT EXISTS pyblog_contents (
|
|
|
id INT NOT NULL AUTO_INCREMENT,
|
|
|
author VARCHAR(30) NOT NULL,
|
|
|
content VARCHAR(1000) NOT NULL,
|
... | ... | @@ -38,10 +38,11 @@ CREATE IF NOT EXISTS TABLE pyblog_contents ( |
|
|
```
|
|
|
and:
|
|
|
```sql
|
|
|
CREATE IF NOT EXISTS TABLE pyblog_users (
|
|
|
CREATE TABLE IF NOT EXISTS pyblog_users (
|
|
|
uuid INT NOT NULL AUTO_INCREMENT,
|
|
|
name VARCHAR(30) NOT NULL,
|
|
|
bio VARCHAR(100) NOT NULL,
|
|
|
title VARCHAR(20) NOT NULL,
|
|
|
PRIMARY KEY ( uuid )
|
|
|
);
|
|
|
```
|
... | ... | |