Просмотр архива Удивительные питомцы

DROP TABLE IF EXISTS `chat`;

CREATE TABLE `chat` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text NOT NULL,
  `time` int(11) NOT NULL,
 
`id_user` int(11) NOT NULL,
  `support` int(11) DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;




DROP TABLE IF EXISTS
`contacts`;

CREATE TABLE `contacts` (
  `user` int(11) NOT NULL DEFAULT
'0',
  `ho` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT
'0'
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;




DROP TABLE IF EXISTS
`items`;

CREATE TABLE `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
 
`user_id` int(11) NOT NULL DEFAULT '0',
  `coin` int(11) NOT NULL DEFAULT
'0',
  `name` text,
  `img` text,
  `beauty` int(11) NOT NULL DEFAULT '0',

 `heart` int(11) NOT NULL DEFAULT '0',
  `time` int(11) NOT NULL DEFAULT
'0',
  `level` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM
DEFAULT CHARSET=cp1251;




DROP TABLE IF EXISTS `mail`;

CREATE TABLE
`mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from` int(11) NOT NULL
DEFAULT '0',
  `to` int(11) NOT NULL DEFAULT '0',
  `text` text,
  `time`
int(11) NOT NULL DEFAULT '0',
  `read` enum('0','1') NOT NULL DEFAULT '0',

 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;




DROP TABLE
IF EXISTS `news`;

CREATE TABLE `news` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `text` text,
  `time` int(11) NOT NULL DEFAULT '0',
 
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;




DROP TABLE
IF EXISTS `payments`;

CREATE TABLE `payments` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `time` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
 
`summa` int(11) DEFAULT '0',
  `status` int(11) DEFAULT '0',
  `number`
varchar(32) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `shop`;

CREATE TABLE `shop` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `coin` int(11) NOT NULL DEFAULT
'0',
  `level` int(11) NOT NULL DEFAULT '0',
  `name` text,
  `img` text,
 
`beauty` int(11) NOT NULL DEFAULT '0',
  `heart` int(11) NOT NULL DEFAULT
'0',
  `razdel` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3
DEFAULT CHARSET=cp1251;

INSERT INTO shop
VALUES("1","10","1","Вода","water.png","1","1","eda");
INSERT
INTO shop
VALUES("2","10","1","Минтай","fish.png","2","2","eda");



DROP
TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL
AUTO_INCREMENT,
  `login` varchar(100) DEFAULT NULL,
  `password`
varchar(100) DEFAULT NULL,
  `avatar` int(11) DEFAULT '0',
  `level`
int(11) DEFAULT '1',
  `exp` int(11) DEFAULT '0',
  `ban` int(11) DEFAULT
'0',
  `online` int(11) DEFAULT '0',
  `reg_time` int(11) DEFAULT '0',
 
`coin` int(11) DEFAULT '0',
  `beauty` int(11) DEFAULT '0',
  `heart`
int(11) DEFAULT '0',
  `bonus_time` int(11) DEFAULT '0',
  `access` int(11)
DEFAULT '0',
  `ip` text,
  `style` text,
  PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARSET=cp1251;