TRUNCATE TABLE billing;
TRUNCATE TABLE billing_info;
ALTER TABLE `billing` ADD `url_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'goes from veid' AFTER `user_id`;
ALTER TABLE `billing_info` ADD `url_id` INT UNSIGNED NOT NULL DEFAULT '0' COMMENT 'goes from veid' AFTER `trader_id`;
ALTER TABLE `billing_info` ADD INDEX(`url_id`);
ALTER TABLE `billing` ADD INDEX(`url_id`);
CREATE TABLE `espresso`.`shop_new_action_stat` ( `url_id` INT UNSIGNED NOT NULL DEFAULT '0' , `create_at` DATETIME NOT NULL , INDEX (`url_id`, `create_at`)) ENGINE = InnoDB;
INSERT INTO member_url SET url_id=50, member_id=1, url='http://zemoda.bg', title='Zemoda.BG', create_at='2014-11-01', is_active=1;
UPDATE member_veid SET url_id=50 WHERE veid='kjh8tguoSia820D';
