Changes between Initial Version and Version 1 of TracDev/DatabaseSchema/WikiSystem

Timestamp:

Mar 11, 2012, 7:36:21 PM (12 years ago)

Author:

Peter Suter

Comment:

—

TracDev/DatabaseSchema/WikiSystem

@@ +1 @@
+[[PageOutline(2)]]
+
+= Trac Database Schema: Wiki System
+
+Trac's wiki system stores the pages (including old versions) in just a single database table.
+
+== Table `wiki`
+||'''Table'''||'''Key'''||
+||''wiki''||''name'', ''version''||
+
+||'''Columns'''||'''Type'''||
+||''name''|| ||
+||''version''||`int`||
+||''time''||`int64`||
+||''author''|| ||
+||''ipnr''|| ||
+||''text''|| ||
+||''comment''|| ||
+||''readonly''||`int`||
+
+||'''Indexes'''||
+||''time''||
+
+Stores the wiki pages (current and old versions).
+
+Use the `trac.wiki.model.WikiPage` model class instead of accessing this table directly.
+
+See [browser:trunk/trac/wiki/model.py trac.wiki.model.WikiPage], TracDev/DataModels#WikiPage