Re: [Fofredux-devel] config table

[Kevin <ke...@dr...>]

Katie Bechtold wrote:
> On Sat, Jan 28, 2006 at 10:54:37AM -0700, Kevin wrote:
>   
>> What about something that just stores key -> value pairs?
>>     
>
> I like your design better than the current one.  Do you want to go
> ahead and implement that (and have Andrew re-assign that Feature
> Request)?
>
>   
It will have to wait until after tags is complete.

The table is fairly simple.  Just 2 columns,  name & value.

create table $FOF_CONFIG_TABLE (
name varchar(250) NOT NULL,
value varchar(250) NOT NULL
PRIMARY KEY(name) )

Then just 2 functions are needed for retrieving and adding/updating values.

fof_get_config_value( $name );
fof_set_config_value( $name, $value );

This doesn't put any restrictions on names or values.  Some standards 
should be adopted for acceptable names and values.

-Kevin