diff options
| author | Michael Merickel <michael@merickel.org> | 2016-02-12 02:42:04 -0600 |
|---|---|---|
| committer | Michael Merickel <michael@merickel.org> | 2016-02-12 02:42:04 -0600 |
| commit | a115c6d30fe8e497f67604370db4ffc8f2b124a9 (patch) | |
| tree | 9d49fba96848888bad4136c9531a98c491d49f61 /docs/tutorials/wiki2/design.rst | |
| parent | 574ba1aa6d81498220d123d149192eeba81afee7 (diff) | |
| download | pyramid-a115c6d30fe8e497f67604370db4ffc8f2b124a9.tar.gz pyramid-a115c6d30fe8e497f67604370db4ffc8f2b124a9.tar.bz2 pyramid-a115c6d30fe8e497f67604370db4ffc8f2b124a9.zip | |
add the bcrypt dependency
Diffstat (limited to 'docs/tutorials/wiki2/design.rst')
| -rw-r--r-- | docs/tutorials/wiki2/design.rst | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/docs/tutorials/wiki2/design.rst b/docs/tutorials/wiki2/design.rst index 42f06f7bf..de43447d3 100644 --- a/docs/tutorials/wiki2/design.rst +++ b/docs/tutorials/wiki2/design.rst @@ -21,12 +21,14 @@ We'll be using an SQLite database to hold our wiki data, and we'll be using Within the database, we will define two tables: -- The `users` table which will store the `name`, `password_hash` and `role`. +- The `users` table which will store the `id`, `name`, `password_hash` and + `role` of each wiki user. - The `pages` table, whose elements will store the wiki pages. - There are three columns: `name`, `data` and `creator_id`. + There are four columns: `id`, `name`, `data` and `creator_id`. There is a one-to-many relationship between `users` and `pages` tracking -the user who created each wiki page. +the user who created each wiki page defined by the `creator_id` column on the +`pages` table. URLs like ``/PageName`` will try to find an element in the `pages` table that has a corresponding name. |