Tharos

Entity generator input table

Apr 19th, 2011
329
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.69 KB | None | 0 0
  1. CREATE TABLE `test` (
  2.   `id` INT(10) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  3.   `string` VARCHAR(20) COLLATE utf8_czech_ci NOT NULL,
  4.   `string2` VARCHAR(255) COLLATE utf8_czech_ci DEFAULT NULL,
  5.   `string3` VARCHAR(50) COLLATE utf8_czech_ci NOT NULL DEFAULT 'hello',
  6.   `char` CHAR(3) COLLATE utf8_czech_ci DEFAULT NULL,
  7.   `int` SMALLINT(6) DEFAULT NULL,
  8.   `int2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '5',
  9.   `int3` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
  10.   `int4` BIGINT(20) NOT NULL,
  11.   `date` DATE NOT NULL DEFAULT '2011-04-18',
  12.   `datetime` datetime DEFAULT NULL,
  13.   `text` text COLLATE utf8_czech_ci NOT NULL,
  14.   PRIMARY KEY (`id`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
Advertisement
Add Comment
Please, Sign In to add comment