Control Web Panel

WebPanel => Installation => Topic started by: apmuthu on November 05, 2014, 05:57:34 PM

Title: settings table to be pivoted
Post by: apmuthu 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.

Title: Re: settings table to be pivoted
Post by: Administrator on March 11, 2015, 05:19:33 PM

all new settings are moved to static files, since using mysql isn't a stable option.