bundled/flask/docs/tutorial/schema.rst @ 676834353b0d
Categorize only the last signoff of each user. On the index view, all the signoff of a single user (done on precursors of a cset) were displayed in the counts. This patch make sure only the last signoff of each user is counted, so that the final vote on the latest version of a cset gets displayed.
| author | Christophe de Vienne <cdevienne@gmail.com> |
|---|---|
| date | Wed, 29 Oct 2014 14:49:08 +0100 |
| parents | f33efe14bff1 |
| children | (none) |
.. _tutorial-schema: Step 1: Database Schema ======================= First we want to create the database schema. For this application only a single table is needed and we only want to support SQLite so that is quite easy. Just put the following contents into a file named `schema.sql` in the just created `flaskr` folder: .. sourcecode:: sql drop table if exists entries; create table entries ( id integer primary key autoincrement, title string not null, text string not null ); This schema consists of a single table called `entries` and each row in this table has an `id`, a `title` and a `text`. The `id` is an automatically incrementing integer and a primary key, the other two are strings that must not be null. Continue with :ref:`tutorial-setup`.