- Posts: 14
- Thank you received: 0
Missing database normalization
- Olle Haerstedt
- Topic Author
- Offline
- New Member
-
Less
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
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.
- Tuan Pham Ngoc
- Offline
- Administrator
-
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
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
-
Less
More
- Posts: 14
- Thank you received: 0
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
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.
- John
- Offline
- New Member
-
Less
More
- Posts: 15
- Thank you received: 2
8 years 3 months ago #93438
by John
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
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.
Support
Documentation
Information
Copyright © 2025 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.