1 ALTER TABLE profile_addresses CHANGE
COLUMN pub pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
2 ALTER TABLE profile_corps CHANGE
COLUMN corps_pub corps_pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
3 ALTER TABLE profile_job CHANGE
COLUMN pub pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
4 ALTER TABLE profile_job CHANGE
COLUMN email_pub email_pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
5 ALTER TABLE profile_networking CHANGE
COLUMN pub pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
6 ALTER TABLE profile_photos CHANGE
COLUMN pub pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
7 ALTER TABLE profile_phones CHANGE
COLUMN pub pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
8 ALTER TABLE profiles CHANGE
COLUMN freetext_pub freetext_pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
9 ALTER TABLE profiles CHANGE
COLUMN medals_pub medals_pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
10 ALTER TABLE profiles CHANGE
COLUMN alias_pub alias_pub
ENUM('hidden', 'private', 'ax', 'public') NOT NULL DEFAULT 'private';
12 DROP TABLE IF EXISTS profile_visibility_enum
;
13 CREATE TABLE profile_visibility_enum (
14 access_level
ENUM('admin', 'private', 'ax', 'public', 'none'),
15 best_display_level
ENUM('hidden', 'private', 'ax', 'public') NULL,
16 display_levels
SET('hidden', 'private', 'ax', 'public')
17 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
19 INSERT INTO profile_visibility_enum (access_level
, best_display_level
, display_levels
) VALUES
20 ('admin', 'hidden', 'hidden,private,ax,public'),
21 ('private', 'private', 'private,ax,public'),
22 ('ax', 'ax', 'ax,public'),
23 ('public', 'public', 'public'),