From: Chris N. <pu...@po...> - 2001-03-13 12:20:04
|
At 07:26 +0100 2001.03.13, Alvaro del Castillo wrote: >Chris Nandor wrote: >> >> Actually, users_param just uses a text field for "value" now. So the only >> issue would be picking a better limit for "name". > > >Ops, in 1.1.5 ... Yep, it was changed back to varchar, and then back to text. > >mysql> desc users_param; >+----------+--------------+------+-----+---------+----------------+ >| Field | Type | Null | Key | Default | Extra | >+----------+--------------+------+-----+---------+----------------+ >| param_id | int(11) | | PRI | 0 | auto_increment | >| uid | int(11) | | MUL | 1 | | >| name | varchar(32) | | | | | >| value | varchar(254) | | | | | >+----------+--------------+------+-----+---------+----------------+ > >If the value is a text field it is perfect :-) Yeah, however, as I noted as a possibility, and Brian echoed, I think it is best if users_acl is a separate table, just to keep it cleaner. Just take the users_param schema from CVS (or this one, changing value to a text field), and duplicate exactly for a users_acl table. -- Chris Nandor pu...@po... http://pudge.net/ Open Source Development Network pu...@os... http://osdn.com/ |