EAV Proptery Datatypes

gistfile1.txt

INSERT INTO `property_datatypes` (`datatype_id`, `datatype_name`, `datatype_is_numeric`, `datatype_is_datetime`, `datatype_not_null`, `datatype_validation`) VALUES
(1, 'char', 0, 0, 0, NULL),
(2, 'varchar', 0, 0, 0, NULL),
(3, 'tinytext', 0, 0, 0, NULL),
(4, 'text', 0, 0, 0, NULL),
(5, 'mediumtext', 0, 0, 0, NULL),
(6, 'longtext', 0, 0, 0, NULL),
(7, 'blob', 0, 0, 0, NULL),
(8, 'mediumblob', 0, 0, 0, NULL),
(9, 'longblob', 0, 0, 0, NULL),
(10, 'tinyint', 1, 0, 0, NULL),
(11, 'smallint', 1, 0, 0, NULL),
(12, 'mediumint', 1, 0, 0, NULL),
(13, 'int', 1, 0, 0, NULL),
(14, 'bigint', 1, 0, 0, NULL),
(15, 'float', 1, 0, 0, NULL),
(16, 'double', 1, 0, 0, NULL),
(17, 'decimal', 1, 0, 0, NULL),
(18, 'time', 0, 0, 0, NULL),
(19, 'timestamp', 0, 0, 0, NULL),
(20, 'enum', 0, 0, 0, NULL);