Thread:Project:Support desk/Errors 1170 and 1146/reply (7)

Here is my patch-account_credentials.sql page as it exists:

-- (c) Aaron Schulz, 2007

ALTER TABLE /*$wgDBprefix*/account_requests

-- ADD INDEX acr_type_del_reg (acr_type,acr_deleted,acr_registration);

-- This stores all of credential information -- When accounts are confirmed, the identity info goes here CREATE TABLE IF NOT EXISTS /*_*/account_credentials ( -- Revision ID #  acd_id int unsigned NOT NULL auto_increment PRIMARY KEY,  -- Foreign key to user.user_id  acd_user_id int unsigned NOT NULL,  -- Optional 'real name' to be displayed in credit listings  acd_real_name varchar(255) binary NOT NULL default ,  -- Note: email should be restricted, not public info.  -- Same with passwords.  acd_email tinytext NOT NULL,  -- Initially NULL; when a user's e-mail address has been  -- validated by returning with a mailed token, this is  -- set to the current timestamp.  acd_email_authenticated varbinary(14) default NULL,  -- A little about this user  acd_bio mediumblob NOT NULL,  -- Private info for reviewers to look at when considering request  acd_notes mediumblob NOT NULL,  -- Links to recognize/identify this user, CSV, may not be public  acd_urls mediumblob NOT NULL,  -- IP address  acd_ip VARCHAR(255) NULL default , -- Name of attached file (.pdf,.doc,.txt etc...) acd_filename VARCHAR(255) NULL, acd_storage_key VARCHAR(64) NULL, -- Areas of interest acd_areas mediumblob NOT NULL,

-- Timestamp of account registration. acd_registration varbinary(14) NOT NULL,

-- Timestamp of acceptance acd_accepted varbinary(14), -- The user who accepted it acd_user int unsigned NOT NULL default 0, -- Reason given in email acd_comment varchar(255) NOT NULL default '' ) /*$wgDBTableOptions*/;

CREATE UNIQUE INDEX /*i*/acd_user_id ON /*_*/account_credentials (acd_user_id,acd_id);