Файл: durak/table_durak.sql
Строк: 39
DROP TABLE IF EXISTS `durak`;
CREATE TABLE `durak` (
`id` int(11) NOT
NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`id_prot` int(11)
NOT NULL,
`stav` int(11) DEFAULT '0',
`hod` int(11) DEFAULT '0',
`kozar` int(11) DEFAULT '0',
`karta` varchar(3) DEFAULT NULL,
`read`
int(3) DEFAULT '0',
`over_hod` int(11) DEFAULT NULL,
`game_over`
int(1) DEFAULT NULL,
`status` int(1) DEFAULT '0',
`koloda`
varchar(20) DEFAULT 'default',
`chat` int(20) DEFAULT '0',
`level`
int(11) DEFAULT '0',
`bit` int(11) DEFAULT '0',
`hodit` int(11)
DEFAULT '0',
`time` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
INSERT INTO durak
VALUES("4","41","60","0","41","4","7k","0","","60","4","default","1","0","41","60","1374153704");
DROP
TABLE IF EXISTS `durak_chat`;
CREATE TABLE `durak_chat` (
`id`
int(11) NOT NULL AUTO_INCREMENT,
`id_user` int(11) NOT NULL,
`msg`
varchar(512) DEFAULT NULL,
`id_game` int(11) DEFAULT '0',
`time`
int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;
DROP TABLE IF EXISTS `durak_game`;
CREATE TABLE
`durak_game` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_user`
int(11) NOT NULL,
`karta` varchar(11) DEFAULT '0',
`sila` int(11)
DEFAULT '0',
`mast` int(11) DEFAULT '0',
`on` int(1) DEFAULT '0',
`time` int(12) DEFAULT NULL,
`id_game` int(11) DEFAULT '0',
PRIMARY
KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT
CHARSET=utf8;
INSERT INTO durak_game
VALUES("1","41","Dp","7","3","0","1374153695","4");
INSERT
INTO durak_game
VALUES("2","41","10p","5","3","0","1374153696","4");
INSERT
INTO durak_game
VALUES("3","41","Vb","6","4","0","1374153697","4");
INSERT
INTO durak_game
VALUES("4","41","6k","1","1","0","1374153698","4");
INSERT
INTO durak_game
VALUES("5","41","Tp","9","3","0","1374153699","4");
INSERT
INTO durak_game
VALUES("6","41","Vc","6","2","0","1374153700","4");
INSERT
INTO durak_game
VALUES("7","60","10c","5","2","0","1374153701","4");
INSERT
INTO durak_game
VALUES("8","60","7k","2","1","1","1374153704","4");
INSERT
INTO durak_game
VALUES("9","60","10b","5","4","0","1374153703","4");
INSERT
INTO durak_game
VALUES("10","60","7b","2","4","0","1374153704","4");
INSERT
INTO durak_game
VALUES("11","60","9b","4","4","0","1374153705","4");
INSERT
INTO durak_game
VALUES("12","60","Db","7","4","0","1374153706","4");
INSERT
INTO durak_game
VALUES("13","0","Tc","9","2","0","1374153707","4");
INSERT
INTO durak_game
VALUES("14","0","Vp","6","3","0","1374153708","4");
INSERT
INTO durak_game
VALUES("15","0","8k","3","1","0","1374153709","4");
INSERT
INTO durak_game
VALUES("16","0","9c","4","2","0","1374153710","4");
INSERT
INTO durak_game
VALUES("17","0","8p","3","3","0","1374153711","4");
INSERT
INTO durak_game
VALUES("18","0","Kp","8","3","0","1374153712","4");
INSERT
INTO durak_game
VALUES("19","0","Dk","7","1","0","1374153713","4");
INSERT
INTO durak_game
VALUES("20","0","6c","1","2","0","1374153714","4");
INSERT
INTO durak_game
VALUES("21","0","9k","4","1","0","1374153715","4");
INSERT
INTO durak_game
VALUES("22","0","Kc","8","2","0","1374153716","4");
INSERT
INTO durak_game
VALUES("23","0","Vk","6","1","0","1374153717","4");
INSERT
INTO durak_game
VALUES("24","0","Kk","8","1","0","1374153718","4");
INSERT
INTO durak_game
VALUES("25","0","Dc","7","2","0","1374153719","4");
INSERT
INTO durak_game
VALUES("26","0","10k","5","1","0","1374153720","4");
INSERT
INTO durak_game
VALUES("27","0","Tb","9","4","0","1374153721","4");
INSERT
INTO durak_game
VALUES("28","0","7p","2","3","0","1374153722","4");
INSERT
INTO durak_game
VALUES("29","0","9p","4","3","0","1374153723","4");
INSERT
INTO durak_game
VALUES("30","0","Kb","8","4","0","1374153724","4");
INSERT
INTO durak_game
VALUES("31","0","8c","3","2","0","1374153725","4");
INSERT
INTO durak_game
VALUES("32","0","Tk","9","1","0","1374153726","4");
INSERT
INTO durak_game
VALUES("33","0","6b","1","4","0","1374153727","4");
INSERT
INTO durak_game
VALUES("34","0","7c","2","2","0","1374153728","4");
INSERT
INTO durak_game
VALUES("35","0","6p","1","3","0","1374153729","4");
INSERT
INTO durak_game
VALUES("36","0","8b","3","4","0","1374153730","4");
DROP
TABLE IF EXISTS `durak_hod`;
CREATE TABLE `durak_hod` (
`name`
varchar(4) DEFAULT NULL,
`num` int(11) DEFAULT '0',
`id_game` int(11)
DEFAULT '0',
`kozar` int(1) DEFAULT '0',
`sila` int(3) DEFAULT '0',
`id_user` int(3) DEFAULT '0',
`mast` int(3) DEFAULT '0'
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO durak_hod
VALUES("7k","1374153704","4","0","2","60","0");
DROP
TABLE IF EXISTS `durak_karty`;
CREATE TABLE `durak_karty` (
`name`
varchar(4) DEFAULT NULL,
`sila` int(3) DEFAULT '0',
`mast` int(3)
DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO
durak_karty VALUES("Tp","9","3");
INSERT
INTO durak_karty
VALUES("Kb","8","4");
INSERT INTO
durak_karty VALUES("9b","4","4");
INSERT
INTO durak_karty
VALUES("6b","1","4");
INSERT INTO
durak_karty VALUES("Tb","9","4");
INSERT
INTO durak_karty
VALUES("10b","5","4");
INSERT INTO
durak_karty VALUES("Kp","8","3");
INSERT
INTO durak_karty
VALUES("Db","7","4");
INSERT INTO
durak_karty VALUES("8b","3","4");
INSERT
INTO durak_karty
VALUES("7b","2","4");
INSERT INTO
durak_karty VALUES("Vb","6","4");
INSERT
INTO durak_karty
VALUES("Dp","7","3");
INSERT INTO
durak_karty VALUES("9p","4","3");
INSERT
INTO durak_karty
VALUES("Tc","9","2");
INSERT INTO
durak_karty VALUES("10c","5","2");
INSERT
INTO durak_karty
VALUES("7k","2","1");
INSERT INTO
durak_karty VALUES("6c","1","2");
INSERT
INTO durak_karty
VALUES("Vk","6","1");
INSERT INTO
durak_karty VALUES("10p","5","3");
INSERT
INTO durak_karty
VALUES("6p","1","3");
INSERT INTO
durak_karty VALUES("Vc","6","2");
INSERT
INTO durak_karty
VALUES("8k","3","1");
INSERT INTO
durak_karty VALUES("7c","2","2");
INSERT
INTO durak_karty
VALUES("Dk","7","1");
INSERT INTO
durak_karty VALUES("8p","3","3");
INSERT
INTO durak_karty
VALUES("Kc","8","2");
INSERT INTO
durak_karty VALUES("9c","4","2");
INSERT
INTO durak_karty
VALUES("6k","1","1");
INSERT INTO
durak_karty VALUES("Tk","9","1");
INSERT
INTO durak_karty
VALUES("10k","5","1");
INSERT INTO
durak_karty VALUES("Vp","6","3");
INSERT
INTO durak_karty
VALUES("7p","2","3");
INSERT INTO
durak_karty VALUES("Dc","7","2");
INSERT
INTO durak_karty
VALUES("9k","4","1");
INSERT INTO
durak_karty VALUES("8c","3","2");
INSERT
INTO durak_karty VALUES("Kk","8","1");