Table structure
- You cannot open a new topic into this forum
- Guests cannot post into this forum
msg# 1
I checked the table structure behind piCal and here is a suggestion.
Instead of keeping all the events in one table you could use two. One for the event definition and another, much simpler, for the event occurence.
This could be very convenient for repeating events. Instead of having many copies of the same event you have only one row in the first table and then as many rows as needed in the second. This second table will basically have just dates. The relationship between the two tables would be one-to-many.
I can get into more details if you want...
Cheers,
Marius
Votes:4
Average:0.00
msg# 1.1
hi mariuss.
Your suggestion is quite correct.
But changing the structure of the tables will cause the necessary of radical restructuring of piCal class.
And some other modules (eg BopComments) depends on the table structrure of piCal.
If I have many free time, I know I have to restructure the piCal radically.
Votes:0
Average:0.00