Просмотр архива норм банк(бт)

DROP TABLE IF EXISTS `bank_statistic`;

CREATE TABLE `bank_statistic` (
 
`id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
 
`summa` int(11) NOT NULL,
  `type` enum('1','2') NOT NULL,
  `time` int(11)
NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT
CHARSET=utf8;




DROP TABLE IF EXISTS `bank_users`;

CREATE TABLE
`bank_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_user` int(11)
NOT NULL,
  `time` int(11) NOT NULL,
  `summa` int(11) NOT NULL,
 
`vozvrat` int(11) NOT NULL,
  `type` enum('1','2') NOT NULL,
  PRIMARY KEY
(`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8;




DROP
TABLE IF EXISTS `tj_admin`;

CREATE TABLE `tj_admin` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `silver_vznos` int(11) NOT NULL,
  `gold_vznos`
int(11) NOT NULL,
  `wins_gold` int(11) NOT NULL,
  `wins_silver` int(11)
NOT NULL,
  `top_silver` int(11) NOT NULL,
  `top_gold` int(11) NOT NULL,
 
`on/off` int(11) NOT NULL,
  `top` int(11) NOT NULL,
  `wins` int(11) NOT
NULL,
  `check_nagrada` enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY
(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO
tj_admin
VALUES("1","1000","250","2000","50000","500","500","1426087660","20","0","1");



DROP
TABLE IF EXISTS `tj_users`;

CREATE TABLE `tj_users` (
  `id` int(11) NOT
NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `wins` int(11) NOT
NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1124 DEFAULT
CHARSET=utf8;

INSERT INTO tj_users
VALUES("1123","1","0");