ÿØÿà JFIF    ÿÛ „  ( %"1!%)+...383,7(-.+  -+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â" ÿÄ     ÿÄ H    !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ   ÿÄ %  !1AQa"23‘ÿÚ   ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ ú®ði~TÁbqÐ8OÕpÿ ƒOò¤Oè`–RÂáœá™êi€ßÉ< FtŸI“öÌ8úDf´°å}“¾œ6  öFá°y¥jñÇh†ˆ¢ã/ÃÐ:ªcÈ "Y¡ðÑl>ÿ ”ÏËte:qž\oäŠe÷󲍷˜HT4&ÿ ÓÐü6ö®¿øþßèô Ÿ•7Ñi’•j|“ñì>b…þS?*Óôÿ ÓÐü*h¥£ír¶ü UãSç‚Ÿ[AÐaè[ûª•õ&õj?†Éö+EzP—WeÒírJFt ‘BŒ†Ï‡%#tE Øz ¥OÛ«!1›üä±Í™%ºÍãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3Y´•牋4ǍýʏTì>œú=Íwhyë,¾Ôò×õ¿ßÊa»«þˆѪQ|%6ž™A õ%:øj<>É—ÿ Å_ˆCbõ¥š±ý¯Ýƒï…¶|RëócÍf溪“t.СøTÿ *Ä¿-{†çàczůŽ_–^XþŒ±miB[X±d 1,é”zEù»& î9gœf™9Ð'.;—™i}!ôšåîqêÛ٤ёý£½ÆA–àôe"A$˝Úsäÿ ÷Û #°xŸëí(l »ý3—¥5m! rt`†0~'j2(]S¦¦kv,ÚÇ l¦øJA£Šƒ J3E8ÙiŽ:cÉžúeZ°€¯\®kÖ(79«Ž:¯X”¾³Š&¡* ….‰Ž(ÜíŸ2¥ª‡×Hi²TF¤ò[¨íÈRëÉ䢍mgÑ.Ÿ<öäS0í„ǹÁU´f#Vß;Õ–…P@3ío<ä-±»Ž.L|kªÀê›fÂ6@»eu‚|ÓaÞÆŸ…¨ááå>åŠ?cKü6ùTÍÆ”†sĤÚ;H2RÚ†õ\Ö·Ÿn'¾ ñ#ºI¤Å´%çÁ­‚â7›‹qT3Iï¨ÖÚ5I7Ë!ÅOóŸ¶øÝñØôת¦$Tcö‘[«Ö³šÒ';Aþ ¸èíg A2Z"i¸vdÄ÷.iõ®§)¿]¤À†–‡É&ä{V¶iŽ”.Ó×Õÿ û?h¬Mt–íª[ÿ Ñÿ ÌV(í}=ibÔ¡›¥¢±b Lô¥‡piη_Z<‡z§èŒ)iÖwiÇ 2hÙ3·=’d÷8éŽ1¦¸c¤µ€7›7Ø ð\á)} ¹fËí›pAÃL%âc2 í§æQz¿;T8sæ°qø)QFMð‰XŒÂ±N¢aF¨…8¯!U  Z©RÊ ÖPVÄÀÍin™Ì-GˆªÅËŠ›•zË}º±ŽÍFò¹}Uw×#ä5B¤{î}Ð<ÙD é©¤&‡ïDbàÁôMÁ." ¤‡ú*õ'VŽ|¼´Úgllº¼klz[Æüï÷Aób‡Eÿ dÑ»Xx9ÃÜ£ÁT/`¼¸vI±Ýµ·Ë‚“G³þ*Ÿû´r|*}<¨îºœ @¦mÄ’M¹”.œ«Y–|6ÏU¤jç¥ÕÞqO ˜kDÆÁ¨5ÿ š;Њ¦¦€GÙk \ –Þ=â¼=SͧµªS°ÚÍpÜãQűÀõ¬?ÃÁ1Ñ•õZà?hóœ€ L¦l{Y*K˜Ù›zc˜–ˆâ ø+¾ ­-Ök¥%ùEÜA'}ˆ><ÊIè“bpÍ/qÞâvoX€w,\úªò6Z[XdÒæ­@Ö—€$òJí#é>'°Ú ôª˜<)4ryÙ£|óAÅn5žêŸyÒäMÝ2{"}‰–¤l÷ûWX\l¾Á¸góÉOÔ /óñB¤f¸çñ[.P˜ZsÊË*ßT܈§QN¢’¡¨§V¼(Üù*eÕ“”5T¨‹Âê¥FŒã½Dü[8'Ò¥a…Ú¶k7a *•›¼'Ò·\8¨ª\@\õ¢¦íq+DÙrmÎ…_ªæ»ŠÓœ¡¯’Ré9MÅ×D™lælffc+ŒÑ,ý™ÿ ¯þǤ=Å’Á7µ÷ÚÛ/“Ü€ñýã¼àí¾ÕÑ+ƒ,uµMâÀÄbm:ÒÎPæ{˜Gz[ƒ¯«® KHà`ßØŠéí¯P8Aq.C‰ à€kòpj´kN¶qô€…Õ,ÜNŠª-­{Zö’æû44‰sŽè‰îVíRœÕm" 6?³D9¡ÇTíÅꋇ`4«¸ÝÁô ï’ýorqКÇZ«x4Žâéþuïf¹µö[P ,Q£éaX±`PÉÍZ ¸äYúg üAx ’6Lê‚xÝÓ*äQ  Ï’¨hÍ =²,6ï#rÃ<¯–£»ƒ‹,–ê•€ aÛsñ'%Æ"®ÛüìBᝠHÚ3ß°©$“XnœÖ’î2ËTeûìxîß ¦å¿çÉ ðK§þ{‘t‚Ϋ¬jéîZ[ ”š7L¥4VÚCE×]m¤Øy”ä4-dz£œ§¸x.*ãÊÊ b÷•h:©‡¦s`BTÁRû¾g⻩‹jø sF¢àJøFl‘È•Xᓁà~*j¯ +(ÚÕ6-£¯÷GŠØy‚<Ç’.F‹Hœw(+)ÜÜâÈzÄäT§FߘãÏ;DmVœ3Àu@mÚüXÝü•3B¨òÌÁÛ<·ÃÜ z,Ì@õÅ·d2]ü8s÷IôÞ¯^Ç9¢u„~ëAŸï4«M? K]­ÅàPl@s_ p:°¬ZR”´›JC[CS.h‹ƒïËœ«Æ]–÷ó‚wR×k7X‰k›‘´ù¦=¡«‰¨¨Â')—71ó’c‡Ðúµ `é.{§p¹ój\Ž{1h{o±Ý=áUÊïGÖŒõ–-BÄm+AZX¶¡ ïHðæ¥JmÙ;…ä¡Ÿˆ¦ ° äšiÉg«$üMk5¤L“’çÊvïâï ,=f“"íἊ5ô¬x6{ɏžID0e¸vçmi'︧ºð9$ò¹÷*£’9ÿ ²TÔ…×>JV¥}Œ}$p[bÔ®*[jzS*8 ”·T›Í–ñUîƒwo$áè=LT™ç—~ô·¤ÈÚ$榍q‰„+´kFm)ž‹©i–ËqÞŠ‰à¶ü( ‚•§ •°ò·‡#5ª•µÊ﯅¡X¨šÁ*F#TXJÊ ušJVÍ&=iÄs1‚3•'fý§5Ñ<=[íÞ­ PÚ;ѱÌ_~Ä££8rÞ ²w;’hDT°>ÈG¬8Á²ÚzŽ®ò®qZcqJêäÞ-ö[ܘbň±çb“Š¶31²n×iƒðÕ;1¶þÉ ªX‰,ßqÏ$>•î íZ¥Z 1{ç൵+ƒÕµ¥°T$§K]á»Ûï*·¤tMI’ÂZbŽÕiÒ˜}bÓ0£ª5›¨ [5Ž^ÝœWøÂÝh° ¢OWun£¤5 a2Z.G2³YL]jåtì”ä ÁÓ‘%"©<ÔúÊ°sº UZvä‡ÄiÆÒM .÷V·™ø#kèýiíÌ–ª)µT[)BˆõÑ xB¾B€ÖT¨.¥~ð@VĶr#¸ü*åZNDŽH;âi ],©£öØpù(šºãö¼T.uCê•4@ÿ GÕÛ)Cx›®0ø#:ÏðFÒbR\(€€Ä®fã4Þ‰Fä¯HXƒÅ,†öEÑÔÜ]Öv²?tLÃvBY£ú6Êu5ÅAQ³1‘’¬x–HŒÐ‡ ^ ¸KwJôÖŽ5×CÚ¨vÜ«/B0$×k°=ðbÇ(Ï)w±A†Á† 11Í=èQšµ626ŒÜ/`G«µ<}—-Ö7KEHÈÉðóȤmݱû±·ø«Snmá=“ä«šmݱŸ¡¶~ó·“äUóJæúòB|E LêŽy´jDÔ$G¢þÐñ7óR8ýÒ…Ç› WVe#·Ÿ p·Fx~•ݤF÷0Èÿ K¯æS<6’¡WШ; ´ÿ ¥Êø\Òuî†åÝ–VNœkÒ7oòX¨Á­Ø÷FÎÑä±g÷ÿ M~Çî=p,X´ ÝÌÚÅ‹’ÃjÖ.ØöÏñ qïQ¤ÓZE†° =6·]܈ s¸>v•Ž^Ý\wq9r‰Î\¸¡kURÒ$­*‹Nq?Þª*!sŠÆ:TU_u±T+øX¡ ®¹¡,ÄâÃBTsÜ$Ø›4m椴zÜK]’’›Pƒ @€#â˜`é¹=I‡fiV•Ôî“nRm+µFPOhÍ0B£ €+¬5c v•:P'ÒyÎ ‰V~‚Ó†ÖuókDoh$å\*ö%Ю=£«…aȼ½÷Û.-½VŒŠ¼'lyî±1¬3ó#ÞE¿ÔS¤gV£m›=§\û"—WU¤ÚǼÿ ÂnÁGŒÃ ‚õN D³õNÚíŒÕ;HôyÄÈ©P¹Ä{:?R‘Ô¨âF÷ø£bÅó® JS|‚R÷ivýáâ€Æé¡è³´IئÑT!§˜•Øª‚¬â@q€wnïCWÄ@JU€ê¯m6]Ï:£âx'+ÒðXvÓ¦Úm=–´7œ $ì“B£~p%ÕŸUþ« N@¼üï~w˜ñø5®—'Ôe»¤5ã//€ž~‰Tþ›Å7•#¤× Íö pÄ$ùeåì*«ÓŠEØWEÈsßg ¦ûvžSsLpºÊW–âµEWöˬH; ™!CYõZ ÃÄf æ#1W. \uWâ\,\Çf j’<qTbên›Î[vxx£ë 'ö¨1›˜ÀM¼Pÿ H)ƒêêŒA7s,|F“ 꺸k³9Ìö*ç®;Ö!Ö$Eiž•¹ÒÚ†ýóéÝû¾ÕS®ó$’NÝäŸz¤5r¦ãÄÃD÷Üø!°ø‡Ô&@m™Ì^Ãä­d q5Lnÿ N;.6½·N|#ä"1Nƒx“ã<3('&ñßt  ~ªu”1Tb㫨9ê–›–bìd$ߣ=#ÕãÒmU¯eí$EFù5ýYô櫨æ왍Ǘ±ssM]·á¿0ÕåJRÓªîiƒ+O58ÖñªŠÒx" \µâá¨i’¤i —Ö ” M+M¤ë9‚‰A¦°Qõ¾ßøK~¼Ã‘g…Ö´~÷Ï[3GUœÒ½#…kàÔ®Ò”‰³·dWV‰IP‰Ú8u¹”E ÖqLj¾êÕCBš{A^Âß;–¨`¯¬ìö ˼ ×tìø.tƐm*n¨y4o&Àx¥n¦×î‡aupáÛj8¿m›è¶ã!o½;ß0y^ý×^EÑ¿ÒjzŒ­)vÚÑnÄL …^ªô× ‡—‚3k Îý­hï]içå–îÏ*÷ñþ»Ô CÒjøjÍznˆ´ ¹#b'Fô‹ ‰v¥'’à'T´ƒHýÍ%M‰ ƒ&ÆÇŒï1 ‘ –Þ ‰i¬s žR-Ÿ kŠ¬á¬7:þ 0ŒÅÒÕ/aÙ¬ÃÝ#Úøœ ©aiVc‰. ¹¦ãµ” ›Yg¦›ÆÎýº°f³7ƒhá·¸­}&D9¡ÂsÉÙÞèŠõØàC™¨ñbFC|´Ü(ŸƒÚÒ-%»'a Ì¿)ËÇn¿úÿ ÞŽX…4ÊÅH^ôΑí@ù¹Eh¶“L8Çjù ¼ÎåVªóR©Ï5uà V4lZß®=€xÖŸ–ÑÈ ÷”¨°¾__yM1tÉ?uÆþIkÄgæ@þ[¢†°XÃJ£j·:nkÅ¢u ‘}âGzö­/IµèŠ¬¼48q¦F°ŽR¼=ûì{´¯RýicS ÕÛ íNtÍÙï£,w4rêì®»~x(©Uñ§#Ñ&œÕ¤>ÎåÍÓ9’Ö{9eV­[Öjâ²ãu]˜å2›qÑšÕJç0€sÄ|Êëè0튔bÁ>“{×_F`Ø©ºê:µä,v¤ðfc1±"«ÔÍän1#=· Âøv~H½ÐßA¾¿Ü€Óš]Õ; I¾÷ç‚Qi†î¹9ywÔKG˜áñ zQY—§ÃÕZ07§X‚ Áh;ÁM)iÌCH-¯T‘ë|A0{Ò½LÚ–TâÖkÜ’dÀ“rmm»”جPF³ÖcbE§T€ÒxKºû’Ó®7±²(\4ŽÃ¸Uu@j™yĵ;³µ!Á¢b.W¤=mõ´êµK k ¸K^ÜÛ#p*Ü14qkZç5ïë †°5Ï%ÍÛ<Õ¤×Ô¥ê†C Õ´¼ú$ƒÖ“”]Ù¬qÞÚ[4©ý!ûÏ—Áb쳐XµA¬â~`›Çr¸8ìùÝ䫦<>ä÷«?xs´ÇÑ /á;¹øüÊÈÙà{"@Žïzâ¬[âß‚ U_<ÇŸ½4èN˜ú61®qŠu ¦þF£»äJ_ˆÙÎ~ ÞAã–Ý„Ï—rŠD;xTž‘ô`É«…suãO`?³à™ô Lý#Íc5öoæØ‚y´´÷«ZR§<&JÇ+éâô´€i!Àˆ0æAoàðLèÖ-2ŸõW.’t^–(KÁmHµV@xÜÇy®Ñø­â^:Ú3w· 7½¹°ñ¸â¹®:',«Mœ—n­Á+Ãbš LÈ‘ÄnRÓÅœ%¦²‰¨ùQ:¤f‚ "PÕtô¸…cæl…&˜Ú˜Ôkv‹ž+vŠ,=¢v­6—Xy*¥t£«<™:“aîϲ=¦6rO]XI¿Œ÷¤zÚ­›¶ 6÷”w\d ü~v®ˆÌk«^m<ÿ ¢‰Õ\)ùºŽ;… lîÙÅEŠ®cѾ@vnMÏ,¼“ñ•ŽBxðÃzãÇç%3ˆ"}Ù•Åî> BÉú;Ò]V+P˜F_´ßé> Øše|ï‡ÄOmFæÇ ãqÞ$/xÐx­z`ï9"œÜij‚!7.\Td…9M‡•iŽ‹¾‘50ÞŽn¥ß4ÉôO ¹*í^QêËÜÇÌ8=Ž§s‰'ÂëÙ«á%Pú[O †ÅP¯VsŽ°.‰,kc¶ ¬A9n˜XÎ-ÞšN["¹QÕ‰ƒMýÁߺXJæÍaLj¾×Ãmã¾ãÚ uñÒþåQô¦¥ /ÄUx:‚ÍÜ’ Đ©ØÝ3V¨‰ÕnÐ6ó*óúK­«…c ¯U òhsý­jóÔj#,ímŒRµ«lbïUTŒÑ8†Ä0œÏr`ð¡¬É Ї ë"À² ™ 6¥ f¶ ¢ÚoܱԷ-<Àî)†a¶ž'Ú»¨TXqØæ¶÷YÄHy˜9ÈIW­YÀuMFë ºÏ’AqÌ4·/Ú †ô'i$øä­=Ä Ý|öK×40è|È6p‘0§)o¥ctî§H+CA-“ xØ|ÐXŠç l8íºð3Ø:³¤¬KX¯UÿÙ set($params); } /** * Creates(if not already created) and returns the corresponding Index object * * @param string $schema database name * @param string $table table name * @param string $index_name index name * * @return Index corresponding Index object */ static public function singleton($schema, $table, $index_name = '') { Index::_loadIndexes($table, $schema); if (! isset(Index::$_registry[$schema][$table][$index_name])) { $index = new Index; if (mb_strlen($index_name)) { $index->setName($index_name); Index::$_registry[$schema][$table][$index->getName()] = $index; } return $index; } else { return Index::$_registry[$schema][$table][$index_name]; } } /** * returns an array with all indexes from the given table * * @param string $table table * @param string $schema schema * * @return Index[] array of indexes */ static public function getFromTable($table, $schema) { Index::_loadIndexes($table, $schema); if (isset(Index::$_registry[$schema][$table])) { return Index::$_registry[$schema][$table]; } else { return array(); } } /** * Returns an array with all indexes from the given table of the requested types * * @param string $table table * @param string $schema schema * @param int $choices choices * * @return Index[] array of indexes */ static public function getFromTableByChoice($table, $schema, $choices = 31) { $indexes = array(); foreach (self::getFromTable($table, $schema) as $index) { if (($choices & Index::PRIMARY) && $index->getChoice() == 'PRIMARY' ) { $indexes[] = $index; } if (($choices & Index::UNIQUE) && $index->getChoice() == 'UNIQUE' ) { $indexes[] = $index; } if (($choices & Index::INDEX) && $index->getChoice() == 'INDEX' ) { $indexes[] = $index; } if (($choices & Index::SPATIAL) && $index->getChoice() == 'SPATIAL' ) { $indexes[] = $index; } if (($choices & Index::FULLTEXT) && $index->getChoice() == 'FULLTEXT' ) { $indexes[] = $index; } } return $indexes; } /** * return primary if set, false otherwise * * @param string $table table * @param string $schema schema * * @return mixed primary index or false if no one exists */ static public function getPrimary($table, $schema) { Index::_loadIndexes($table, $schema); if (isset(Index::$_registry[$schema][$table]['PRIMARY'])) { return Index::$_registry[$schema][$table]['PRIMARY']; } else { return false; } } /** * Load index data for table * * @param string $table table * @param string $schema schema * * @return boolean whether loading was successful */ static private function _loadIndexes($table, $schema) { if (isset(Index::$_registry[$schema][$table])) { return true; } $_raw_indexes = $GLOBALS['dbi']->getTableIndexes($schema, $table); foreach ($_raw_indexes as $_each_index) { $_each_index['Schema'] = $schema; $keyName = $_each_index['Key_name']; if (! isset(Index::$_registry[$schema][$table][$keyName])) { $key = new Index($_each_index); Index::$_registry[$schema][$table][$keyName] = $key; } else { $key = Index::$_registry[$schema][$table][$keyName]; } $key->addColumn($_each_index); } return true; } /** * Add column to index * * @param array $params column params * * @return void */ public function addColumn($params) { if (isset($params['Column_name']) && mb_strlen($params['Column_name']) ) { $this->_columns[$params['Column_name']] = new IndexColumn($params); } } /** * Adds a list of columns to the index * * @param array $columns array containing details about the columns * * @return void */ public function addColumns($columns) { $_columns = array(); if (isset($columns['names'])) { // coming from form // $columns[names][] // $columns[sub_parts][] foreach ($columns['names'] as $key => $name) { $sub_part = isset($columns['sub_parts'][$key]) ? $columns['sub_parts'][$key] : ''; $_columns[] = array( 'Column_name' => $name, 'Sub_part' => $sub_part, ); } } else { // coming from SHOW INDEXES // $columns[][name] // $columns[][sub_part] // ... $_columns = $columns; } foreach ($_columns as $column) { $this->addColumn($column); } } /** * Returns true if $column indexed in this index * * @param string $column the column * * @return boolean true if $column indexed in this index */ public function hasColumn($column) { return isset($this->_columns[$column]); } /** * Sets index details * * @param array $params index details * * @return void */ public function set($params) { if (isset($params['columns'])) { $this->addColumns($params['columns']); } if (isset($params['Schema'])) { $this->_schema = $params['Schema']; } if (isset($params['Table'])) { $this->_table = $params['Table']; } if (isset($params['Key_name'])) { $this->_name = $params['Key_name']; } if (isset($params['Index_type'])) { $this->_type = $params['Index_type']; } if (isset($params['Comment'])) { $this->_remarks = $params['Comment']; } if (isset($params['Index_comment'])) { $this->_comment = $params['Index_comment']; } if (isset($params['Non_unique'])) { $this->_non_unique = $params['Non_unique']; } if (isset($params['Packed'])) { $this->_packed = $params['Packed']; } if (isset($params['Index_choice'])) { $this->_choice = $params['Index_choice']; } else { if ('PRIMARY' == $this->_name) { $this->_choice = 'PRIMARY'; } elseif ('FULLTEXT' == $this->_type) { $this->_choice = 'FULLTEXT'; $this->_type = ''; } elseif ('SPATIAL' == $this->_type) { $this->_choice = 'SPATIAL'; $this->_type = ''; } elseif ('0' == $this->_non_unique) { $this->_choice = 'UNIQUE'; } else { $this->_choice = 'INDEX'; } } if (isset($params['Key_block_size'])) { $this->_key_block_size = $params['Key_block_size']; } if (isset($params['Parser'])) { $this->_parser = $params['Parser']; } } /** * Returns the number of columns of the index * * @return integer the number of the columns */ public function getColumnCount() { return count($this->_columns); } /** * Returns the index comment * * @return string index comment */ public function getComment() { return $this->_comment; } /** * Returns index remarks * * @return string index remarks */ public function getRemarks() { return $this->_remarks; } /** * Return the key block size * * @return number */ public function getKeyBlockSize() { return $this->_key_block_size; } /** * Return the parser * * @return string */ public function getParser() { return $this->_parser; } /** * Returns concatenated remarks and comment * * @return string concatenated remarks and comment */ public function getComments() { $comments = $this->getRemarks(); if (mb_strlen($comments)) { $comments .= "\n"; } $comments .= $this->getComment(); return $comments; } /** * Returns index type (BTREE, HASH, RTREE) * * @return string index type */ public function getType() { return $this->_type; } /** * Returns index choice (PRIMARY, UNIQUE, INDEX, SPATIAL, FULLTEXT) * * @return string index choice */ public function getChoice() { return $this->_choice; } /** * Return a list of all index choices * * @return string[] index choices */ static public function getIndexChoices() { return array( 'PRIMARY', 'INDEX', 'UNIQUE', 'SPATIAL', 'FULLTEXT', ); } /** * Returns a lit of all index types * * @return string[] index types */ static public function getIndexTypes() { return array( 'BTREE', 'HASH' ); } /** * Returns HTML for the index choice selector * * @param boolean $edit_table whether this is table editing * * @return string HTML for the index choice selector */ public function generateIndexChoiceSelector($edit_table) { $html_options = ''; return $html_options; } /** * Returns HTML for the index type selector * * @return string HTML for the index type selector */ public function generateIndexTypeSelector() { $types = array("" => "--"); foreach (Index::getIndexTypes() as $type) { $types[$type] = $type; } return Util::getDropdown( "index[Index_type]", $types, $this->_type, "select_index_type" ); } /** * Returns how the index is packed * * @return string how the index is packed */ public function getPacked() { return $this->_packed; } /** * Returns 'No'/false if the index is not packed, * how the index is packed if packed * * @param boolean $as_text whether to output should be in text * * @return mixed how index is packed */ public function isPacked($as_text = false) { if ($as_text) { $r = array( '0' => __('No'), '1' => __('Yes'), ); } else { $r = array( '0' => false, '1' => true, ); } if (null === $this->_packed) { return $r[0]; } return $this->_packed; } /** * Returns integer 0 if the index cannot contain duplicates, 1 if it can * * @return integer 0 if the index cannot contain duplicates, 1 if it can */ public function getNonUnique() { return $this->_non_unique; } /** * Returns whether the index is a 'Unique' index * * @param boolean $as_text whether to output should be in text * * @return mixed whether the index is a 'Unique' index */ public function isUnique($as_text = false) { if ($as_text) { $r = array( '0' => __('Yes'), '1' => __('No'), ); } else { $r = array( '0' => true, '1' => false, ); } return $r[$this->_non_unique]; } /** * Returns the name of the index * * @return string the name of the index */ public function getName() { return $this->_name; } /** * Sets the name of the index * * @param string $name index name * * @return void */ public function setName($name) { $this->_name = (string) $name; } /** * Returns the columns of the index * * @return IndexColumn[] the columns of the index */ public function getColumns() { return $this->_columns; } /** * Show index data * * @param string $table The table name * @param string $schema The schema name * @param boolean $print_mode Whether the output is for the print mode * * @return string HTML for showing index * * @access public */ static public function getHtmlForIndexes($table, $schema, $print_mode = false) { $indexes = Index::getFromTable($table, $schema); $no_indexes_class = count($indexes) > 0 ? ' hide' : ''; $no_indexes = "
"; $no_indexes .= Message::notice(__('No index defined!'))->getDisplay(); $no_indexes .= '
'; if (! $print_mode) { $r = '
'; $r .= '' . __('Indexes'); $r .= Util::showMySQLDocu('optimizing-database-structure'); $r .= ''; $r .= $no_indexes; if (count($indexes) < 1) { $r .= '
'; return $r; } $r .= Index::findDuplicates($table, $schema); } else { $r = '

' . __('Indexes') . '

'; $r .= $no_indexes; if (count($indexes) < 1) { return $r; } } $r .= ''; $r .= ''; $r .= ''; if (! $print_mode) { $r .= ''; } $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $r .= ''; $odd_row = true; foreach ($indexes as $index) { $row_span = ' rowspan="' . $index->getColumnCount() . '" '; $r .= ''; if (! $print_mode) { $this_params = $GLOBALS['url_params']; $this_params['index'] = $index->getName(); $r .= '' . "\n"; $this_params = $GLOBALS['url_params']; if ($index->getName() == 'PRIMARY') { $this_params['sql_query'] = 'ALTER TABLE ' . Util::backquote($table) . ' DROP PRIMARY KEY;'; $this_params['message_to_show'] = __('The primary key has been dropped.'); $js_msg = PMA_jsFormat($this_params['sql_query']); } else { $this_params['sql_query'] = 'ALTER TABLE ' . Util::backquote($table) . ' DROP INDEX ' . Util::backquote($index->getName()) . ';'; $this_params['message_to_show'] = sprintf( __('Index %s has been dropped.'), htmlspecialchars($index->getName()) ); $js_msg = PMA_jsFormat($this_params['sql_query']); } $r .= '' . "\n"; } if (! $print_mode) { $r .= ''; } else { $r .= ''; } $r .= ''; $r .= ''; $r .= ''; foreach ($index->getColumns() as $column) { if ($column->getSeqInIndex() > 1) { $r .= ''; } $r .= ''; $r .= ''; $r .= ''; $r .= ''; if ($column->getSeqInIndex() == 1 ) { $r .= ''; } $r .= ''; } // end foreach $index['Sequences'] $odd_row = ! $odd_row; } // end while $r .= ''; $r .= '
' . __('Action') . '' . __('Keyname') . '' . __('Type') . '' . __('Unique') . '' . __('Packed') . '' . __('Column') . '' . __('Cardinality') . '' . __('Collation') . '' . __('Null') . '' . __('Comment') . '
' . ' ' . Util::getIcon('b_edit.png', __('Edit')) . '' . ''; $r .= ''; $r .= ' ' . Util::getIcon('b_drop.png', __('Drop')) . '' . '' . htmlspecialchars($index->getName()) . '' . htmlspecialchars($index->getName()) . ''; $type = $index->getType(); if (! empty($type)) { $r .= htmlspecialchars($type); } else { $r .= htmlspecialchars($index->getChoice()); } $r .= '' . $index->isUnique(true) . '' . $index->isPacked(true) . '
' . htmlspecialchars($column->getName()); if ($column->getSubPart()) { $r .= ' (' . htmlspecialchars($column->getSubPart()) . ')'; } $r .= '' . htmlspecialchars($column->getCardinality()) . '' . htmlspecialchars($column->getCollation()) . '' . htmlspecialchars($column->getNull(true)) . '' . htmlspecialchars($index->getComments()) . '
'; if (! $print_mode) { $r .= ''; } return $r; } /** * Gets the properties in an array for comparison purposes * * @return array an array containing the properties of the index */ public function getCompareData() { $data = array( // 'Non_unique' => $this->_non_unique, 'Packed' => $this->_packed, 'Index_choice' => $this->_choice, ); foreach ($this->_columns as $column) { $data['columns'][] = $column->getCompareData(); } return $data; } /** * Function to check over array of indexes and look for common problems * * @param string $table table name * @param string $schema schema name * * @return string Output HTML * @access public */ static public function findDuplicates($table, $schema) { $indexes = Index::getFromTable($table, $schema); $output = ''; // count($indexes) < 2: // there is no need to check if there less than two indexes if (count($indexes) < 2) { return $output; } // remove last index from stack and ... while ($while_index = array_pop($indexes)) { // ... compare with every remaining index in stack foreach ($indexes as $each_index) { if ($each_index->getCompareData() !== $while_index->getCompareData() ) { continue; } // did not find any difference // so it makes no sense to have this two equal indexes $message = Message::notice( __( 'The indexes %1$s and %2$s seem to be equal and one of them ' . 'could possibly be removed.' ) ); $message->addParam($each_index->getName()); $message->addParam($while_index->getName()); $output .= $message->getDisplay(); // there is no need to check any further indexes if we have already // found that this one has a duplicate continue 2; } } return $output; } }