<?php /* NOT FOR RELEASE! Add content to updater and module_updater */ include_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/classes/general/update_class.php"; global $DB, $DBType; $updater = new CUpdater(); $updater->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\n\t\t\t(\n\t\t\t\tID int NOT NULL AUTO_INCREMENT,\n\t\t\t\tCODE varchar(50) NULL,\n\t\t\t\tPARENT_ID int NULL,\n\t\t\t\tNAME varchar(255) NOT NULL,\n\t\t\t\tACTIVE char(1) NOT NULL,\n\t\t\t\tDESCRIPTION varchar(255) NULL,\n\t\t\t\tSORT int NOT NULL,\n\t\t\t\tLOGOTIP int NULL,\n\t\t\t\tCONFIG text NULL,\n\t\t\t\tCLASS_NAME varchar(255) NOT NULL,\n\t\t\t\tCURRENCY char(3) NOT NULL,\n\t\t\t\tprimary key (ID),\n\t\t\t\tindex IX_CODE(CODE)\n\t\t\t);")); } if (!$updater->TableExists("b_sale_delivery_rstr")) { $updater->Query(array("MySQL" => "create table if not exists b_sale_delivery_rstr\n\t\t\t(\n\t\t\t\tID int NOT NULL AUTO_INCREMENT,\n\t\t\t\tDELIVERY_ID int NOT NULL,\n\t\t\t\tSORT int DEFAULT 100,\n\t\t\t\tCLASS_NAME varchar(255) NOT NULL,\n\t\t\t\tPARAMS text,\n\t\t\t\tprimary key (ID)\n\t\t\t);")); } if (!$updater->TableExists("b_sale_delivery_es")) { $updater->Query(array("MySQL" => "create table if not exists b_sale_delivery_es\n\t\t\t(\n\t\t\t\tID int NOT NULL AUTO_INCREMENT,\n\t\t\t\tCODE varchar(50) NULL,\n\t\t\t\tNAME varchar(255) NOT NULL,\n\t\t\t\tDESCRIPTION varchar(255) NULL,\n\t\t\t\tCLASS_NAME varchar(255) NOT NULL,\n\t\t\t\tPARAMS text NULL,\n\t\t\t\tRIGHTS char(3) NOT NULL,\n\t\t\t\tDELIVERY_ID int NOT NULL,\n\t\t\t\tINIT_VALUE varchar(255) NULL,\n\t\t\t\tACTIVE char(1) NOT NULL,\n\t\t\t\tSORT int DEFAULT 100,\n\t\t\t\tprimary key (ID),\n\t\t\t\tINDEX IX_DELIVERY_ID (DELIVERY_ID)\n\n\t\t\t);")); } if (!$updater->TableExists("b_sale_order_delivery_es")) { $updater->Query(array("MySQL" => "create table if not exists b_sale_order_delivery_es\n\t\t\t(\n\t\t\t\tID INT NOT NULL AUTO_INCREMENT,\n\t\t\t\tSHIPMENT_ID INT NOT NULL,\n\t\t\t\tEXTRA_SERVICE_ID INT NOT NULL,\n\t\t\t\tVALUE VARCHAR (255) NULL,\n\t\t\t\tPRIMARY KEY (ID)\n\t\t\t);")); } 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));