[platal.git] / upgrade / newdirectory-0.0.1 / 03_emails.sql

CREATE TABLE IF NOT EXISTS profile_directory (
    uid INT NOT NULL,
    email_directory VARCHAR(255) DEFAULT NULL,
    PRIMARY KEY (uid)
) CHARSET=utf8;

ALTER TABLE register_marketing MODIFY COLUMN type ENUM('user', 'staff', 'ax');
Commit	Line	Data
424fb311 SJ	1	CREATE TABLE IF NOT EXISTS profile_directory (
	2	uid INT NOT NULL,
	3	email_directory VARCHAR(255) DEFAULT NULL,
	4	PRIMARY KEY (uid)
	5	) CHARSET=utf8;
	6
	7	ALTER TABLE register_marketing MODIFY COLUMN type ENUM('user', 'staff', 'ax');