<?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));
