1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57
<?php
class GeschaeftskundenversandModuleCenterModule extends AbstractModuleCenterModule
{
protected function _init()
{
$this->title = $this->languageTextManager->get_text('geschaeftskundenversand_title');
$this->description = $this->languageTextManager->get_text('geschaeftskundenversand_description');
$this->sortOrder = 26963;
}
public function install()
{
$query = 'CREATE TABLE IF NOT EXISTS `gkv_shipments` (
`gkv_shipments_id` INT NOT NULL AUTO_INCREMENT ,
`orders_id` INT NOT NULL ,
`shipmentnumber` VARCHAR(39) NOT NULL ,
`labelurl` VARCHAR(300) NOT NULL ,
`returnlabelurl` VARCHAR(300) NOT NULL ,
`exportlabelurl` VARCHAR(300) NOT NULL ,
`codlabelurl` VARCHAR(300) NOT NULL ,
`last_modified` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
PRIMARY KEY (`gkv_shipments_id`),
INDEX `orders_id` (`orders_id`)
) ENGINE = MyISAM';
$db = StaticGXCoreLoader::getDatabaseQueryBuilder();
$db->query($query);
parent::install();
}
}