bundled/flask/examples/minitwit/schema.sql @ bdfacbcf700e default tip
Friendlier patch urls & mimetype Replace /changeset/<revset>/patch/ by /changeset/<revset>.patch and set the mimetype to text/x-diff. This helps the browser opening the right application thanks to the mimetype, and the application to better guess the file type thanks to the '.patch' extension
| author | Christophe de Vienne <christophe@cdevienne.info> |
|---|---|
| date | Fri, 19 Aug 2016 18:58:14 +0200 |
| parents | f33efe14bff1 |
| children | (none) |
drop table if exists user; create table user ( user_id integer primary key autoincrement, username string not null, email string not null, pw_hash string not null ); drop table if exists follower; create table follower ( who_id integer, whom_id integer ); drop table if exists message; create table message ( message_id integer primary key autoincrement, author_id integer not null, text string not null, pub_date integer );