File size: 4.22Kb
ALTER TABLE `user` ADD `collection_pooh` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_1` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_2` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_3` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_4` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_5` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_6` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_7` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_8` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_9` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_10` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_11` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_12` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_13` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_pooh_nomer_14` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection` INT( 11 ) NOT NULL;
CREATE TABLE IF NOT EXISTS `collection_obmen_pooh` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_kto` int(11) NOT NULL,
`id_skem` int(11) NOT NULL,
`nomer_coll` int(11) NOT NULL,
`nomer_jett` int(11) NOT NULL,
`na_kakoi` int(11) NOT NULL,
`read` set('0','1') NOT NULL DEFAULT '0',
`unlink` int(11) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `id_kto` (`id_kto`,`id_skem`),
KEY `read` (`read`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
ALTER TABLE `user` ADD `collection_smesh` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_1` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_2` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_3` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_4` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_5` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_6` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_7` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_8` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_9` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_10` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_11` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_smesh_nomer_12` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_1` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_2` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_3` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_4` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_5` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_6` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_7` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_8` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_9` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_10` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_11` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_12` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_ddak_nomer_13` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_gerk` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_gerk_nomer_1` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_gerk_nomer_2` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_gerk_nomer_3` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_gerk_nomer_4` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_gerk_nomer_5` INT( 11 ) NOT NULL;
ALTER TABLE `user` ADD `collection_gerk_nomer_6` INT( 11 ) NOT NULL;
CREATE TABLE `collection_sett` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`moneypooh` varchar(100) NOT NULL,
`moneysmesh` varchar(100) NOT NULL,
`moneyddak` varchar(100) NOT NULL,
`moneygerk` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
INSERT INTO `collection_sett` VALUES("1","100","150", "170", "200");