bundled/flask/docs/tutorial/schema.rst @ fc97fabaf28d
Update windows contrib script for current TortoiseHg version (2.6.2). TortoiseHg 2.6.2 is packaged with Python 2.7.3 (and not 2.6.x), and now includes some of the libraries that this script previously needed to copy into place.
| author | Chris Nielsen |
|---|---|
| date | Fri, 18 Jan 2013 11:51:36 -0500 |
| 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`.