Missing database normalization

  • Olle Haerstedt
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 11 months ago #81712 by Olle Haerstedt
Missing database normalization was created by Olle Haerstedt
Hi,

How come you only use one table for subscribers and subscriptions (#__osmembership_subscribers)? This make it harder to extend the program to support multiple subscriptions. Any plans to refactor that part?

Regards
Olle

Please Log in or Create an account to join the conversation.

More
8 years 11 months ago #81745 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Missing database normalization
Hi Olle

I must be honest that it was my mistake when I designed the extension few years ago. I tried to split it into two tables in the part without success, so I will have to stay with my mistake for now (for at least 6 months more as right now, I want to focus working on improving the extensions, the structure still work well for me although I don't really like it) (it will still work well for me, it is just not easy for you to customize the extension, I think)

However, I am not sure what you are trying to do ? It could still doable with the current database structure(just not easy if we were having two tables in this case)

If you plan to make extensive customization to the extension and having problem with the better database structure, you might have to switch to a different extension before it is too late (of course, I will refund the money you paid)

Sorry for any inconvenience cause by my past mistake

Regards,

Tuan

Please Log in or Create an account to join the conversation.

  • Olle Haerstedt
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 11 months ago - 8 years 11 months ago #81761 by Olle Haerstedt
Replied by Olle Haerstedt on topic Missing database normalization
Hi,

Thanks for your answer!

The database design is not a big problem, it just raised my eyebrows.

We have quite specific requirements, where one subscriber should be able to have multiple subscriptions and also be able to upgrade any subscription. I was hoping this could be done without too much hassle, preferably using a plugin. I was thinking about using events to change the date of new subscriptions, making them run simultaneously. And customize the profile page, and so on. What do you think?

Regards
Olle
Last edit: 8 years 11 months ago by Olle Haerstedt.

Please Log in or Create an account to join the conversation.

More
8 years 3 months ago #93438 by John
Replied by John on topic Missing database normalization

Olle Haerstedt wrote:
We have quite specific requirements, where one subscriber should be able to have multiple subscriptions and also be able to upgrade any subscription.


Hi Olle. We have an identical requirement. I've been having a look at the tables and I can't see any practical way to do this. Did you have any success?

Hi Tuan, is this functionality likely to be added any time soon?

Thanks
John

Please Log in or Create an account to join the conversation.