Спойлер (Отобразить)
CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- CREATE TABLE IF NOT EXISTS `store_top` (
- `id` bigint(20) NOT NULL,
- `appId` bigint(20) NOT NULL,
- `position` smallint(11) NOT NULL,
- `country` enum('BRAZIL','NETHERLANDS','SWITZERLAND','SWEDEN','AUSTRIA','NEWZELAND','ITALY','SPAIN','GERMANY','USA','CANADA','ALBANIA','BELARUS','BELGIUM','BULGARIA','CROATIA','CYPRUS','CHECH REPUBLIC','DENMARK','DEUTSCHLAND','ESPANA','ESTONIA','FINLAND','FRANCE','GREECE','HUNGARY','ICELAND','IRELAND','ITALIA','LATVIA','LITHUANIA','LUXEMBOURG','MACEDONIA','MALTA','MOLDOVA','NEDERLAND','NORWAY','OSTERREICH','POLAND','PORTUGAL','ROMANIA','SCHWEIZ','SLOVAKIA','SLOVENIA','SVERIGE','TURKEY','UKRAINE','UK','RUSSIA','ALGERIA','ANGOLA','ARMENIA','AZERBAIJAN','BAHRAIN','BENIN','BOTSWANA','BURKINA FASO','CAPE VERDE','CHAD','CONGP','EGYPT','GAMBIA','GHANA','GUINEA-BISSAU','INDIA','ISRAEL','JORDAN','KENYA','KUWAIT','LEBANON','LIBERIA','MADAGASCAR','MALAWI','MALI','MAURITANIA','MAURITIUS','MOZAMBIQUE','NAMBIA','NIGER','NIGERIA','OMAN','QATAR','SAO TOME AND PRINCIPE','SAUDI ARABIA','SENEGAL','SEYCHELLES','SIERRA LEONE','SOUTH AFRICA','SWAZILAND','TANZANIA','TUNISIA','UAE','UGANDA','YEMEN','ZIMBABWE','AUSTRALIA','BHUTAN','BRUNEI DARUSSALAM','CAMBODIA','FIJI','HONG KONG','INDONESIA','KAZAKHSTAN','KYRGYZSTAN','LAO PEOPLE’S DEMOCRATIC REPUBLIC','MACAU','MALAYSIA','MICRONESIA','MONGOLIA','NEPAL','NEW ZEALAND','PAKISTAN','PALAU','PAPUA NEW GUINEA','PHILIPPINES','SINGAPORE','SOLOMON ISLANDS','SRI LANKA','TAIWAN','TAJIKISTAN','THAILAND','TURKMENISTAN','UZBEKISTAN','VIETNAM','KOREA','CHINA','JAPAN','ANGUILLA','ANTIGUA AND BARBUDA','ARGENTINA','BAHAMAS','BARBADOS','BELIZE','BERMUDA','BOLIVIA','BRASIL','BRITISH VIRGIN ISLANDS','CAYMAN ISLANDS','CHILE','COLOMBIA','COSTA RICA','DOMINICA','DOMINICA, REPUBLICA','ECUDOR','EL SALVADOR','GRENADA','GUATEMALA','GUYANA','HONDURAS','JAMAICA','MEXICO','MONSTSERRAT','NICARAGUA','PANAMA','PARAGUAY','PERU','ST. KITTS AN NEVIS','ST. LUCIA','ST. VINCENT ANDTHE GRENADINES','SURINAME','TRINIDAD AND TOBAGO','TURKS AND CAICOS','RUGUAY','VENEZUELA') DEFAULT NULL,
- `category` enum('ALL','BOOKS','BUSINESS','CATALOGS','EDUCATION','ENTERTAIMENT','FINANCE','FOOD&DRINK','GAMES','ACTION','ADVENTURE','ARCADE','BOARD','CARD','CASINO','DICE','EDUCATIONAL','FAMILY','MUSIC(GAMES)','PUZZLE','RACING','RPG','SIMULATION','SPOTRS(GAMES)','STRATEGY','TRIVIA','WORD','HEALTH&FITNESS','KIDS','LIFESTYLE','MEDICAL','MUSIC','NAVIGATION','NEWS','NEWSTAND','PHOTO&VIDEO','PRODUCTIVITY','REFERENCE','SOCIALNETWORKING','SPORTS','TRAVEL','UTILITIES','WEATHER') DEFAULT NULL,
- `platform` enum('IPHONE','IPAD') DEFAULT NULL,
- `created` datetime DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
- ALTER TABLE `store_top`
- ADD PRIMARY KEY (`id`),
- ADD KEY `i_ccp_store_top` (`category`,`country`,`platform`),
- ADD KEY `i_country_store_top` (`country`),
- ADD KEY `i_category_store_top` (`category`),
- ADD KEY `i_appId_store_top` (`appId`);