Commit Graph

12 Commits

Author SHA1 Message Date
Andreas Zweili 5840e64d27 fix the id forwarding 2017-08-30 19:55:25 +02:00
Andreas Zweili 34a8472dfa separate the locations and rent_prices tables
This way it would be a bit easier to work with
and it would make more sense in the payment history.
2017-08-08 22:20:42 +02:00
Andreas Zweili d210e1522e create a sql script to create the rents view 2017-08-08 21:53:14 +02:00
Andreas Zweili b3a3a3b1f8 add a default member_status to new members
All new registered members get assigned the member status new_member.
2017-07-25 13:59:16 +02:00
Andreas Zweili 8a0e85ad8b add automatic dates to all the relevant attributes
This way we don't have to deal with the date format when creating a new entry.
2017-07-24 19:25:41 +02:00
Andreas Zweili c3fb4a6976 fix an insert person query 2017-07-22 15:13:01 +02:00
Andreas Zweili aecbcd4b3f add a country reference to the cities table 2017-07-20 23:03:25 +02:00
Andreas Zweili ede47123cd add changes after saving the sql studio 2017-07-09 20:00:24 +02:00
Andreas Zweili 7ba52b07ce add all the required constraints
in addition I've fixed some minor bugs.
2017-06-26 21:18:21 +02:00
Andreas Zweili c347e0d95f closed sql studio 2017-06-24 20:10:22 +02:00
Andreas Zweili cd3e9ff0d7 update after closing the project 2017-06-05 13:18:27 +02:00
Andreas Zweili 9171086de8 create project for the sql scripts 2017-06-05 13:11:26 +02:00