Init($curPath = "", $DBType, $updaterName = "", $curDir = "", "sale", "DB"); $updater->CopyFiles("install/admin", "admin"); if(!$updater->TableExists("b_sale_delivery_srv")) { $updater->Query(array( "MySQL" => "create table if not exists b_sale_delivery_srv ( ID int NOT NULL AUTO_INCREMENT, CODE varchar(50) NULL, PARENT_ID int NULL, NAME varchar(255) NOT NULL, ACTIVE char(1) NOT NULL, DESCRIPTION varchar(255) NULL, SORT int NOT NULL, LOGOTIP int NULL, CONFIG text NULL, CLASS_NAME varchar(255) NOT NULL, CURRENCY char(3) NOT NULL, primary key (ID), index IX_CODE(CODE) );" )); } if(!$updater->TableExists("b_sale_delivery_rstr")) { $updater->Query(array( "MySQL" => "create table if not exists b_sale_delivery_rstr ( ID int NOT NULL AUTO_INCREMENT, DELIVERY_ID int NOT NULL, SORT int DEFAULT 100, CLASS_NAME varchar(255) NOT NULL, PARAMS text, primary key (ID) );" )); } if(!$updater->TableExists("b_sale_delivery_es")) { $updater->Query(array( "MySQL" => "create table if not exists b_sale_delivery_es ( ID int NOT NULL AUTO_INCREMENT, CODE varchar(50) NULL, NAME varchar(255) NOT NULL, DESCRIPTION varchar(255) NULL, CLASS_NAME varchar(255) NOT NULL, PARAMS text NULL, RIGHTS char(3) NOT NULL, DELIVERY_ID int NOT NULL, INIT_VALUE varchar(255) NULL, ACTIVE char(1) NOT NULL, SORT int DEFAULT 100, primary key (ID), INDEX IX_DELIVERY_ID (DELIVERY_ID) );" )); } if (!$updater->TableExists("b_sale_order_delivery_es")) { $updater->Query(array( "MySQL" => "create table if not exists b_sale_order_delivery_es ( ID INT NOT NULL AUTO_INCREMENT, SHIPMENT_ID INT NOT NULL, EXTRA_SERVICE_ID INT NOT NULL, VALUE VARCHAR (255) NULL, PRIMARY KEY (ID) );" )); } if ($updater->TableExists("b_sale_delivery")) { if (!$DB->Query("SELECT CONVERTED FROM b_sale_delivery WHERE 1=0", true)) $updater->Query(array( "MySQL" => "ALTER TABLE b_sale_delivery ADD CONVERTED char(1) not null default 'N'", true) ); } if ($updater->TableExists("b_sale_delivery_handler")) { if (!$DB->Query("SELECT CONVERTED FROM b_sale_delivery_handler WHERE 1=0", true)) $updater->Query(array( "MySQL" => "ALTER TABLE b_sale_delivery_handler ADD CONVERTED char(1) not null default 'N'", true )); } if(IsModuleInstalled("sale")) { CAgent::AddAgent('\CSaleDelivery::convertToNewAgent(true);', "sale", "N"); CAgent::AddAgent('\CSaleDeliveryHandler::convertToNewAgent(true);', "sale", "N"); CAgent::AddAgent('\CSaleDelivery::convertPSRelationsAgent();', "sale", "N"); }