store_company.sql

CREATE TABLE store (
    id INTEGER NOT NULL AUTO_INCREMENT,
    company_id INTEGER NOT NULL,
    created_at DATETIME NOT NULL,
    external_id INTEGER NOT NULL,
    invoice_method VARCHAR(255) NOT NULL,
    last_updated_at DATETIME NOT NULL,
    NAME VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE company (
    id INTEGER NOT NULL AUTO_INCREMENT,
    created_at DATETIME NOT NULL,
    last_updated_at DATETIME NOT NULL,
    NAME VARCHAR(190) NOT NULL,
    subdomain VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
);

CREATE TABLE store_setbox_invoice_method (
    id INTEGER NOT NULL AUTO_INCREMENT,
    created_at DATETIME NOT NULL,
    DIRECTORY VARCHAR(255) NOT NULL,
    domain VARCHAR(255),
    HOST VARCHAR(255) NOT NULL,
    last_updated_at DATETIME NOT NULL,
    PASSWORD VARCHAR(255),
    store_id INTEGER NOT NULL,
    username VARCHAR(255) NOT NULL,
    PRIMARY KEY (id)
);

ALTER TABLE `user` ADD COLUMN `company_id` INTEGER NOT NULL AFTER created_at;
ALTER TABLE `order` ADD COLUMN `store_id` INTEGER NOT NULL AFTER station_id;
ALTER TABLE `order_case` ADD COLUMN `store_id` INTEGER NOT NULL AFTER order_id;
ALTER TABLE `station` ADD COLUMN `store_id` INTEGER NOT NULL AFTER pool_priority;

ALTER TABLE `station` DROP INDEX `station_barcode_uk`;
ALTER TABLE `order_case` DROP INDEX `order_case_barcode_uk`;

ALTER TABLE company 
    ADD CONSTRAINT company_name_uk UNIQUE (NAME);

ALTER TABLE store 
    ADD CONSTRAINT store_company_id_external_id_uk UNIQUE (company_id, external_id);

CREATE INDEX station_store_id_index ON station (store_id);

ALTER TABLE store_setbox_invoice_method 
    ADD CONSTRAINT store_setbox_invoice_method_store_id_uk UNIQUE (store_id);

ALTER TABLE `user` 
    ADD CONSTRAINT user_external_id_company_id_uk UNIQUE (external_id, company_id);

CREATE INDEX order_case_store_id_index ON order_case (store_id);

INSERT INTO company (id, created_at, last_updated_at, NAME, subdomain) 
	VALUES (1, NOW(), NOW(), 'TAZEDIREKT', 'tazedirekt.com');

INSERT INTO `store` (id, company_id, created_at, external_id, invoice_method, last_updated_at, NAME)
	VALUES (1, 1, NOW(), 5219, 'SETBOX', NOW(), 'Tazedirekt Operasyon Merkezi');

INSERT INTO store_setbox_invoice_method (id, created_at, DIRECTORY, domain, HOST, last_updated_at, PASSWORD, store_id, username)
	VALUES (1, NOW(), '/ccc/Server/Box', 'MIGNET', '10.60.220.22', NOW(), 'OTOadmin*', 1, 'magazazincir');
	
UPDATE `order` SET store_id=1;
UPDATE `station` SET store_id=1;
UPDATE `order_case` SET store_id=1;
UPDATE `user` SET store_id=1;