Author Topic: settings table to be pivoted  (Read 3686 times)

0 Members and 1 Guest are viewing this topic.

settings table to be pivoted
« on: November 05, 2014, 05:57:34 PM »
The settings table in root_cwp db has only 1 record having 1 field for each setting. As settings increase, these fields will soon increase. Best to have 3 fields - param_name, param_value, param_attribute where the last can be a json/serialised value. Then there can be several records - 1 for each param_name. hence we can have specific queries like "SELECT * FROM settings WHERE param_name='shared_ip';". Pivoting the table this way will make for other relationships later.

Re: settings table to be pivoted
« Reply #1 on: March 11, 2015, 05:19:33 PM »
all new settings are moved to static files, since using mysql isn't a stable option.
AntiDDoS Protection (web + mail)

Join our Development Team and get paid !

Services Monitoring & RBL Monitoring

Do you need Fast and FREE Support included for your CWP linux server?
Installation Instructions
Get Fast Support Here