SELECT TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`login` text NOT NULL,
`pass` text NOT NULL,
`mobile` text,
`email` text,
`icq` text,
`about` text,
`status` text,
`reg_data` text,
`money` int(11) NOT NULL default '0',
`level` int(4) NOT NULL default '0',
`police` int(3) NOT NULL default '0',
`health` int(4) NOT NULL default '0',
`band` text NOT NULL,
`last` text NOT NULL,
`cars` text NOT NULL,
`guns` text NOT NULL,
`nums` int(11) NOT NULL default '0',
`voodoo` int(1) NOT NULL default '0',
`golod` int(4) NOT NULL default '0',
`secur` int(3) NOT NULL default '0',
`city` int(3) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#ALTER TABLE `users` ADD `city` INT DEFAULT '0' NOT NULL ;#
#ALTER TABLE `users` ADD `secur` INT( 4 ) DEFAULT '0' NOT NULL ;#
########################################
CREATE TABLE `attack` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`who` text,
`msg` text,
`power` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
`what` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#########################################
CREATE TABLE `messagi` (
`id` int(11) NOT NULL auto_increment,
`kto` int(11) NOT NULL default '0',
`komu` int(11) NOT NULL default '0',
`msg` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#########################################
CREATE TABLE `bands` (
`id` int(11) NOT NULL auto_increment,
`name` text,
`boss` text,
`members` text,
`avtoritet` text,
`cars` text,
`guns` text,
`money` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
########################################
CREATE TABLE `refers` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`refer` text,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
######################################
CREATE TABLE `user_home` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`cars` text,
`guns` text,
`money` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
####################################
CREATE TABLE `fights` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`last` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
####################################
CREATE TABLE `krisha` (
`id` int(2) NOT NULL auto_increment,
`city` int(2) NOT NULL default '0',
`house` text NOT NULL,
`money` int(2) NOT NULL default '0',
`band` text NOT NULL,
`users` text NOT NULL,
`time` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
INSERT INTO krisha values ( 0, '1','bank','','','','');
INSERT INTO krisha values ( 0, '1','restaurant','','','','');
####################################
CREATE TABLE `kasino` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`combo` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#ALTER TABLE `kasino` ADD `dp` INT( 11 ) DEFAULT '0' NOT NULL;#
####################################
CREATE TABLE `forsage` (
`id` int(11) NOT NULL auto_increment,
`users` text NOT NULL,
`stage` int(2) NOT NULL default '1',
`win` text NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
#ALTER TABLE `forsage` ADD `time` INT( 11 ) NOT NULL ;#
####################################
CREATE TABLE `forsage_cars` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`gonka` int(11) NOT NULL default '0',
`car` text NOT NULL,
`mods` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
####################################
CREATE TABLE `sklad` (
`id` int(11) NOT NULL auto_increment,
`kto` int(11) NOT NULL default '0',
`komu` int(11) NOT NULL default '0',
`chto` text NOT NULL,
`type` int(2) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
####################################
CREATE TABLE `osobnyaki` (
`id` int(11) NOT NULL auto_increment,
`bandname` text NOT NULL,
`type` int(2) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;