PEAK XOOPS - Table structure in englishin japanese

Table structure

  • You cannot open a new topic into this forum
  • Guests cannot post into this forum
Previous post - Next post | Parent - Children.1 | Posted on 2004/2/23 11:14
mariuss  ¸àĹ   Posts: 44
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
Previous post - Next post | Parent - No child | Posted on 2004/2/25 5:52
GIJOE  ÀèǤ·³Áâ   Posts: 4110
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

  Advanced search


Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!