settings table to be pivoted

Started by apmuthu, November 05, 2014, 05:57:34 PM

Previous topic - Next topic

apmuthu

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.

Administrator

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