Sample_MariaDB_DataTypes

CREATE TABLE IF NOT EXISTS `datatypes` (
  `mariadb_bigint` BIGINT(20) NULL,
  `mariadb_binary` BINARY(8) NULL,
  `mariadb_bit` bit(1) NULL,
  `mariadb_blob` BLOB NULL,
  `mariadb_boolean` tinyint(1) NULL,
  `mariadb_char` CHAR(5) CHARACTER SET utf8 NULL,
  `mariadb_date` DATE NULL,
  `mariadb_datetime` datetime NULL,
  `mariadb_decimal` DECIMAL(10,0) NULL,
  `mariadb_double` DOUBLE NULL,
  `mariadb_enum` enum('one','two','three') CHARACTER SET utf8 NULL,
  `mariadb_float` FLOAT NULL,
  `mariadb_geometry` geometry NULL,
  `mariadb_geometrycollection` geometrycollection NULL,
  `mariadb_int` INT(11) NULL,
  `mariadb_linestring` linestring NULL,
  `mariadb_longblob` longblob NULL,
  `mariadb_longtext` longtext CHARACTER SET utf8 NULL,
  `mariadb_mediumblob` mediumblob NULL,
  `mariadb_mediumint` mediumint(9) NULL,
  `mariadb_mediumtext` mediumtext CHARACTER SET utf8 NULL,
  `mariadb_multilinestring` multilinestring NULL,
  `mariadb_multipoint` multipoint NULL,
  `mariadb_multipolygon` multipolygon NULL,
  `mariadb_point` point NULL,
  `mariadb_polygon` polygon NULL,
  `mariadb_real` DOUBLE NULL,
  `mariadb_serial` BIGINT(20) UNSIGNED NULL,
  `mariadb_set` SET('red','green','blue') COLLATE utf8_unicode_ci NULL,
  `mariadb_smallint` SMALLINT(6) NULL,
  `mariadb_text` text CHARACTER SET utf8 NULL,
  `mariadb_time` TIME NULL,
  `mariadb_timestamp` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `mariadb_tinyblob` tinyblob NULL,
  `mariadb_tinyint` tinyint(4) NULL,
  `mariadb_tinytext` tinytext CHARACTER SET utf8 NULL,
  `mariadb_varbinary` varbinary(16) NULL,
  `mariadb_varchar` VARCHAR(5) CHARACTER SET utf8 NULL,
  `mariadb_year` YEAR(4) NULL,
  UNIQUE KEY `mariadb_serial` (`mariadb_serial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;