Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `test` (
- `id` INT(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
- `string` VARCHAR(20) COLLATE utf8_czech_ci NOT NULL,
- `string2` VARCHAR(255) COLLATE utf8_czech_ci DEFAULT NULL,
- `string3` VARCHAR(50) COLLATE utf8_czech_ci NOT NULL DEFAULT 'hello',
- `char` CHAR(3) COLLATE utf8_czech_ci DEFAULT NULL,
- `int` SMALLINT(6) DEFAULT NULL,
- `int2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '5',
- `int3` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
- `int4` BIGINT(20) NOT NULL,
- `date` DATE NOT NULL DEFAULT '2011-04-18',
- `datetime` datetime DEFAULT NULL,
- `text` text COLLATE utf8_czech_ci NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
Advertisement
Add Comment
Please, Sign In to add comment