Developing.ru

Код: Выделить всё

CREATE TABLE IF NOT EXISTS `gallery` (
  `id` int(10) unsigned NOT NULL,
  `file_name` varchar(100) NOT NULL,
  `file_width_thumb` varchar(5) NOT NULL,
  `file_height_thumb` varchar(5) NOT NULL,
  `picture_theme` varchar(10) NOT NULL,
  `picture_name` varchar(30) NOT NULL,
  `picture_info` tinytext,
  `picture_describe` text,
  `picture_size` char(9) NOT NULL,
  `picture_year` year(4) NOT NULL,
  `picture_lyric` text,
  `picture_added` varchar(19) NOT NULL,
  `picture_modified` varchar(19) default NULL,
  `sort` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;