Hi,
Sorry for my english.
I want to implement the following structure to all of my models.
I have two db tables for every model a primary and a modifications ( for
logging)
Example:
CONTENT
id int(10) primary key (autincrement)
cre_date datetime
mod_date datetime
body longtext
status enum('A','D')
CONTENT_MOD
id int(10) key (not primary!, no autoincrementing!)
cre_date datetime
mod_date datetime
body longtext
status enum('A','D')
On every update I have a sql command:
insert to CONTENT_MOD select * from CONTENT where id=???
before the update, and I change the CONTENT.mod_date to NOW()
So I have all the backward modifications logged in the CONTENT_MOD table.
Then I can use "select * from CONTENT_MOD where id=??? " to get all the
versions of a record.
Where can I start? Should I have to overwrite the models.base class?
Thx.
laco
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
