View file SQL.sql

CREATE TABLE `blog` (
  `id` int(11) NOT NULL auto_increment,
  `who` int(11) NOT NULL default '0',
  `topic` varchar(60) NOT NULL default '',
  `text` blob NOT NULL,
  `bdata` varchar(14) default '0',
  `bread` int(10) default '0',
  `blog` int(11) default '0',
  `votes` int(5) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `who` (`who`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `blogvote` (
  `key` int(10) NOT NULL auto_increment,
  `id` int(10) NOT NULL default '0',
  `who` int(10) NOT NULL default '0',
  PRIMARY KEY  (`key`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `votes` (
  `id` int(2) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `avtor` varchar(20) NOT NULL default '',
  `date` varchar(10) NOT NULL default '',
  `vopros` varchar(200) default NULL,
  `v1` varchar(100) NOT NULL default '',
  `v2` varchar(100) NOT NULL default '',
  `v3` varchar(100) NOT NULL default '',
  `v4` varchar(100) NOT NULL default '',
  `v5` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `voting` (
  `klu4` int(3) NOT NULL auto_increment,
  `vote` int(2) NOT NULL default '0',
  `date` varchar(10) NOT NULL default '',
  `var` smallint(1) NOT NULL default '0',
  `who` int(5) NOT NULL default '0',
  PRIMARY KEY  (`klu4`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE `stihi` (
  `id` int(11) NOT NULL auto_increment,
  `login` text NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `autor` varchar(255) character set utf8 collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;

CREATE TABLE kurs (
  `id` int(11) NOT NULL auto_increment,
  `nik` int(11) NOT NULL default '0',
  `status` int(11) NOT NULL default '0',
  `objav` int(11) NOT NULL default '0',
  `topic` int(11) NOT NULL default '0',
  `obiav` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=cp1251;
INSERT INTO kurs VALUES (1, '20', '20', '20', '20', '20');

UPDATE `rooms` SET `rm` = '0' WHERE `rm` =25 LIMIT 1 ;

UPDATE `rooms` SET `rm` = '25' WHERE `rm` =31 LIMIT 1 ;

ALTER TABLE `rooms` ADD `vid` int(11) NOT NULL default 1;

ALTER TABLE `users` ADD `invite` int(10) NOT NULL default '0';

ALTER TABLE `users` ADD `blog` int(10) NOT NULL default '0';