Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Database versioning #1

Open
vitkutny opened this issue Mar 20, 2015 · 0 comments
Open

Database versioning #1

vitkutny opened this issue Mar 20, 2015 · 0 comments
Assignees

Comments

@vitkutny
Copy link
Member

using validFrom and validTo columns on every table and globally make condition against locked DateTime('now') on every DB query, every row update should create a new row.... it should be possible to pass validFrom and validTo from application to allow creating future content... user with administrator role should be able to set DateTime('now') allowing "Time Machine" on website.... automatically delete invalid rows older than X days/weeks...

@vitkutny vitkutny self-assigned this Mar 20, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant