-- MIGRATION for existing single database (backup first)
ALTER TABLE users ADD COLUMN username VARCHAR(80) NULL UNIQUE AFTER id;
UPDATE users SET username=LOWER(REPLACE(SUBSTRING_INDEX(email,'@',1),' ','')) WHERE username IS NULL OR username='';
ALTER TABLE users MODIFY username VARCHAR(80) NOT NULL;
ALTER TABLE users ADD COLUMN google_id VARCHAR(100) NULL UNIQUE;
ALTER TABLE membership_plans ADD COLUMN max_invitations INT NULL AFTER duration_days;
ALTER TABLE invitations ADD COLUMN akad_date DATETIME NULL AFTER maps_url;
ALTER TABLE invitations ADD COLUMN akad_location TEXT NULL AFTER akad_date;
ALTER TABLE invitations ADD COLUMN akad_maps_url VARCHAR(255) NULL AFTER akad_location;
ALTER TABLE invitations ADD COLUMN resepsi_date DATETIME NULL AFTER akad_maps_url;
ALTER TABLE invitations ADD COLUMN resepsi_location TEXT NULL AFTER resepsi_date;
ALTER TABLE invitations ADD COLUMN resepsi_maps_url VARCHAR(255) NULL AFTER resepsi_location;
ALTER TABLE guest_links ADD COLUMN is_hidden TINYINT(1) NOT NULL DEFAULT 0 AFTER visit_count;

ALTER TABLE users ADD COLUMN verification_token VARCHAR(100) NULL;
ALTER TABLE users ADD COLUMN verified_at DATETIME NULL;