View file klub/tabl.sql

ALTER TABLE `user` ADD `bar` varchar(100) NOT NULL default '0';
ALTER TABLE `user` ADD `barnam` varchar(100) NOT NULL default '0';
ALTER TABLE `user` ADD `nark` varchar(100) NOT NULL default '0';
CREATE TABLE `barchat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ids` int(11) NOT NULL DEFAULT '0',
`time` int(11) NOT NULL,
`msg` varchar(1024) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;
CREATE TABLE `klubar` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`img` varchar(100) NOT NULL,
`naz` varchar(100) NOT NULL,
`urov` varchar(100) NOT NULL,
`stom` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;


CREATE TABLE `skb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nark` varchar(100) NOT NULL,
`strip` varchar(100) NOT NULL,
`urov` varchar(100) NOT NULL,
`inba` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `skb` VALUES("1","40","30","300","Екатерина") ;
CREATE TABLE `banbar` (
`id` int(11) NOT NULL DEFAULT '0',
`id_user` int(11) NOT NULL,
`id_ban` int(11) NOT NULL,
`prich` varchar(1024) NOT NULL,
`time` int(11) NOT NULL,
`view` set('1','0') NOT NULL DEFAULT '0',
`razdel` varchar(10) DEFAULT 'all',
`post` int(1) DEFAULT '0',
`pochemu` int(11) DEFAULT '0',
`navsegda` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;