View file modul/tabl.sql

DROP TABLE IF EXISTS `vnm`;

CREATE TABLE `vnm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img` varchar(100) NOT NULL,
  `naz` varchar(150) NOT NULL,
  `ops` text NOT NULL,
  `kid` varchar(200) NOT NULL,
  `mid` int(200) NOT NULL,
  `ava` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `lap` int(11) NOT NULL DEFAULT '0',
  `top` int(11) NOT NULL DEFAULT '0',
  `left` int(11) NOT NULL DEFAULT '0',
  `roza` int(11) NOT NULL DEFAULT '0',
  `anom` int(11) NOT NULL,
  `prem` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS `vnm_komm`;

CREATE TABLE `vnm_komm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `msg` varchar(1024) NOT NULL,
  `time` int(11) NOT NULL,
  `id_vnm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `cenv_img`;
CREATE TABLE `cenv_img` (
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `cenv_pok`;
CREATE TABLE `cenv_pok` (
`id` int(11) NOT NULL DEFAULT '0',
`id_user` int(11) NOT NULL,
`id_zn` int(11) NOT NULL,
`time` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ;