bundled/flask/examples/minitwit/schema.sql @ 16e0bcd4f854
Switch to the new hg spanset API This api was introduced in 3.2, and the indexation is not supported anymore (probably since 3.4) Patch provided by David Douard (see https://bitbucket.org/sjl/hg-review/pull-requests/8/better-handling-of-obsolescence-markers/diff#comment-8174971)
| author | Christophe de Vienne <christophe@cdevienne.info> |
|---|---|
| date | Fri, 19 Aug 2016 18:21:28 +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 );