Database Structure:
mnemosyne_pages:
The main wiki storage. Each entry in here is identified by a page title ( 'title' ) and a namespace ( 'namespace' ).
| FIELD | TYPE | DESCRIPTION |
| title | varchar 255 | stores the page title |
| namespace | varchar 100 | stores the page namespace |
| revision | Integer | version number, higher is more recent |
| editdate | datetime | The date/time this record was saved |
| article | blob | The article content |
| user | Integer (Foreign Key onto Django Users's Table | The user who saved this revision |
| pagelock | Boolean | a 'locked' flag – if this is set, then only admins can change the page |
mnemosyne_attachements:
Stores information about attachments, Again, all defined by namespace:title.
Should really use a FK onto Page here ( holy incorrect normalisation Simon!), but by tracking the namespace&title we're not tying the attachment into a specific version( i.e. revision ) of the page. This is a good thing.
| FIELD | TYPE | DESCRIPTION |
| title | varchar 255 | stores the page title |
| namespace | varchar 100 | stores the page namespace |
| filehash | varchar 32 | stores an md5 hash of the file – for corruption checks |
| filename | varchar 255 | filename |
| filesize | integer | filesize (in bytes ) |
| description | blob | description of file |
| contentype | varchar 64 | mime-type of the file |
| uploaddate | datetime | Date and Time of Upload |
Tags:
textile
textile
Statistics:
