2026-04-30
ALTER TABLE rfq_quotation_items CHANGE expected_date expected_date VARCHAR(50) NULL DEFAULT NULL;
ALTER TABLE rfq_quotation 
ADD COLUMN main_contact TINYINT(1) NOT NULL DEFAULT 0 AFTER order_notes;
ALTER TABLE rfq_quotation_history 
ADD COLUMN main_contact TINYINT(1) NOT NULL DEFAULT 0 AFTER order_notes;

2026-04-29
CREATE TABLE rfq_quotation_items (
    id INT NOT NULL AUTO_INCREMENT,
    rfq_id INT NOT NULL,
    item_code VARCHAR(100) NOT NULL,
    description TEXT,
    quantity INT NOT NULL DEFAULT 0,
    supplier_id INT NOT NULL DEFAULT 0,
    expected_date DATE NULL,
    created_by INT NOT NULL,
    created_on DATETIME NOT NULL,
    updated_by INT DEFAULT NULL,
    updated_on DATETIME DEFAULT NULL,
    PRIMARY KEY (id),
    KEY idx_rfq_id (rfq_id),
    KEY idx_item_code (item_code),
    KEY idx_supplier_id (supplier_id)
);

alter table rfq_quotation add column company_id int not null after order_id;
alter table rfq_quotation_history add column company_id int not null after order_id;
alter table rfq_quotation_history add column enquiry_id int not null after company_id;
alter table rfq_quotation add column enquiry_id int not null after company_id;
ALTER TABLE rfq_quotation_items CHANGE supplier_id supplier_id VARCHAR(25) NOT NULL DEFAULT '0';

2026-04-23
ALTER TABLE `comp_company_details` ADD clienttype VARCHAR(50) after eori_number;
ALTER TABLE `comp_company_details_history` ADD clienttype VARCHAR(50) after eori_number;


2026-04-22
CREATE TABLE enq_enquiry_clipping_cart (
    id INT AUTO_INCREMENT PRIMARY KEY,
    enquiry_code VARCHAR(500) NOT NULL,
    item_code VARCHAR(100) NOT NULL,
    description TEXT,
    item_type VARCHAR(100),
    quantity INT DEFAULT 0,
    note TEXT,
    same_item_flag ENUM('Yes','No') DEFAULT 'No',
    bidding ENUM('Yes','No') DEFAULT NULL,
    clipping_cart ENUM('Yes','No') DEFAULT NULL,
    created_on DATETIME DEFAULT CURRENT_TIMESTAMP,
    created_by VARCHAR(50),
    updated_on DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    updated_by VARCHAR(50),

    INDEX idx_item_code (item_code),
    INDEX idx_enquiry_code (enquiry_code)
);
CREATE TABLE enq_enquiry_clipping_cart_supplier (
    id INT AUTO_INCREMENT PRIMARY KEY,
    clipping_id INT NOT NULL,
    supplier_code VARCHAR(50) NOT NULL,
    created_on DATETIME DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_clip (clipping_id),
    INDEX idx_supplier (supplier_code)
);


2026-04-17
ALTER TABLE enq_enquiry_items CHANGE used_within_year client_under_year TINYINT(1) DEFAULT 0;

2026-04-16
alter table  `enq_enquiry_details` add column enquiry_code varchar(255) not null after company_id;
alter table  `enq_enquiry_details_history` add column enquiry_code varchar(255) not null after company_id;

2026-04-10
CREATE TABLE enq_enquiry_items (
    id INT AUTO_INCREMENT PRIMARY KEY,
    enquiry_id INT NOT NULL,
    item_code VARCHAR(100),
    description TEXT,
    item_type VARCHAR(50),
    quantity INT,
    note TEXT,
    created_on DATETIME,
    created_by INT,
    updated_on DATETIME,
    updated_by INT
);

alter table enq_enquiry_details_history add COLUMN office_number varchar(50) NOT NULL after phone_number;
alter table enq_enquiry_details add COLUMN office_number varchar(50) NOT NULL after phone_number;

