hi,
i'm created a 'configuration' table:
create cofiguration (
config_key VARCHAR(25) NOT NULL PRIMARY KEY,
config_value VARCHAR(255) NOT NULL
) ENGINE=MyISAM;
I have about 30 records (store_name, store_owner, template_name,
website_width, owner_address, prodcuts_per_page,..).
now i wonder is maybe better solution to have a table with 30 columns and
one record:
create configuration (
store_owner VARCHAR(50) NOT NULL,
template VARCHAR(25) NOT NULL,
store_with INTEGER(4) NOT NULL,
thumb_width int(3) NOT NULL,
big_width int(4) NOT NULL,
products_per_page INT(2) NOT NULL,
stock ENUM('1','0'),
etc.
) ENGINE=MyISAM;
thanks for any though.
-afan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
