bundled/flask/examples/minitwit/schema.sql @ b443b42afe6f issue-90
Convert unicode to ascii for mercurial API. Mercurial API can't work with python's Unicode objects. Details http://mercurial.selenic.com/wiki/EncodingStrategy#Unicode_strings
| author | Alexander Stepanenko <olexander314@gmail.com> |
|---|---|
| date | Mon, 15 Dec 2014 02:06:13 +0300 |
| 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 );