Bad sql generated by create new/table copy

BubikolRamios's profile image BubikolRamios posted 9 years ago in General Permalink
CREATE TABLE test_table_foo (
`member_id` VARCHAR(15) NOT NULL DEFAULT ' ' COMMENT 'min 4 , max 15 characters length' COLLATE 'utf8_slovenian_ci',
`member_status` VARCHAR(45) NULL DEFAULT CURRENT_TIMESTAMP(45) COMMENT 'king,superuser, null itd' COLLATE 'utf8_slovenian_ci',
`pwd` VARCHAR(40) NULL DEFAULT NULL COMMENT 'encrypted ! sicer pa min 4 in max 15 char length' COLLATE 'utf8_general_ci',
`email` VARCHAR(80) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
`DSP` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ime_priimek` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_slovenian_ci',
`clanska_stevilka` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_slovenian_ci'
)
COLLATE 'utf8_slovenian_ci' ENGINE=MyISAM ROW_FORMAT=Dynamic;

Please login to leave a reply, or register at first.