[Flask] Aggregate your news and vote for the content you care about.
1
SQLite format 3 @ .?
vOtablepostpostCREATE TABLE post (
2
id INTEGER NOT NULL,
3
title VARCHAR(100) NOT NULL,
4
date_posted DATETIME NOT NULL,
5
content TEXT NOT NULL,
6
user_id INTEGER NOT NULL,
7
PRIMARY KEY (id),
8
FOREIGN KEY(user_id) REFERENCES alias (id)
9
)atablealiasaliasCREATE TABLE alias (
10
id INTEGER NOT NULL,
11
username VARCHAR(20) NOT NULL,
12
email VARCHAR(120) NOT NULL,
13
image_file VARCHAR(20) NOT NULL,
14
password VARCHAR(60) NOT NULL,
15
PRIMARY KEY (id),
16
UNIQUE (username),
17
UNIQUE (email)
18
))= indexsqlite_autoindex_alias_2alias)= indexsqlite_autoindex_alias_1alias
19
20