2026-04-07
ALTER TABLE sit_contact_details CHANGE job_title job_title VARCHAR(50) NULL DEFAULT NULL;

2026-04-02
ALTER TABLE comp_company_details
MODIFY COLUMN account_type VARCHAR(50) DEFAULT NULL AFTER billing_country,
MODIFY COLUMN vat_rate VARCHAR(50) DEFAULT NULL AFTER account_type,
MODIFY COLUMN notes TEXT DEFAULT NULL AFTER vat_rate,
MODIFY COLUMN eori_number VARCHAR(100) DEFAULT NULL AFTER notes;

ALTER TABLE comp_company_details_history
MODIFY COLUMN account_type VARCHAR(50) DEFAULT NULL AFTER billing_country,
MODIFY COLUMN vat_rate VARCHAR(50) DEFAULT NULL AFTER account_type,
MODIFY COLUMN notes TEXT DEFAULT NULL AFTER vat_rate,
MODIFY COLUMN eori_number VARCHAR(100) DEFAULT NULL AFTER notes;

2026-04-01
ALTER TABLE comp_company_details_history
MODIFY COLUMN account_number VARCHAR(100) NULL AFTER his_id;

ALTER TABLE comp_company_details
MODIFY COLUMN account_number VARCHAR(100) NULL AFTER id;

ALTER TABLE comp_contact_details CHANGE job_title job_title VARCHAR(100) NOT NULL;
2026-03-30
ALTER TABLE sup_contact_details 
ADD contact_name VARCHAR(100) NOT NULL,
ADD contact_job_role VARCHAR(100) NULL,
ADD contact_mobile VARCHAR(20) NULL,
ADD contact_email VARCHAR(100) NOT NULL;

ALTER TABLE sup_supplier_details 
MODIFY supplier_code VARCHAR(50) NOT NULL 
AFTER id;

ALTER TABLE sup_supplier_details_history 
MODIFY supplier_code VARCHAR(50) NOT NULL 
AFTER his_id;

ALTER TABLE sup_supplier_details_history 
ADD supplier_code VARCHAR(50) NOT NULL;

ALTER TABLE sup_supplier_details 
ADD supplier_code VARCHAR(50) NOT NULL;

2026-03-27
ALTER TABLE comp_company_details
ADD COLUMN account_type VARCHAR(50) DEFAULT NULL,
ADD COLUMN vat_rate VARCHAR(50) DEFAULT NULL,
ADD COLUMN notes TEXT DEFAULT NULL,
ADD COLUMN eori_number VARCHAR(100) DEFAULT NULL;

ALTER TABLE comp_company_details_history
ADD COLUMN account_type VARCHAR(50) DEFAULT NULL,
ADD COLUMN vat_rate VARCHAR(50) DEFAULT NULL,
ADD COLUMN notes TEXT DEFAULT NULL,
ADD COLUMN eori_number VARCHAR(100) DEFAULT NULL;

ALTER TABLE comp_company_details
ADD COLUMN account_number VARCHAR(100) DEFAULT NULL;

ALTER TABLE comp_company_details_history
ADD COLUMN account_number VARCHAR(100) DEFAULT NULL;

2026-03-23

ALTER TABLE item_item_management 
ADD variety VARCHAR(255),
ADD note_description TEXT;

ALTER TABLE item_item_management_history 
ADD COLUMN variety VARCHAR(255),
ADD COLUMN note_description TEXT;

2026-03-24
ALTER TABLE item_item_management
ADD COLUMN sku_code VARCHAR(100) NULL AFTER product_sku,
ADD COLUMN hs_code VARCHAR(100) NULL AFTER sku_code,
ADD COLUMN country VARCHAR(100) NULL AFTER hs_code;

ALTER TABLE item_item_management_history
ADD COLUMN sku_code VARCHAR(100) NULL AFTER product_sku,
ADD COLUMN hs_code VARCHAR(100) NULL AFTER sku_code,
ADD COLUMN country VARCHAR(100) NULL AFTER hs_code;