CREATE TABLE xmlrpc_auth (id INT AUTO_INCREMENT NOT NULL, client_name VARCHAR(50) NOT NULL, client_api_id VARCHAR(42) NOT NULL, password_hash VARCHAR(42) NOT NULL, auth_token VARCHAR(42) DEFAULT NULL, ip_address VARCHAR(40) DEFAULT NULL, callback_url VARCHAR(250) NOT NULL, trigger_sent_to_sales TINYINT(1) NOT NULL, created DATETIME NOT NULL, updated DATETIME DEFAULT NULL, archived TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE stock_valuation ADD xmlrpc_auth_id INT DEFAULT NULL;
ALTER TABLE stock_valuation ADD CONSTRAINT FK_B9F3F071C80B235E FOREIGN KEY (xmlrpc_auth_id) REFERENCES xmlrpc_auth (id);
CREATE INDEX IDX_B9F3F071C80B235E ON stock_valuation (xmlrpc_auth_id);
CREATE TABLE stock_images (id INT AUTO_INCREMENT NOT NULL, stock_id INT DEFAULT NULL, main_lib_photo_id INT DEFAULT NULL, front_lib_photo_id INT DEFAULT NULL, right_lib_photo_id INT DEFAULT NULL, left_lib_photo_id INT DEFAULT NULL, back_lib_photo_id INT DEFAULT NULL, interior_lib_photo_id INT DEFAULT NULL, engine_lib_photo_id INT DEFAULT NULL, natis_lib_photo_id INT DEFAULT NULL, main_url VARCHAR(255) DEFAULT NULL, front_url VARCHAR(255) DEFAULT NULL, right_url VARCHAR(255) DEFAULT NULL, left_url VARCHAR(255) DEFAULT NULL, back_url VARCHAR(255) DEFAULT NULL, interior_url VARCHAR(255) DEFAULT NULL, engine_url VARCHAR(255) DEFAULT NULL, natis_url VARCHAR(255) DEFAULT NULL, archived TINYINT(1) NOT NULL, INDEX IDX_2A396CFCDCD6110 (stock_id), INDEX IDX_2A396CFC7E933ED (main_lib_photo_id), INDEX IDX_2A396CFC9E7FCC26 (front_lib_photo_id), INDEX IDX_2A396CFC484681E2 (right_lib_photo_id), INDEX IDX_2A396CFCB4739143 (left_lib_photo_id), INDEX IDX_2A396CFC22C71343 (back_lib_photo_id), INDEX IDX_2A396CFC3E151757 (interior_lib_photo_id), INDEX IDX_2A396CFC2AE8B281 (engine_lib_photo_id), INDEX IDX_2A396CFC8FD5102A (natis_lib_photo_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE xmlrpc_callback_log (id INT AUTO_INCREMENT NOT NULL, xmlrpc_auth_id INT NOT NULL, stock_valuation_id INT DEFAULT NULL, callback_url VARCHAR(250) NOT NULL, method_name VARCHAR(50) NOT NULL, packet LONGTEXT DEFAULT NULL, response LONGTEXT DEFAULT NULL, status VARCHAR(50) NOT NULL, attempts INT NOT NULL, created DATETIME NOT NULL, INDEX IDX_5AA15D0AC80B235E (xmlrpc_auth_id), INDEX IDX_5AA15D0A37A85F5 (stock_valuation_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE xmlrpc_request_log (id INT AUTO_INCREMENT NOT NULL, xmlrpc_auth_id INT DEFAULT NULL, stock_valuation_id INT DEFAULT NULL, client_api_id VARCHAR(42) DEFAULT NULL, ip_address VARCHAR(40) DEFAULT NULL, method_name VARCHAR(50) NOT NULL, packet LONGTEXT DEFAULT NULL, status VARCHAR(250) NOT NULL, created DATETIME NOT NULL, INDEX IDX_D6EB6CAAC80B235E (xmlrpc_auth_id), INDEX IDX_D6EB6CAA37A85F5 (stock_valuation_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE xmlrpc_callback_log ADD CONSTRAINT FK_5AA15D0AC80B235E FOREIGN KEY (xmlrpc_auth_id) REFERENCES xmlrpc_auth (id);
ALTER TABLE xmlrpc_callback_log ADD CONSTRAINT FK_5AA15D0A37A85F5 FOREIGN KEY (stock_valuation_id) REFERENCES stock_valuation (id);
ALTER TABLE xmlrpc_request_log ADD CONSTRAINT FK_D6EB6CAAC80B235E FOREIGN KEY (xmlrpc_auth_id) REFERENCES xmlrpc_auth (id);
ALTER TABLE xmlrpc_request_log ADD CONSTRAINT FK_D6EB6CAA37A85F5 FOREIGN KEY (stock_valuation_id) REFERENCES stock_valuation (id);
ALTER TABLE stock_valuation ADD sales_force_item_id VARCHAR(50) DEFAULT NULL;