###

    WRITE Command
     Use **  between two command to seprate the command.
    Command 1
    **
    Command 2

    Example:
    ADD_CLM|comp_datatable|ref_id|VARCHAR|20|1|NULL|tel_no
    **
    ADD_CLM|comp_datalist|data_item|INT|1|1|0|final_rate

###

    CHANGE/CREATE QUEUE WISE TABLE
    Use _##QU## after the table name to update in Queue Table.
    table_name_##QU##

    Example:
    If Change in both the table write command like below:
    ADD_CLM|comp_datalist|data_item|INT|1|1|0|final_rate
    **
    ADD_CLM|comp_datalist_##QU##|data_item|INT|1|1|0|final_rate
    To create both the table master and queue table (if avilable):
    CRT_TBL|comp_data|
    	`id` INT(11) NOT NULL AUTO_INCREMENT,
    	`name` VARCHAR(100) NULL DEFAULT NULL,
    	`behaviour` VARCHAR(50) NULL DEFAULT NULL,
    	`type` INT(11) NULL DEFAULT NULL,
    	PRIMARY KEY (`id`)
    **
    CRT_TBL|comp_abc_##QU##|
    	`id` INT(11) NOT NULL AUTO_INCREMENT,
    	`abc_name` VARCHAR(50) NULL DEFAULT NULL,
    	`puchase_id` INT(11) NULL DEFAULT NULL,
    	PRIMARY KEY (`id`),
    	INDEX `FK_##QU##_12` (`puchase_id`) USING BTREE,
    	CONSTRAINT `FK_##QU##_12` FOREIGN KEY (`puchase_id`) REFERENCES `comp_purchase_document_##QU##` (`id`) ON UPDATE NO ACTION ON DELETE RESTRICT

###

    CREATE TABLE
    Example:
    To create table (if avilable):
    CRT_TBL|table_name|
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(100) NULL DEFAULT NULL,
    `behaviour` VARCHAR(50) NULL DEFAULT NULL,
    `type` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
    **
    CRT_TBL|comp_abc_##QU##|
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `abc_name` VARCHAR(50) NULL DEFAULT NULL,
    `puchase_id` INT(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`)

###

    DROP Table
    DRP_TBL|table_name
    Example:
    DRP_TBL|comp_data
    DRP_TBL|comp_data_##QU##

###

    RENAME Table
    RNM_TBL|old_table_name|new_table_name
    Example:
    RNM_TBL|comp_data|comp_metadata
    RNM_TBL|comp_data_##QU##|comp_metadata_##QU##

###

    ADD Column
    ADD_CLM|table_name|column_name|type|constraint|allowNull(Y for NULL, N for NOT NULL)|default(If no default value use NULL)|after column_name
    Example:
    ADD_CLM|comp_datalist|data_item|INT|11|Y|0|final_rate
    ADD_CLM|comp_datalist_##QU##|data_item|INT|11|Y|0|final_rate

###

    DROP Column
    DRP_CLM|table_name|column_name
    Example:
    DRP_CLM|comp_data|md_date
    DRP_CLM|comp_data_##QU##|md_date

###

    ALTER TABLE
    ALT_TBL|table_name|old_column_name|new_column_name(If no change in name use old column name)|type|constraint|allowNull(Y for NULL, N for NOT NULL)|default(If no default value use NULL)|after
    Example:
    ALT_TBL|comp_item_master|data_item|data_item|INT|11|N|XYZ|bar_code
    ALT_TBL|comp_item_master_##QU##|data_item|data_val|INT|11|N|XYZ|bar_code

###

    CREATE PROCEDURE
    CRT_PRO|procedure_name|procedure_statement with parameters
    Example:
    CRT_PRO|comp_testpro|(IN id INT(11))
    BEGIN
    select * FROM comp_master;
    END

###

    CREATE FUNCTION
    CRT_FUN|function_name|function_statement with parameters
    Example:
    CRT_FUN|comp_testfun|
    ()
    RETURNS VARCHAR(20)
    DETERMINISTIC
    BEGIN
    DECLARE abc VARCHAR(20);
    SET abc ='222';
    RETURN(abc);
    END

###

    RUN QUERY
    QRY|query
    Example:
    QRY|insert into table (col1,col2) values (1,'AA')