DROP DATABASE IF EXISTS `TestDb`;


/*******************************************************************************
   Create database
********************************************************************************/
CREATE DATABASE `TestDb`;


USE `TestDb`;


CREATE TABLE `ValuesTest`
(
    `ID` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `col_nvarchar` NVARCHAR(160),
    `col_int` INT(160),
    `col_numeric` NUMERIC(10,2),
    `col_bool` BOOLEAN,
    `col_bit` BIT
);

CREATE TABLE `ImageTest`
(
    `ID` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `col_image` LONGBLOB
);

INSERT INTO ValuesTest (col_nvarchar, col_int, col_numeric, col_bool, col_bit) VALUES ('value 0', 0, 0, 0, 0);
INSERT INTO ValuesTest (col_nvarchar, col_int, col_numeric, col_bool, col_bit) VALUES ('value 1', 1, 1, 1, 1);
INSERT INTO ValuesTest (col_nvarchar, col_int, col_numeric, col_bool, col_bit) VALUES ('value any', 1241, 14.56, 1, 1);

INSERT INTO ImageTest (col_image) VALUES (X'[encoded data, 20302 characters]')
