bundled/flask/examples/minitwit/schema.sql @ d483f003d230

Change the mercurial minimum version

the obsstore api was added in mercurial 2.3.
I did _not_ tested with this version though, so we may have to
change it if issues are encountered.
author Christophe de Vienne <cdevienne@gmail.com>
date Fri, 21 Nov 2014 17:04:06 +0100
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
);