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

0 Members and 1 Guest are viewing this topic.

Offline
*
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.

Offline
*
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)
http://centos-webpanel.com/website-ddos-protection-proxy

Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp


Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor


Do you need Fast and FREE Support included for your CWP linux server?
http://centos-webpanel.com/noc-partner-list
Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services