PHPize Online / SQLize Online  /  SQLtest Online

CREATE TABLE `B0101`( `B01010010` CHAR(20) NOT NULL, `B01010020` VARCHAR(255) NOT NULL, `B01010030` CHAR(2) NOT NULL, `B01010040` VARCHAR(255) NOT NULL, `B01010050` VARCHAR(255) NOT NULL, `B01010060` DATE NOT NULL ); ALTER TABLE `B0101` ADD UNIQUE `b0101_b01010010_unique`(`B01010010`); CREATE TABLE `B0102`( `B01020010` CHAR(20) NOT NULL, `B01020020` VARCHAR(255) NOT NULL, `B01020030` CHAR(2) NOT NULL, `B01020040` VARCHAR(255) NOT NULL, `B01020050` VARCHAR(255) NOT NULL, `B01020060` CHAR(20) NULL, `B01020070` DATE NOT NULL, `B01020080` DATE NOT NULL, `B01020090` DATE NOT NULL, `B01020100` CHAR(3) NULL, `B01020110` INT NULL ); ALTER TABLE `B0102` ADD UNIQUE `b0102_b01020010_unique`(`B01020010`); CREATE TABLE `B0103`( `B01030010` VARCHAR(255) NOT NULL, `B01030020` CHAR(20) NOT NULL, `B01030030` VARCHAR(255) NOT NULL, `B01030040` CHAR(2) NOT NULL ); ALTER TABLE `B0103` ADD UNIQUE `b0103_b01030010_unique`(`B01030010`); ALTER TABLE `B0103` ADD UNIQUE `b0103_b01030020_unique`(`B01030020`); CREATE TABLE `B0201`( `B02010010` VARCHAR(255) NOT NULL, `B02010020` VARCHAR(255) NOT NULL, `B02010030` VARCHAR(255) NULL, `B02010040` INT NOT NULL, `B02010050` CHAR(3) NOT NULL ); ALTER TABLE `B0201` ADD UNIQUE `b0201_b02010010_unique`(`B02010010`); CREATE TABLE `B0202`( `B02020010` VARCHAR(255) NOT NULL, `B02020020` CHAR(20) NOT NULL, `B02020030` VARCHAR(255) NOT NULL, `B02020040` VARCHAR(255) NULL, `B02020050` VARCHAR(5) NOT NULL, `B02020060` VARCHAR(50) NOT NULL, `B02020070` DATE NOT NULL, `B02020080` DATE NOT NULL, `B02020090` VARCHAR(255) NULL, `B02020100` INT NULL, `B02020110` INT NULL, `B02020120` CHAR(2) NULL, `B02020130` CHAR(2) NOT NULL, `B02020140` BOOLEAN NOT NULL, `B02020150` CHAR(2) NOT NULL, `B02020160` CHAR(2) NOT NULL, `B02020170` VARCHAR(20) NULL, `B02020180` VARCHAR(20) NULL ); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020010_unique`(`B02020010`); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020020_unique`(`B02020020`); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020030_unique`(`B02020030`); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020050_unique`(`B02020050`); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020060_unique`(`B02020060`); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020130_unique`(`B02020130`); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020150_unique`(`B02020150`); ALTER TABLE `B0202` ADD UNIQUE `b0202_b02020160_unique`(`B02020160`); CREATE TABLE `B0203`( `B02030010` VARCHAR(255) NOT NULL, `B02030020` VARCHAR(255) NOT NULL ); ALTER TABLE `B0203` ADD UNIQUE `b0203_b02030010_unique`(`B02030010`); ALTER TABLE `B0203` ADD UNIQUE `b0203_b02030020_unique`(`B02030020`); CREATE TABLE `B0301`( `B03010010` VARCHAR(255) NOT NULL, `B03010020` CHAR(20) NOT NULL ); ALTER TABLE `B0301` ADD UNIQUE `b0301_b03010010_unique`(`B03010010`); ALTER TABLE `B0301` ADD UNIQUE `b0301_b03010020_unique`(`B03010020`); CREATE TABLE `B0302`( `B03020010` VARCHAR(255) NOT NULL, `B03020020` VARCHAR(255) NOT NULL, `B03020030` VARCHAR(255) NULL ); ALTER TABLE `B0302` ADD UNIQUE `b0302_b03020010_unique`(`B03020010`); ALTER TABLE `B0302` ADD UNIQUE `b0302_b03020020_unique`(`B03020020`); CREATE TABLE `B0303`( `B03030010` VARCHAR(255) NOT NULL, `B03030020` CHAR(20) NOT NULL ); ALTER TABLE `B0303` ADD UNIQUE `b0303_b03030010_unique`(`B03030010`); ALTER TABLE `B0303` ADD UNIQUE `b0303_b03030020_unique`(`B03030020`); CREATE TABLE `B0401`( `B04010010` VARCHAR(255) NOT NULL, `B04010020` CHAR(20) NOT NULL, `B04010030` BOOLEAN NOT NULL, `B04010040` VARCHAR(255) NOT NULL ); ALTER TABLE `B0401` ADD UNIQUE `b0401_b04010010_unique`(`B04010010`); ALTER TABLE `B0401` ADD UNIQUE `b0401_b04010020_unique`(`B04010020`); CREATE TABLE `B0501`( `B05010010` VARCHAR(255) NOT NULL, `B05010020` VARCHAR(255) NOT NULL, `B05010030` INT NULL, `B05010040` VARCHAR(255) NULL, `B05010050` VARCHAR(255) NOT NULL, `B05010060` VARCHAR(255) NULL, `B05010070` VARCHAR(50) NOT NULL, `B05010080` CHAR(2) NOT NULL, `B05010090` CHAR(30) NULL, `B05010100` INT NULL, `B05010110` VARCHAR(255) NOT NULL, `B05010120` VARCHAR(255) NULL ); ALTER TABLE `B0501` ADD UNIQUE `b0501_b05010010_unique`(`B05010010`); CREATE TABLE `B0502`( `B05020010` VARCHAR(255) NOT NULL, `B05020020` VARCHAR(50) NOT NULL, `B05020030` VARCHAR(255) NOT NULL, `B05020040` VARCHAR(255) NULL, `B05020050` INT NOT NULL, `B05020060` VARCHAR(255) NOT NULL, `B05020070` VARCHAR(255) NULL ); ALTER TABLE `B0502` ADD UNIQUE `b0502_b05020010_unique`(`B05020010`); ALTER TABLE `B0502` ADD UNIQUE `b0502_b05020020_unique`(`B05020020`); ALTER TABLE `B0502` ADD UNIQUE `b0502_b05020030_unique`(`B05020030`); ALTER TABLE `B0502` ADD UNIQUE `b0502_b05020050_unique`(`B05020050`); ALTER TABLE `B0502` ADD UNIQUE `b0502_b05020060_unique`(`B05020060`); CREATE TABLE `B0601`( `B06010010` VARCHAR(5) NOT NULL, `B06010020` VARCHAR(255) NOT NULL, `B06010030` VARCHAR(255) NOT NULL, `B06010040` CHAR(20) NOT NULL, `B06010050` VARCHAR(255) NOT NULL, `B06010060` VARCHAR(255) NOT NULL, `B06010070` DATE NOT NULL, `B06010080` INT NOT NULL, `B06010090` INT NOT NULL, `B06010100` VARCHAR(20) NOT NULL ); ALTER TABLE `B0601` ADD UNIQUE `b0601_b06010010_unique`(`B06010010`); ALTER TABLE `B0601` ADD UNIQUE `b0601_b06010040_unique`(`B06010040`); CREATE TABLE `B0701`( `B07010010` VARCHAR(255) NOT NULL, `B07010020` VARCHAR(255) NOT NULL, `B07010030` VARCHAR(255) NULL, `B07010040` VARCHAR(255) NOT NULL, `B07010050` VARCHAR(255) NOT NULL, `B07010060` VARCHAR(255) NULL, `B07010070` DATE NOT NULL, `B07010080` BOOLEAN NOT NULL, `B07010090` VARCHAR(255) NOT NULL, `B07010100` VARCHAR(255) NOT NULL, `B07010110` VARCHAR(255) NOT NULL, `B07010120` VARCHAR(255) NULL ); ALTER TABLE `B0701` ADD UNIQUE `b0701_b07010010_unique`(`B07010010`); ALTER TABLE `B0701` ADD UNIQUE `b0701_b07010020_unique`(`B07010020`); ALTER TABLE `B0701` ADD UNIQUE `b0701_b07010040_unique`(`B07010040`); CREATE TABLE `Type of ICT Services`( `Type of ICT services identifier` VARCHAR(50) NOT NULL, `Type of ICT services name` VARCHAR(50) NOT NULL, `Type of ICT services description` VARCHAR(255) NOT NULL ); ALTER TABLE `Type of ICT Services` ADD UNIQUE `type of ict services_type of ict services identifier_unique`( `Type of ICT services identifier` ); SELECT * FROM B0101;