Christian Parpart wrote:
I've had some serous disk trouble and now, I'm
missing the user_rights table,
however, I'd simply create a new one, so, that every little user should just
recreate their accounts.
but how do I do?
could anyone gimme a short hint on what the schema of this table usually looks
like *AND* wether this would lead into other problems when I do it that way?
(I do not wanna loose the page contents)....
See maintenance/tables.sql for the schema. Create the table, then a
blank row for each user:
INSERT INTO user_rights (ur_user,ur_rights) SELECT user_id,'' FROM user;
You'd want to set up some account as a sysop, probably, putting
'sysop,bureaucrat' or such into its ur_rights field.
(Note that this table is no longer used in 1.5, as it's been replaced by
user_groups.)
-- brion vibber (brion @
pobox.com)