-- Boozen Transfer Script
-- be sure to backup + delete alternate user entries from accounts table before running

ALTER TABLE `users`
ADD `address` VARCHAR( 100 ) NOT NULL AFTER `reminder_a`, ADD `address2` VARCHAR( 100 ) NOT NULL AFTER `address`;
ADD `phone` VARCHAR( 20 ) NOT NULL AFTER `zipcde`, ADD `fax` VARCHAR( 20 ) NOT NULL AFTER `phone`;
ADD `type` ENUM( 'bar', 'band', 'deejay', 'personal' ) NULL ,
ADD `meta_name` VARCHAR( 255 ) NULL ,
ADD `logo` INT( 11 ) NULL ,
ADD `hours` VARCHAR( 100 ) NULL ,
ADD `coupon` TEXT NULL ;
ADD `whoworkfor` VARCHAR( 255 ) NULL ,
ADD `linkurl` VARCHAR( 255 ) NULL ;
ADD `p_type` ENUM( 'personal', 'promoter', 'bartender' ) NULL;
ADD `acct_placeholder` INT( 11 ) NOT NULL;

UPDATE users, account SET users.meta_name=account.name, users.acct_placeholder=account.type_id, users.type=account.type WHERE account.user_id = users.user_id;
UPDATE users, bar SET users.address=bar.address, users.address2=bar.address2, users.city=bar.city, users.state=bar.state, users.zipcde=bar.zip, users.phone=bar.phone, users.fax=bar.fax, users.hours=bar.hours, users.about=bar.about, users.coupon=bar.coupon, users.logo=bar.logo WHERE users.acct_placeholder = bar.bar_id AND users.type = 'bar';
UPDATE users, deejay SET users.city=deejay.city, users.state=deejay.state, users.zipcde=deejay.zip, users.phone=deejay.phone, users.about=deejay.about, users.logo=deejay.logo, users.email=deejay.email WHERE users.acct_placeholder = deejay.deejay_id AND users.type = 'deejay';
UPDATE users, band SET users.city=band.city, users.state=band.state, users.zipcde=band.zip, users.phone=band.phone, users.about=band.about, users.logo=band.logo, users.email=band.email WHERE users.acct_placeholder = band.band_id AND users.type = 'band';
UPDATE users, personal SET users.logo=personal.logo, users.whoworkfor=personal.whoworkfor, users.linkurl=personal.linkurl WHERE users.acct_placeholder = personal.personal_id AND users.type = 'personal';

ALTER TABLE `specials` ADD `user_id` INT( 11 ) NOT NULL;
UPDATE specials, users SET specials.user_id = users.user_id WHERE users.acct_placeholder = specials.type_id;
ALTER TABLE `specials` DROP `type_id`;

DROP TABLE `band`;
DROP TABLE `bar`;
DROP TABLE `personal`;
DROP TABLE `deejay`;
DROP TABLE `entity_comments`;