run_crons_all
run_page_cronscfile: class_tables.php Array
(
)
update_alldb_name: Tables_in_attic_data
* inside get_tables *select * from stables where tname='A_US' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='24'tables_id: 24
select * from stables where tname='a_cities' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='25'tables_id: 25
select * from stables where tname='all_types' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='1'tables_id: 1
select * from stables where tname='all_types_data' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='2'tables_id: 2
select * from stables where tname='art_options' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='3'tables_id: 3
select * from stables where tname='art_plugins' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='4'tables_id: 4
select * from stables where tname='articles' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='5'tables_id: 5
select * from stables where tname='crons' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='6'tables_id: 6
select * from stables where tname='crons_logs' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='7'tables_id: 7
select * from stables where tname='customers' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='8'tables_id: 8
select * from stables where tname='domains' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='29'tables_id: 29
select * from stables where tname='domains_bases' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='30'tables_id: 30
select * from stables where tname='domains_folders' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='31'tables_id: 31
select * from stables where tname='domains_hosts' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='32'tables_id: 32
select * from stables where tname='photos' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='9'tables_id: 9
select * from stables where tname='products' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='10'tables_id: 10
select * from stables where tname='products_cats' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='11'tables_id: 11
select * from stables where tname='products_docs' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='12'tables_id: 12
select * from stables where tname='sections' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='13'tables_id: 13
select * from stables where tname='sessions' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='14'tables_id: 14
select * from stables where tname='socials' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='15'tables_id: 15
select * from stables where tname='socials_history' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='16'tables_id: 16
select * from stables where tname='socials_notifications' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='17'tables_id: 17
select * from stables where tname='stables' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='18'tables_id: 18
select * from stables where tname='stables_fields' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='19'tables_id: 19
select * from stables where tname='stables_keys' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='20'tables_id: 20
select * from stables where tname='updates' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='21'tables_id: 21
select * from stables where tname='widgets' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='22'tables_id: 22
select * from stables where tname='wmessages' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='23'tables_id: 23
update stables set date_removed=now() where itype='0' and sid='1' and tables_id not in (24,25,1,2,3,4,5,6,7,8,29,30,31,32,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23)update stables set trows=246244,avg_row_len=117,data_len=29049492,data_free='',index_len=64154624,auto_increment='',collation='latin1_swedish_ci',date_created='2025-07-18 06:49:14',date_updated='2025-07-18 06:49:16',date_checked='2025-07-18 06:49:18',engine='MyISAM' where tables_id='24'update stables set trows=30095,avg_row_len=183,data_len=5510976,data_free='',index_len=12582912,auto_increment=8520902,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:18',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='25'update stables set trows=52,avg_row_len=163,data_len=8476,data_free='',index_len=2048,auto_increment=175,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='1'update stables set trows=467,avg_row_len=155,data_len=72484,data_free='',index_len=15360,auto_increment=3701,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='2'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_general_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='3'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=3,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='4'update stables set trows=19,avg_row_len=89,data_len=1696,data_free='',index_len=28672,auto_increment=31,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='5'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=4096,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='6'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='7'update stables set trows=2,avg_row_len=148,data_len=296,data_free='',index_len=2048,auto_increment=8,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='8'update stables set trows='',avg_row_len='',data_len=16384,data_free='',index_len=229376,auto_increment=2,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated=NULL,date_checked=NULL,engine='InnoDB' where tables_id='29'update stables set trows=1,avg_row_len=56,data_len=56,data_free='',index_len=7168,auto_increment=2,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='30'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=2048,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='31'update stables set trows=1,avg_row_len=84,data_len=84,data_free='',index_len=12288,auto_increment=2,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='32'update stables set trows='',avg_row_len='',data_len=16384,data_free='',index_len=278528,auto_increment=1,collation='latin1_general_ci',date_created='2025-07-18 06:49:19',date_updated=NULL,date_checked=NULL,engine='InnoDB' where tables_id='9'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_general_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='10'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='11'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_general_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='12'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='13'update stables set trows=1245,avg_row_len=58,data_len=72332,data_free='',index_len=15360,auto_increment='',collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-12-11 23:58:28',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='14'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='15'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='16'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked=NULL,engine='MyISAM' where tables_id='17'update stables set trows=32,avg_row_len=119,data_len=3808,data_free='',index_len=29696,auto_increment=33,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-12-12 00:10:24',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='18'update stables set trows=597,avg_row_len=55,data_len=33300,data_free='',index_len=95232,auto_increment=646,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-11-01 02:52:52',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='19'update stables set trows=398,avg_row_len=113,data_len=45000,data_free='',index_len=44032,auto_increment=399,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-11-01 02:52:52',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='20'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='21'update stables set trows=24,avg_row_len=56,data_len=1344,data_free='',index_len=11264,auto_increment=35,collation='latin1_swedish_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='22'update stables set trows='',avg_row_len='',data_len='',data_free='',index_len=2048,auto_increment=1,collation='latin1_general_ci',date_created='2025-07-18 06:49:19',date_updated='2025-07-18 06:49:19',date_checked='2025-07-18 06:49:19',engine='MyISAM' where tables_id='23'
***get_fields select * from stables where itype=0 and sid=1 and date_removed is NULL order by tname ASC total: 29
*********** DESCRIBE all_types
**************** 1 from_types_id
**************** 1 gid
**************** 1 multiples
**************** 1 locked
**************** 1 in_products
**************** 1 json delete from stables_fields where tables_id='1' and fid not in (1,2,3,636,5,7,637,9,10)
*********** DESCRIBE all_types_data
**************** 2 from_data_id
**************** 2 gid
**************** 2 clause
**************** 2 perc
**************** 2 mindex
**************** 2 ord delete from stables_fields where tables_id='2' and fid not in (11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,579)
*********** DESCRIBE articles
**************** 5 gid
**************** 5 options_id
**************** 5 geonameid
**************** 5 print_content
**************** 5 views
**************** 5 removed
**************** 5 spriority
**************** 5 frequency
**************** 5 in_ai delete from stables_fields where tables_id='5' and fid not in (30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,580,581,582)
*********** DESCRIBE art_options
**************** 3 art_id
**************** 3 gid
**************** 3 options_id delete from stables_fields where tables_id='3' and fid not in (80,81,82,83)
*********** DESCRIBE art_plugins
delete from stables_fields where tables_id='4' and fid not in (84,85,86,87,88,89,90)
*********** DESCRIBE a_cities
**************** 25 slug delete from stables_fields where tables_id='25' and fid not in (403,405,406,407,572,408,409,410,411,412,573,413,414,415,416,417,418,419,420,421,422,574)
*********** DESCRIBE A_US
**************** 24 art_id
**************** 24 search
**************** 24 latitude
**************** 24 longitude
**************** 24 population
**************** 24 expression
**************** 24 reviews
**************** 24 notindexed
**************** 24 checked
**************** 24 popular
**************** 24 pimage delete from stables_fields where tables_id='24' and fid not in (423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449)
*********** DESCRIBE crons
**************** 6 wid
**************** 6 json_pms
**************** 6 minutes_max
**************** 6 top_priority
**************** 6 time_each
**************** 6 keep_as_active delete from stables_fields where tables_id='6' and fid not in (91,92,93,94,95,96,97,98,99,100,101,583,584,585,586,102,103,104,105)
*********** DESCRIBE crons_logs
**************** 7 crons_id
**************** 7 content
**************** 7 stotal
**************** 7 sdone
**************** 7 time_running delete from stables_fields where tables_id='7' and fid not in (106,107,108,109,110,111,112,113)
*********** DESCRIBE customers
**************** 8 types_id
**************** 8 news delete from stables_fields where tables_id='8' and fid not in (114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132)
*********** DESCRIBE domains
**************** 29 programs_id
**************** 29 subs_id
**************** 29 apis_id
**************** 29 geonameid
**************** 29 locations_id
**************** 29 active
**************** 29 need_update
**************** 29 sql_population
**************** 29 send_updates
**************** 29 update_products delete from stables_fields where tables_id='29' and fid not in (587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611)
*********** DESCRIBE domains_bases
**************** 30 hosts_id
**************** 30 db_name
**************** 30 db_user
**************** 30 db_pass
**************** 30 prime
**************** 30 locked delete from stables_fields where tables_id='30' and fid not in (612,613,614,615,616,617,618,619)
*********** DESCRIBE domains_folders
**************** 31 folder
**************** 31 files_total delete from stables_fields where tables_id='31' and fid not in (620,621,622,623,624)
*********** DESCRIBE domains_hosts
**************** 32 hid
**************** 32 domains_id delete from stables_fields where tables_id='32' and fid not in (625,626,627,628,629,630,631,632,633,634)
*********** DESCRIBE photos
**************** 9 gid
**************** 9 ptypes_id
**************** 9 art_id
**************** 9 products_id
**************** 9 gid_pid
**************** 9 customers_id
**************** 9 spaces_id
**************** 9 hardscape_id
**************** 9 specialty_id
**************** 9 oname
**************** 9 size
**************** 9 ord
**************** 9 main
**************** 9 width
**************** 9 height
**************** 9 published
**************** 9 processed delete from stables_fields where tables_id='9' and fid not in (133,134,135,136,137,138,139,140,141,142,143,499,144,145,146,147,148,149,150,151,152,153,154,155,156)
*********** DESCRIBE products
**************** 10 cats
**************** 10 brands_id
**************** 10 conditions_id
**************** 10 pcountries_id
**************** 10 weight
**************** 10 width
**************** 10 len
**************** 10 height
**************** 10 published
**************** 10 discontinued delete from stables_fields where tables_id='10' and fid not in (157,165,638,181,639,640,641,642,184,643,644,174,187,189,200,201)
*********** DESCRIBE products_cats
**************** 11 gid
**************** 11 products_id
**************** 11 options_id
**************** 11 ord delete from stables_fields where tables_id='11' and fid not in (202,203,204,205,206,207)
*********** DESCRIBE products_docs
**************** 12 products_id
**************** 12 types_id
**************** 12 mcats_id delete from stables_fields where tables_id='12' and fid not in (208,209,210,211,212,213,214)
*********** DESCRIBE sections
**************** 13 inactive delete from stables_fields where tables_id='13' and fid not in (215,216,217,218,219,220,221,222,223,224,225,645,226,227,228)
*********** DESCRIBE sessions
**************** 14 sid
**************** 14 bid
**************** 14 last_aid
**************** 14 tz
**************** 14 expiry delete from stables_fields where tables_id='14' and fid not in (229,230,635,500,232,501,234,235,237,238,239,240,241,242,243,244,250,251)
*********** DESCRIBE socials
**************** 15 customers_id
**************** 15 is_bot
**************** 15 is_spam
**************** 15 confirmed
**************** 15 inactive delete from stables_fields where tables_id='15' and fid not in (252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267)
*********** DESCRIBE socials_history
**************** 16 events_id delete from stables_fields where tables_id='16' and fid not in (268,269,270,271,272,273,274)
*********** DESCRIBE socials_notifications
delete from stables_fields where tables_id='17' and fid not in (275,276,277,278)
*********** DESCRIBE stables
delete from stables_fields where tables_id='18' and fid not in (279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305)
*********** DESCRIBE stables_fields
delete from stables_fields where tables_id='19' and fid not in (306,307,308,309,310,311,312,313,314,315,316,317)
*********** DESCRIBE stables_keys
delete from stables_fields where tables_id='20' and fid not in (318,319,320,321,322,323)
*********** DESCRIBE updates
**************** 21 clogs_id
**************** 21 wid
**************** 21 fid_value
**************** 21 errors_id
**************** 21 json_sent
**************** 21 json_received delete from stables_fields where tables_id='21' and fid not in (324,325,326,327,328,329,330,331,332)
*********** DESCRIBE widgets
delete from stables_fields where tables_id='22' and fid not in (333,334,335,336,337,338,339,340,341,342,343,344)
*********** DESCRIBE wmessages
**************** 23 leads_id
**************** 23 ip
**************** 23 firstname
**************** 23 lastname
**************** 23 status
**************** 23 company
**************** 23 website
**************** 23 ownername
**************** 23 manager
**************** 23 years
**************** 23 fax
**************** 23 btype
**************** 23 showroom
**************** 23 showroom_size
**************** 23 warehouse
**************** 23 warehouse_size
**************** 23 address
**************** 23 formatted_address
**************** 23 city
**************** 23 state
**************** 23 zip
**************** 23 county
**************** 23 country
**************** 23 lat
**************** 23 lon
**************** 23 email
**************** 23 phone
**************** 23 dayphone
**************** 23 eveningphone
**************** 23 besttime
**************** 23 how
**************** 23 spec1
**************** 23 idspec1
**************** 23 spec2
**************** 23 idspec2
**************** 23 sizes_id
**************** 23 goal
**************** 23 kids
**************** 23 pets
**************** 23 size
**************** 23 time_frame
**************** 23 best_time
**************** 23 installation
**************** 23 budget
**************** 23 comments
**************** 23 news
**************** 23 layout
**************** 23 action
**************** 23 viewed
**************** 23 removed
**************** 23 referer
**************** 23 geonameid
**************** 23 landing_id
**************** 23 updated
**************** 23 json delete from stables_fields where tables_id='23' and fid not in (345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402)SHOW INDEX FROM all_types
PRIMARY types_id
PRIMARY Array
(
[0] => Array
(
[fname] => types_id
[ord] => 1
[collation] => A
[cardinality] => 52
)
)
Array
(
[tables_id] => 1
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"types_id","ord":"1","collation":"A","cardinality":"52"}]
)
update stables_keys set tables_id=1,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"types_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"52\"}]' where tables_id='1' and kname='PRIMARY'select * from stables_keys where tables_id='1' and kid not in (1)SHOW INDEX FROM all_types_data
PRIMARY data_id
date_last date_last
PRIMARY Array
(
[0] => Array
(
[fname] => data_id
[ord] => 1
[collation] => A
[cardinality] => 467
)
)
Array
(
[tables_id] => 2
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"data_id","ord":"1","collation":"A","cardinality":"467"}]
)
update stables_keys set tables_id=2,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"data_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"467\"}]' where tables_id='2' and kname='PRIMARY'date_last Array
(
[0] => Array
(
[fname] => date_last
[ord] => 1
[collation] => A
[cardinality] => 11
)
)
Array
(
[tables_id] => 2
[kname] => date_last
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_last","ord":"1","collation":"A","cardinality":"11"}]
)
update stables_keys set tables_id=2,kname='date_last',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_last\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"11\"}]' where tables_id='2' and kname='date_last'select * from stables_keys where tables_id='2' and kid not in (9,359)SHOW INDEX FROM art_options
PRIMARY id
PRIMARY Array
(
[0] => Array
(
[fname] => id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 3
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=3,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='3' and kname='PRIMARY'select * from stables_keys where tables_id='3' and kid not in (20)SHOW INDEX FROM art_plugins
PRIMARY ap_id
PRIMARY Array
(
[0] => Array
(
[fname] => ap_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 4
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"ap_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=4,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"ap_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='4' and kname='PRIMARY'select * from stables_keys where tables_id='4' and kid not in (23)SHOW INDEX FROM articles
PRIMARY art_id
previews views
removed removed
review review
private private
published published
sections_id sections_id
sections_top sections_top
temps_id temps_id
mtemps_id mtemps_id
arts_type arts_type
domains_id domains_id
products_id products_id
slug slug
metas_title metas_title
social_image social_image
versions_id versions_id
customers_id customers_id
from_art_id from_art_id
for_art_id for_art_id
is_cache is_cache
gid gid
options_id options_id
geonameid geonameid
PRIMARY Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='PRIMARY'previews Array
(
[0] => Array
(
[fname] => views
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => previews
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"views","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='previews',is_unique='',date_updated=now(),sjson='[{\"fname\":\"views\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='previews'removed Array
(
[0] => Array
(
[fname] => removed
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => removed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"removed","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='removed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"removed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='removed'review Array
(
[0] => Array
(
[fname] => review
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => review
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"review","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='review',is_unique='',date_updated=now(),sjson='[{\"fname\":\"review\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='review'private Array
(
[0] => Array
(
[fname] => private
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => private
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"private","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='private',is_unique='',date_updated=now(),sjson='[{\"fname\":\"private\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='private'published Array
(
[0] => Array
(
[fname] => published
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 5
[kname] => published
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"published","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=5,kname='published',is_unique='',date_updated=now(),sjson='[{\"fname\":\"published\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='5' and kname='published'sections_id Array
(
[0] => Array
(
[fname] => sections_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => sections_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sections_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='sections_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sections_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='sections_id'sections_top Array
(
[0] => Array
(
[fname] => sections_top
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => sections_top
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sections_top","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='sections_top',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sections_top\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='sections_top'temps_id Array
(
[0] => Array
(
[fname] => temps_id
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 5
[kname] => temps_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"temps_id","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=5,kname='temps_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"temps_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='5' and kname='temps_id'mtemps_id Array
(
[0] => Array
(
[fname] => mtemps_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => mtemps_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"mtemps_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='mtemps_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"mtemps_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='mtemps_id'arts_type Array
(
[0] => Array
(
[fname] => arts_type
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 5
[kname] => arts_type
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"arts_type","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=5,kname='arts_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"arts_type\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='5' and kname='arts_type'domains_id Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 5
[kname] => domains_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=5,kname='domains_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='5' and kname='domains_id'products_id Array
(
[0] => Array
(
[fname] => products_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => products_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"products_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='products_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='products_id'slug Array
(
[0] => Array
(
[fname] => slug
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => slug
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"slug","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='slug',is_unique='',date_updated=now(),sjson='[{\"fname\":\"slug\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='slug'metas_title Array
(
[0] => Array
(
[fname] => metas_title
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => metas_title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"metas_title","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='metas_title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"metas_title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='metas_title'social_image Array
(
[0] => Array
(
[fname] => social_image
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => social_image
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"social_image","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='social_image',is_unique='',date_updated=now(),sjson='[{\"fname\":\"social_image\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='social_image'versions_id Array
(
[0] => Array
(
[fname] => versions_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => versions_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"versions_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='versions_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"versions_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='versions_id'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='customers_id'from_art_id Array
(
[0] => Array
(
[fname] => from_art_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => from_art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_art_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='from_art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='from_art_id'for_art_id Array
(
[0] => Array
(
[fname] => for_art_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => for_art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"for_art_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='for_art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"for_art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='for_art_id'is_cache Array
(
[0] => Array
(
[fname] => is_cache
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 5
[kname] => is_cache
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_cache","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=5,kname='is_cache',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_cache\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='5' and kname='is_cache'gid Array
(
[0] => Array
(
[fname] => gid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => gid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"gid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='gid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"gid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='gid'options_id Array
(
[0] => Array
(
[fname] => options_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => options_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"options_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='options_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"options_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='options_id'geonameid Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => geonameid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='geonameid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='geonameid'select * from stables_keys where tables_id='5' and kid not in (28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51)SHOW INDEX FROM crons
PRIMARY crons_id
wid wid
wid run_func
wid run_class
active active
PRIMARY Array
(
[0] => Array
(
[fname] => crons_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 6
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"crons_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=6,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"crons_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='6' and kname='PRIMARY'wid Array
(
[0] => Array
(
[fname] => wid
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => run_func
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[2] => Array
(
[fname] => run_class
[ord] => 3
[collation] => A
[cardinality] =>
[is_unique] => 1
)
)
Array
(
[tables_id] => 6
[kname] => wid
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"wid","ord":"1","collation":"A","cardinality":null},{"fname":"run_func","ord":"2","collation":"A","cardinality":null,"is_unique":1},{"fname":"run_class","ord":"3","collation":"A","cardinality":null,"is_unique":1}]
)
update stables_keys set tables_id=6,kname='wid',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"wid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"run_func\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"run_class\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1}]' where tables_id='6' and kname='wid'active Array
(
[0] => Array
(
[fname] => active
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 6
[kname] => active
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"active","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=6,kname='active',is_unique='',date_updated=now(),sjson='[{\"fname\":\"active\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='6' and kname='active'select * from stables_keys where tables_id='6' and kid not in (52,61,57)SHOW INDEX FROM crons_logs
PRIMARY clogs_id
PRIMARY Array
(
[0] => Array
(
[fname] => clogs_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 7
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"clogs_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=7,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"clogs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='7' and kname='PRIMARY'select * from stables_keys where tables_id='7' and kid not in (62)SHOW INDEX FROM customers
PRIMARY customers_id
PRIMARY Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='PRIMARY'select * from stables_keys where tables_id='8' and kid not in (68)SHOW INDEX FROM photos
PRIMARY id
art_id art_id
art_id type
len size
products_id products_id
ord ord
main main
date_created date_created
svg svg
customers_id customers_id
published published
spaces_id spaces_id
hardscape_id hardscape_id
specialty_id specialty_id
processed processed
ptypes_id ptypes_id
gid gid
gid_pid gid_pid
oname oname
PRIMARY Array
(
[0] => Array
(
[fname] => id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='PRIMARY'art_id Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
[1] => Array
(
[fname] => type
[ord] => 2
[collation] => A
[cardinality] => 0
[is_unique] =>
)
)
Array
(
[tables_id] => 9
[kname] => art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":"0"},{"fname":"type","ord":"2","collation":"A","cardinality":"0","is_unique":false}]
)
update stables_keys set tables_id=9,kname='art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"},{\"fname\":\"type\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"0\",\"is_unique\":false}]' where tables_id='9' and kname='art_id'len Array
(
[0] => Array
(
[fname] => size
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"size","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='len'products_id Array
(
[0] => Array
(
[fname] => products_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => products_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"products_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='products_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='products_id'ord Array
(
[0] => Array
(
[fname] => ord
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => ord
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ord","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='ord',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ord\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='ord'main Array
(
[0] => Array
(
[fname] => main
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => main
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"main","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='main',is_unique='',date_updated=now(),sjson='[{\"fname\":\"main\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='main'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='date_created'svg Array
(
[0] => Array
(
[fname] => svg
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => svg
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"svg","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='svg',is_unique='',date_updated=now(),sjson='[{\"fname\":\"svg\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='svg'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='customers_id'published Array
(
[0] => Array
(
[fname] => published
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => published
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"published","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='published',is_unique='',date_updated=now(),sjson='[{\"fname\":\"published\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='published'spaces_id Array
(
[0] => Array
(
[fname] => spaces_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => spaces_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"spaces_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='spaces_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"spaces_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='spaces_id'hardscape_id Array
(
[0] => Array
(
[fname] => hardscape_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => hardscape_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"hardscape_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='hardscape_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"hardscape_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='hardscape_id'specialty_id Array
(
[0] => Array
(
[fname] => specialty_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => specialty_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"specialty_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='specialty_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"specialty_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='specialty_id'processed Array
(
[0] => Array
(
[fname] => processed
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => processed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"processed","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='processed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"processed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='processed'ptypes_id Array
(
[0] => Array
(
[fname] => ptypes_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => ptypes_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ptypes_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='ptypes_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ptypes_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='ptypes_id'gid Array
(
[0] => Array
(
[fname] => gid
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => gid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"gid","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='gid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"gid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='gid'gid_pid Array
(
[0] => Array
(
[fname] => gid_pid
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => gid_pid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"gid_pid","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='gid_pid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"gid_pid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='gid_pid'oname Array
(
[0] => Array
(
[fname] => oname
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => oname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"oname","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='oname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"oname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='oname'select * from stables_keys where tables_id='9' and kid not in (79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,263)SHOW INDEX FROM products
PRIMARY products_id
brands_id brands_id
conditions_id conditions_id
pcountries_id pcountries_id
PRIMARY Array
(
[0] => Array
(
[fname] => products_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 10
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"products_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=10,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='10' and kname='PRIMARY'brands_id Array
(
[0] => Array
(
[fname] => brands_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 10
[kname] => brands_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"brands_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=10,kname='brands_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"brands_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='10' and kname='brands_id'conditions_id Array
(
[0] => Array
(
[fname] => conditions_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 10
[kname] => conditions_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"conditions_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=10,kname='conditions_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"conditions_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='10' and kname='conditions_id'pcountries_id Array
(
[0] => Array
(
[fname] => pcountries_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 10
[kname] => pcountries_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"pcountries_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=10,kname='pcountries_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"pcountries_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='10' and kname='pcountries_id'select * from stables_keys where tables_id='10' and kid not in (96,395,396,397)SHOW INDEX FROM products_cats
PRIMARY pcats_id
PRIMARY Array
(
[0] => Array
(
[fname] => pcats_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 11
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"pcats_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=11,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"pcats_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='11' and kname='PRIMARY'select * from stables_keys where tables_id='11' and kid not in (125)SHOW INDEX FROM products_docs
PRIMARY id
PRIMARY Array
(
[0] => Array
(
[fname] => id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 12
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=12,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='12' and kname='PRIMARY'select * from stables_keys where tables_id='12' and kid not in (131)SHOW INDEX FROM sections
PRIMARY sections_id
inactive inactive
PRIMARY Array
(
[0] => Array
(
[fname] => sections_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 13
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"sections_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=13,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"sections_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='13' and kname='PRIMARY'inactive Array
(
[0] => Array
(
[fname] => inactive
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 13
[kname] => inactive
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"inactive","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=13,kname='inactive',is_unique='',date_updated=now(),sjson='[{\"fname\":\"inactive\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='13' and kname='inactive'select * from stables_keys where tables_id='13' and kid not in (136,398)SHOW INDEX FROM sessions
bid bid
bid Array
(
[0] => Array
(
[fname] => bid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 14
[kname] => bid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"bid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=14,kname='bid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"bid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='14' and kname='bid'select * from stables_keys where tables_id='14' and kid not in (360)SHOW INDEX FROM socials
PRIMARY socials_id
PRIMARY Array
(
[0] => Array
(
[fname] => socials_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 15
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"socials_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=15,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"socials_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='15' and kname='PRIMARY'select * from stables_keys where tables_id='15' and kid not in (169)SHOW INDEX FROM socials_history
PRIMARY shistory_id
PRIMARY Array
(
[0] => Array
(
[fname] => shistory_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 16
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"shistory_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=16,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"shistory_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='16' and kname='PRIMARY'select * from stables_keys where tables_id='16' and kid not in (181)SHOW INDEX FROM socials_notifications
PRIMARY notifications_id
PRIMARY Array
(
[0] => Array
(
[fname] => notifications_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 17
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"notifications_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=17,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"notifications_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='17' and kname='PRIMARY'select * from stables_keys where tables_id='17' and kid not in (188)SHOW INDEX FROM stables
PRIMARY tables_id
tname tname
title title
itype itype
sid sid
date_updated date_updated
date_created date_created
rows trows
avg_row_len avg_row_len
data_len data_len
data_free data_free
index_len index_len
auto_increment auto_increment
date_checked date_checked
file_size file_size
total_files max_files
date_last_archived date_last
table_type engine
data_len_last data_len_last
not_editable not_editable
not_zippable not_zippable
last_id last_primary
min_rows min_rows
date_removed date_removed
get_updates get_updates
PRIMARY Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='PRIMARY'tname Array
(
[0] => Array
(
[fname] => tname
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => tname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tname","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='tname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='tname'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='title'itype Array
(
[0] => Array
(
[fname] => itype
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 18
[kname] => itype
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"itype","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=18,kname='itype',is_unique='',date_updated=now(),sjson='[{\"fname\":\"itype\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='18' and kname='itype'sid Array
(
[0] => Array
(
[fname] => sid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 18
[kname] => sid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=18,kname='sid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='18' and kname='sid'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 16
)
)
Array
(
[tables_id] => 18
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"16"}]
)
update stables_keys set tables_id=18,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"16\"}]' where tables_id='18' and kname='date_updated'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 16
)
)
Array
(
[tables_id] => 18
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"16"}]
)
update stables_keys set tables_id=18,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"16\"}]' where tables_id='18' and kname='date_created'rows Array
(
[0] => Array
(
[fname] => trows
[ord] => 1
[collation] => A
[cardinality] => 16
)
)
Array
(
[tables_id] => 18
[kname] => rows
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"trows","ord":"1","collation":"A","cardinality":"16"}]
)
update stables_keys set tables_id=18,kname='rows',is_unique='',date_updated=now(),sjson='[{\"fname\":\"trows\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"16\"}]' where tables_id='18' and kname='rows'avg_row_len Array
(
[0] => Array
(
[fname] => avg_row_len
[ord] => 1
[collation] => A
[cardinality] => 16
)
)
Array
(
[tables_id] => 18
[kname] => avg_row_len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"avg_row_len","ord":"1","collation":"A","cardinality":"16"}]
)
update stables_keys set tables_id=18,kname='avg_row_len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"avg_row_len\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"16\"}]' where tables_id='18' and kname='avg_row_len'data_len Array
(
[0] => Array
(
[fname] => data_len
[ord] => 1
[collation] => A
[cardinality] => 16
)
)
Array
(
[tables_id] => 18
[kname] => data_len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"data_len","ord":"1","collation":"A","cardinality":"16"}]
)
update stables_keys set tables_id=18,kname='data_len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"data_len\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"16\"}]' where tables_id='18' and kname='data_len'data_free Array
(
[0] => Array
(
[fname] => data_free
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 18
[kname] => data_free
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"data_free","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=18,kname='data_free',is_unique='',date_updated=now(),sjson='[{\"fname\":\"data_free\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='18' and kname='data_free'index_len Array
(
[0] => Array
(
[fname] => index_len
[ord] => 1
[collation] => A
[cardinality] => 16
)
)
Array
(
[tables_id] => 18
[kname] => index_len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"index_len","ord":"1","collation":"A","cardinality":"16"}]
)
update stables_keys set tables_id=18,kname='index_len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"index_len\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"16\"}]' where tables_id='18' and kname='index_len'auto_increment Array
(
[0] => Array
(
[fname] => auto_increment
[ord] => 1
[collation] => A
[cardinality] => 16
)
)
Array
(
[tables_id] => 18
[kname] => auto_increment
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"auto_increment","ord":"1","collation":"A","cardinality":"16"}]
)
update stables_keys set tables_id=18,kname='auto_increment',is_unique='',date_updated=now(),sjson='[{\"fname\":\"auto_increment\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"16\"}]' where tables_id='18' and kname='auto_increment'date_checked Array
(
[0] => Array
(
[fname] => date_checked
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 18
[kname] => date_checked
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_checked","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=18,kname='date_checked',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_checked\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='18' and kname='date_checked'file_size Array
(
[0] => Array
(
[fname] => file_size
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => file_size
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"file_size","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='file_size',is_unique='',date_updated=now(),sjson='[{\"fname\":\"file_size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='file_size'total_files Array
(
[0] => Array
(
[fname] => max_files
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => total_files
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"max_files","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='total_files',is_unique='',date_updated=now(),sjson='[{\"fname\":\"max_files\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='total_files'date_last_archived Array
(
[0] => Array
(
[fname] => date_last
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => date_last_archived
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_last","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='date_last_archived',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_last\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='date_last_archived'table_type Array
(
[0] => Array
(
[fname] => engine
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 18
[kname] => table_type
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"engine","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=18,kname='table_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"engine\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='18' and kname='table_type'data_len_last Array
(
[0] => Array
(
[fname] => data_len_last
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => data_len_last
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"data_len_last","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='data_len_last',is_unique='',date_updated=now(),sjson='[{\"fname\":\"data_len_last\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='data_len_last'not_editable Array
(
[0] => Array
(
[fname] => not_editable
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => not_editable
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"not_editable","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='not_editable',is_unique='',date_updated=now(),sjson='[{\"fname\":\"not_editable\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='not_editable'not_zippable Array
(
[0] => Array
(
[fname] => not_zippable
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => not_zippable
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"not_zippable","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='not_zippable',is_unique='',date_updated=now(),sjson='[{\"fname\":\"not_zippable\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='not_zippable'last_id Array
(
[0] => Array
(
[fname] => last_primary
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => last_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"last_primary","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='last_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"last_primary\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='last_id'min_rows Array
(
[0] => Array
(
[fname] => min_rows
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => min_rows
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"min_rows","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='min_rows',is_unique='',date_updated=now(),sjson='[{\"fname\":\"min_rows\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='min_rows'date_removed Array
(
[0] => Array
(
[fname] => date_removed
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => date_removed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_removed","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='date_removed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_removed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='date_removed'get_updates Array
(
[0] => Array
(
[fname] => get_updates
[ord] => 1
[collation] => A
[cardinality] => 32
)
)
Array
(
[tables_id] => 18
[kname] => get_updates
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"get_updates","ord":"1","collation":"A","cardinality":"32"}]
)
update stables_keys set tables_id=18,kname='get_updates',is_unique='',date_updated=now(),sjson='[{\"fname\":\"get_updates\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"32\"}]' where tables_id='18' and kname='get_updates'select * from stables_keys where tables_id='18' and kid not in (191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215)SHOW INDEX FROM stables_fields
PRIMARY fid
tables_id_2 tables_id
tables_id_2 fname
tables_id tables_id
fname fname
ftype ftype
title title
types_id ftypes_id
date_created date_updated
fkey fkey
auto_increment auto_increment
fdefault fdefault
PRIMARY Array
(
[0] => Array
(
[fname] => fid
[ord] => 1
[collation] => A
[cardinality] => 597
)
)
Array
(
[tables_id] => 19
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"fid","ord":"1","collation":"A","cardinality":"597"}]
)
update stables_keys set tables_id=19,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"fid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"597\"}]' where tables_id='19' and kname='PRIMARY'tables_id_2 Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => fname
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] => 1
)
)
Array
(
[tables_id] => 19
[kname] => tables_id_2
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":null},{"fname":"fname","ord":"2","collation":"A","cardinality":null,"is_unique":1}]
)
update stables_keys set tables_id=19,kname='tables_id_2',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"fname\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1}]' where tables_id='19' and kname='tables_id_2'tables_id Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] => 31
)
)
Array
(
[tables_id] => 19
[kname] => tables_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"31"}]
)
update stables_keys set tables_id=19,kname='tables_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"31\"}]' where tables_id='19' and kname='tables_id'fname Array
(
[0] => Array
(
[fname] => fname
[ord] => 1
[collation] => A
[cardinality] => 298
)
)
Array
(
[tables_id] => 19
[kname] => fname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"fname","ord":"1","collation":"A","cardinality":"298"}]
)
update stables_keys set tables_id=19,kname='fname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"fname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"298\"}]' where tables_id='19' and kname='fname'ftype Array
(
[0] => Array
(
[fname] => ftype
[ord] => 1
[collation] => A
[cardinality] => 54
)
)
Array
(
[tables_id] => 19
[kname] => ftype
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ftype","ord":"1","collation":"A","cardinality":"54"}]
)
update stables_keys set tables_id=19,kname='ftype',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ftype\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"54\"}]' where tables_id='19' and kname='ftype'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] => 597
)
)
Array
(
[tables_id] => 19
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":"597"}]
)
update stables_keys set tables_id=19,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"597\"}]' where tables_id='19' and kname='title'types_id Array
(
[0] => Array
(
[fname] => ftypes_id
[ord] => 1
[collation] => A
[cardinality] => 13
)
)
Array
(
[tables_id] => 19
[kname] => types_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ftypes_id","ord":"1","collation":"A","cardinality":"13"}]
)
update stables_keys set tables_id=19,kname='types_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ftypes_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"13\"}]' where tables_id='19' and kname='types_id'date_created Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 19
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=19,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='19' and kname='date_created'fkey Array
(
[0] => Array
(
[fname] => fkey
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 19
[kname] => fkey
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"fkey","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=19,kname='fkey',is_unique='',date_updated=now(),sjson='[{\"fname\":\"fkey\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='19' and kname='fkey'auto_increment Array
(
[0] => Array
(
[fname] => auto_increment
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 19
[kname] => auto_increment
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"auto_increment","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=19,kname='auto_increment',is_unique='',date_updated=now(),sjson='[{\"fname\":\"auto_increment\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='19' and kname='auto_increment'fdefault Array
(
[0] => Array
(
[fname] => fdefault
[ord] => 1
[collation] => A
[cardinality] => 5
)
)
Array
(
[tables_id] => 19
[kname] => fdefault
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"fdefault","ord":"1","collation":"A","cardinality":"5"}]
)
update stables_keys set tables_id=19,kname='fdefault',is_unique='',date_updated=now(),sjson='[{\"fname\":\"fdefault\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5\"}]' where tables_id='19' and kname='fdefault'select * from stables_keys where tables_id='19' and kid not in (216,217,218,219,220,221,222,223,224,225,226)SHOW INDEX FROM stables_keys
PRIMARY kid
tables_id_2 tables_id
tables_id_2 kname
kname kname
is_unique is_unique
date_updated date_updated
tables_id tables_id
PRIMARY Array
(
[0] => Array
(
[fname] => kid
[ord] => 1
[collation] => A
[cardinality] => 398
)
)
Array
(
[tables_id] => 20
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"kid","ord":"1","collation":"A","cardinality":"398"}]
)
update stables_keys set tables_id=20,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"kid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"398\"}]' where tables_id='20' and kname='PRIMARY'tables_id_2 Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => kname
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] => 1
)
)
Array
(
[tables_id] => 20
[kname] => tables_id_2
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":null},{"fname":"kname","ord":"2","collation":"A","cardinality":null,"is_unique":1}]
)
update stables_keys set tables_id=20,kname='tables_id_2',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"kname\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1}]' where tables_id='20' and kname='tables_id_2'kname Array
(
[0] => Array
(
[fname] => kname
[ord] => 1
[collation] => A
[cardinality] => 199
)
)
Array
(
[tables_id] => 20
[kname] => kname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"kname","ord":"1","collation":"A","cardinality":"199"}]
)
update stables_keys set tables_id=20,kname='kname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"kname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"199\"}]' where tables_id='20' and kname='kname'is_unique Array
(
[0] => Array
(
[fname] => is_unique
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 20
[kname] => is_unique
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_unique","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=20,kname='is_unique',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_unique\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='20' and kname='is_unique'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 20
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=20,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='20' and kname='date_updated'tables_id Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] => 33
)
)
Array
(
[tables_id] => 20
[kname] => tables_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"33"}]
)
update stables_keys set tables_id=20,kname='tables_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"33\"}]' where tables_id='20' and kname='tables_id'select * from stables_keys where tables_id='20' and kid not in (227,228,229,230,231,232)SHOW INDEX FROM updates
PRIMARY updates_id
wid wid
fid_value fid_value
errors_id errors_id
date_created date_created
date_updated date_updated
crons_id clogs_id
PRIMARY Array
(
[0] => Array
(
[fname] => updates_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 21
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"updates_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=21,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"updates_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='21' and kname='PRIMARY'wid Array
(
[0] => Array
(
[fname] => wid
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 21
[kname] => wid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"wid","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=21,kname='wid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"wid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='21' and kname='wid'fid_value Array
(
[0] => Array
(
[fname] => fid_value
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 21
[kname] => fid_value
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"fid_value","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=21,kname='fid_value',is_unique='',date_updated=now(),sjson='[{\"fname\":\"fid_value\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='21' and kname='fid_value'errors_id Array
(
[0] => Array
(
[fname] => errors_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 21
[kname] => errors_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"errors_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=21,kname='errors_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"errors_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='21' and kname='errors_id'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 21
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=21,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='21' and kname='date_created'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 21
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=21,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='21' and kname='date_updated'crons_id Array
(
[0] => Array
(
[fname] => clogs_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 21
[kname] => crons_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"clogs_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=21,kname='crons_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"clogs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='21' and kname='crons_id'select * from stables_keys where tables_id='21' and kid not in (233,234,235,236,237,238,239)SHOW INDEX FROM widgets
PRIMARY wid
php_file php_file
short_code action
wid_type wid_type
title title
from_wid from_wid
is_cache is_cache
date_updated date_updated
PRIMARY Array
(
[0] => Array
(
[fname] => wid
[ord] => 1
[collation] => A
[cardinality] => 24
)
)
Array
(
[tables_id] => 22
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"wid","ord":"1","collation":"A","cardinality":"24"}]
)
update stables_keys set tables_id=22,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"wid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"24\"}]' where tables_id='22' and kname='PRIMARY'php_file Array
(
[0] => Array
(
[fname] => php_file
[ord] => 1
[collation] => A
[cardinality] => 24
)
)
Array
(
[tables_id] => 22
[kname] => php_file
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"php_file","ord":"1","collation":"A","cardinality":"24"}]
)
update stables_keys set tables_id=22,kname='php_file',is_unique='',date_updated=now(),sjson='[{\"fname\":\"php_file\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"24\"}]' where tables_id='22' and kname='php_file'short_code Array
(
[0] => Array
(
[fname] => action
[ord] => 1
[collation] => A
[cardinality] => 24
)
)
Array
(
[tables_id] => 22
[kname] => short_code
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"action","ord":"1","collation":"A","cardinality":"24"}]
)
update stables_keys set tables_id=22,kname='short_code',is_unique='',date_updated=now(),sjson='[{\"fname\":\"action\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"24\"}]' where tables_id='22' and kname='short_code'wid_type Array
(
[0] => Array
(
[fname] => wid_type
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 22
[kname] => wid_type
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"wid_type","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=22,kname='wid_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"wid_type\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='22' and kname='wid_type'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] => 24
)
)
Array
(
[tables_id] => 22
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":"24"}]
)
update stables_keys set tables_id=22,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"24\"}]' where tables_id='22' and kname='title'from_wid Array
(
[0] => Array
(
[fname] => from_wid
[ord] => 1
[collation] => A
[cardinality] => 24
)
)
Array
(
[tables_id] => 22
[kname] => from_wid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_wid","ord":"1","collation":"A","cardinality":"24"}]
)
update stables_keys set tables_id=22,kname='from_wid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_wid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"24\"}]' where tables_id='22' and kname='from_wid'is_cache Array
(
[0] => Array
(
[fname] => is_cache
[ord] => 1
[collation] => A
[cardinality] => 24
)
)
Array
(
[tables_id] => 22
[kname] => is_cache
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_cache","ord":"1","collation":"A","cardinality":"24"}]
)
update stables_keys set tables_id=22,kname='is_cache',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_cache\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"24\"}]' where tables_id='22' and kname='is_cache'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 24
)
)
Array
(
[tables_id] => 22
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"24"}]
)
update stables_keys set tables_id=22,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"24\"}]' where tables_id='22' and kname='date_updated'select * from stables_keys where tables_id='22' and kid not in (240,241,242,243,244,245,246,247)SHOW INDEX FROM wmessages
PRIMARY id
dayphone dayphone
dayphone idspec1
dayphone idspec2
dayphone date_created
ip ip
news news
viewed viewed
removed removed
referer referer
budget_min budget
kids kids
kids pets
landing_id landing_id
updated updated
date_updated date_updated
best_time best_time
time_frame time_frame
leads_id leads_id
PRIMARY Array
(
[0] => Array
(
[fname] => id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 23
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=23,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='23' and kname='PRIMARY'dayphone Array
(
[0] => Array
(
[fname] => dayphone
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => idspec1
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] =>
)
[2] => Array
(
[fname] => idspec2
[ord] => 3
[collation] => A
[cardinality] =>
[is_unique] =>
)
[3] => Array
(
[fname] => date_created
[ord] => 4
[collation] => A
[cardinality] =>
[is_unique] =>
)
)
Array
(
[tables_id] => 23
[kname] => dayphone
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"dayphone","ord":"1","collation":"A","cardinality":null},{"fname":"idspec1","ord":"2","collation":"A","cardinality":null,"is_unique":false},{"fname":"idspec2","ord":"3","collation":"A","cardinality":null,"is_unique":false},{"fname":"date_created","ord":"4","collation":"A","cardinality":null,"is_unique":false}]
)
update stables_keys set tables_id=23,kname='dayphone',is_unique='',date_updated=now(),sjson='[{\"fname\":\"dayphone\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"idspec1\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":false},{\"fname\":\"idspec2\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":false},{\"fname\":\"date_created\",\"ord\":\"4\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":false}]' where tables_id='23' and kname='dayphone'ip Array
(
[0] => Array
(
[fname] => ip
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => ip
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ip","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='ip',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ip\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='ip'news Array
(
[0] => Array
(
[fname] => news
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => news
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"news","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='news',is_unique='',date_updated=now(),sjson='[{\"fname\":\"news\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='news'viewed Array
(
[0] => Array
(
[fname] => viewed
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => viewed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"viewed","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='viewed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"viewed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='viewed'removed Array
(
[0] => Array
(
[fname] => removed
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => removed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"removed","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='removed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"removed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='removed'referer Array
(
[0] => Array
(
[fname] => referer
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => referer
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"referer","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='referer',is_unique='',date_updated=now(),sjson='[{\"fname\":\"referer\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='referer'budget_min Array
(
[0] => Array
(
[fname] => budget
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => budget_min
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"budget","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='budget_min',is_unique='',date_updated=now(),sjson='[{\"fname\":\"budget\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='budget_min'kids Array
(
[0] => Array
(
[fname] => kids
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => pets
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] =>
)
)
Array
(
[tables_id] => 23
[kname] => kids
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"kids","ord":"1","collation":"A","cardinality":null},{"fname":"pets","ord":"2","collation":"A","cardinality":null,"is_unique":false}]
)
update stables_keys set tables_id=23,kname='kids',is_unique='',date_updated=now(),sjson='[{\"fname\":\"kids\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"pets\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":false}]' where tables_id='23' and kname='kids'landing_id Array
(
[0] => Array
(
[fname] => landing_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => landing_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"landing_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='landing_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"landing_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='landing_id'updated Array
(
[0] => Array
(
[fname] => updated
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"updated","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='updated'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='date_updated'best_time Array
(
[0] => Array
(
[fname] => best_time
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => best_time
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"best_time","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='best_time',is_unique='',date_updated=now(),sjson='[{\"fname\":\"best_time\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='best_time'time_frame Array
(
[0] => Array
(
[fname] => time_frame
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => time_frame
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"time_frame","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='time_frame',is_unique='',date_updated=now(),sjson='[{\"fname\":\"time_frame\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='time_frame'leads_id Array
(
[0] => Array
(
[fname] => leads_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 23
[kname] => leads_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"leads_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=23,kname='leads_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"leads_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='23' and kname='leads_id'select * from stables_keys where tables_id='23' and kid not in (248,249,250,251,252,253,254,255,256,257,258,259,260,261,262)SHOW INDEX FROM A_US
PRIMARY geonameid
geonameid_latlon geonameid
geonameid_latlon latitude
geonameid_latlon longitude
asciiname asciiname
asciiname name
asciiname feature_class
asciiname_3 asciiname
name asciiname
name name
name feature_class
name admin1_code
name admin2_code
name geonameid
name latitude
name longitude
name timezone
expression expression
html slug
use search
class-search feature_class
class-search search
class-search population
Population population
checked checked
indexed notindexed
art_id art_id
popular popular
pimage pimage
PRIMARY Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 246244
)
)
Array
(
[tables_id] => 24
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"246244"}]
)
update stables_keys set tables_id=24,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"246244\"}]' where tables_id='24' and kname='PRIMARY'geonameid_latlon Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => latitude
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[2] => Array
(
[fname] => longitude
[ord] => 3
[collation] => A
[cardinality] => 246244
[is_unique] => 1
)
)
Array
(
[tables_id] => 24
[kname] => geonameid_latlon
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":null},{"fname":"latitude","ord":"2","collation":"A","cardinality":null,"is_unique":1},{"fname":"longitude","ord":"3","collation":"A","cardinality":"246244","is_unique":1}]
)
update stables_keys set tables_id=24,kname='geonameid_latlon',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"latitude\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"longitude\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":\"246244\",\"is_unique\":1}]' where tables_id='24' and kname='geonameid_latlon'asciiname Array
(
[0] => Array
(
[fname] => asciiname
[ord] => 1
[collation] => A
[cardinality] => 123122
)
[1] => Array
(
[fname] => name
[ord] => 2
[collation] => A
[cardinality] => 123122
[is_unique] =>
)
[2] => Array
(
[fname] => feature_class
[ord] => 3
[collation] => A
[cardinality] => 123122
[is_unique] =>
)
)
Array
(
[tables_id] => 24
[kname] => asciiname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"asciiname","ord":"1","collation":"A","cardinality":"123122"},{"fname":"name","ord":"2","collation":"A","cardinality":"123122","is_unique":false},{"fname":"feature_class","ord":"3","collation":"A","cardinality":"123122","is_unique":false}]
)
update stables_keys set tables_id=24,kname='asciiname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"asciiname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"123122\"},{\"fname\":\"name\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"123122\",\"is_unique\":false},{\"fname\":\"feature_class\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":\"123122\",\"is_unique\":false}]' where tables_id='24' and kname='asciiname'asciiname_3 Array
(
[0] => Array
(
[fname] => asciiname
[ord] => 1
[collation] => A
[cardinality] => 123122
)
)
Array
(
[tables_id] => 24
[kname] => asciiname_3
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"asciiname","ord":"1","collation":"A","cardinality":"123122"}]
)
update stables_keys set tables_id=24,kname='asciiname_3',is_unique='',date_updated=now(),sjson='[{\"fname\":\"asciiname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"123122\"}]' where tables_id='24' and kname='asciiname_3'name Array
(
[0] => Array
(
[fname] => asciiname
[ord] => 1
[collation] => A
[cardinality] => 123122
)
[1] => Array
(
[fname] => name
[ord] => 2
[collation] => A
[cardinality] => 123122
[is_unique] =>
)
[2] => Array
(
[fname] => feature_class
[ord] => 3
[collation] => A
[cardinality] => 123122
[is_unique] =>
)
[3] => Array
(
[fname] => admin1_code
[ord] => 4
[collation] => A
[cardinality] => 246244
[is_unique] =>
)
[4] => Array
(
[fname] => admin2_code
[ord] => 5
[collation] => A
[cardinality] => 246244
[is_unique] =>
)
[5] => Array
(
[fname] => geonameid
[ord] => 6
[collation] => A
[cardinality] => 246244
[is_unique] =>
)
[6] => Array
(
[fname] => latitude
[ord] => 7
[collation] => A
[cardinality] => 246244
[is_unique] =>
)
[7] => Array
(
[fname] => longitude
[ord] => 8
[collation] => A
[cardinality] => 246244
[is_unique] =>
)
[8] => Array
(
[fname] => timezone
[ord] => 9
[collation] => A
[cardinality] => 246244
[is_unique] =>
)
)
Array
(
[tables_id] => 24
[kname] => name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"asciiname","ord":"1","collation":"A","cardinality":"123122"},{"fname":"name","ord":"2","collation":"A","cardinality":"123122","is_unique":false},{"fname":"feature_class","ord":"3","collation":"A","cardinality":"123122","is_unique":false},{"fname":"admin1_code","ord":"4","collation":"A","cardinality":"246244","is_unique":false},{"fname":"admin2_code","ord":"5","collation":"A","cardinality":"246244","is_unique":false},{"fname":"geonameid","ord":"6","collation":"A","cardinality":"246244","is_unique":false},{"fname":"latitude","ord":"7","collation":"A","cardinality":"246244","is_unique":false},{"fname":"longitude","ord":"8","collation":"A","cardinality":"246244","is_unique":false},{"fname":"timezone","ord":"9","collation":"A","cardinality":"246244","is_unique":false}]
)
update stables_keys set tables_id=24,kname='name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"asciiname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"123122\"},{\"fname\":\"name\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"123122\",\"is_unique\":false},{\"fname\":\"feature_class\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":\"123122\",\"is_unique\":false},{\"fname\":\"admin1_code\",\"ord\":\"4\",\"collation\":\"A\",\"cardinality\":\"246244\",\"is_unique\":false},{\"fname\":\"admin2_code\",\"ord\":\"5\",\"collation\":\"A\",\"cardinality\":\"246244\",\"is_unique\":false},{\"fname\":\"geonameid\",\"ord\":\"6\",\"collation\":\"A\",\"cardinality\":\"246244\",\"is_unique\":false},{\"fname\":\"latitude\",\"ord\":\"7\",\"collation\":\"A\",\"cardinality\":\"246244\",\"is_unique\":false},{\"fname\":\"longitude\",\"ord\":\"8\",\"collation\":\"A\",\"cardinality\":\"246244\",\"is_unique\":false},{\"fname\":\"timezone\",\"ord\":\"9\",\"collation\":\"A\",\"cardinality\":\"246244\",\"is_unique\":false}]' where tables_id='24' and kname='name'expression Array
(
[0] => Array
(
[fname] => expression
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 24
[kname] => expression
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"expression","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=24,kname='expression',is_unique='',date_updated=now(),sjson='[{\"fname\":\"expression\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='24' and kname='expression'html Array
(
[0] => Array
(
[fname] => slug
[ord] => 1
[collation] => A
[cardinality] => 246244
)
)
Array
(
[tables_id] => 24
[kname] => html
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"slug","ord":"1","collation":"A","cardinality":"246244"}]
)
update stables_keys set tables_id=24,kname='html',is_unique='',date_updated=now(),sjson='[{\"fname\":\"slug\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"246244\"}]' where tables_id='24' and kname='html'use Array
(
[0] => Array
(
[fname] => search
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 24
[kname] => use
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"search","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=24,kname='use',is_unique='',date_updated=now(),sjson='[{\"fname\":\"search\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='24' and kname='use'class-search Array
(
[0] => Array
(
[fname] => feature_class
[ord] => 1
[collation] => A
[cardinality] => 2
)
[1] => Array
(
[fname] => search
[ord] => 2
[collation] => A
[cardinality] => 4
[is_unique] =>
)
[2] => Array
(
[fname] => population
[ord] => 3
[collation] => A
[cardinality] => 20520
[is_unique] =>
)
)
Array
(
[tables_id] => 24
[kname] => class-search
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"feature_class","ord":"1","collation":"A","cardinality":"2"},{"fname":"search","ord":"2","collation":"A","cardinality":"4","is_unique":false},{"fname":"population","ord":"3","collation":"A","cardinality":"20520","is_unique":false}]
)
update stables_keys set tables_id=24,kname='class-search',is_unique='',date_updated=now(),sjson='[{\"fname\":\"feature_class\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"},{\"fname\":\"search\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"4\",\"is_unique\":false},{\"fname\":\"population\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":\"20520\",\"is_unique\":false}]' where tables_id='24' and kname='class-search'Population Array
(
[0] => Array
(
[fname] => population
[ord] => 1
[collation] => A
[cardinality] => 12960
)
)
Array
(
[tables_id] => 24
[kname] => Population
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"population","ord":"1","collation":"A","cardinality":"12960"}]
)
update stables_keys set tables_id=24,kname='Population',is_unique='',date_updated=now(),sjson='[{\"fname\":\"population\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12960\"}]' where tables_id='24' and kname='Population'checked Array
(
[0] => Array
(
[fname] => checked
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 24
[kname] => checked
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"checked","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=24,kname='checked',is_unique='',date_updated=now(),sjson='[{\"fname\":\"checked\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='24' and kname='checked'indexed Array
(
[0] => Array
(
[fname] => notindexed
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 24
[kname] => indexed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"notindexed","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=24,kname='indexed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"notindexed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='24' and kname='indexed'art_id Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 24
[kname] => art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=24,kname='art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='24' and kname='art_id'popular Array
(
[0] => Array
(
[fname] => popular
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 24
[kname] => popular
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"popular","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=24,kname='popular',is_unique='',date_updated=now(),sjson='[{\"fname\":\"popular\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='24' and kname='popular'pimage Array
(
[0] => Array
(
[fname] => pimage
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 24
[kname] => pimage
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"pimage","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=24,kname='pimage',is_unique='',date_updated=now(),sjson='[{\"fname\":\"pimage\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='24' and kname='pimage'select * from stables_keys where tables_id='24' and kid not in (265,266,267,268,269,270,271,272,273,274,275,276,277,278,279)SHOW INDEX FROM a_cities
PRIMARY geonameid
geonameid geonameid
geonameid country
geonameid country_full
geonameid asciiname
geonameid county
geonameid state_abbr
geonameid latitude
geonameid longitude
geonameid timezone
asciiname_3 asciiname
name asciiname
name name
name feature_class
name admin1_code
name admin2_code
name geonameid
name latitude
name longitude
name timezone
asciiname asciiname
asciiname name
asciiname feature_class
zone_id zone_id
country country
country_full country_full
city city
search_short search_short
search_full search_full
state state
state_abbr state_abbr
county county
slug slug
PRIMARY Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 30095
)
)
Array
(
[tables_id] => 25
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"30095"}]
)
update stables_keys set tables_id=25,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"30095\"}]' where tables_id='25' and kname='PRIMARY'geonameid Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => country
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[2] => Array
(
[fname] => country_full
[ord] => 3
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[3] => Array
(
[fname] => asciiname
[ord] => 4
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[4] => Array
(
[fname] => county
[ord] => 5
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[5] => Array
(
[fname] => state_abbr
[ord] => 6
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[6] => Array
(
[fname] => latitude
[ord] => 7
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[7] => Array
(
[fname] => longitude
[ord] => 8
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[8] => Array
(
[fname] => timezone
[ord] => 9
[collation] => A
[cardinality] =>
[is_unique] => 1
)
)
Array
(
[tables_id] => 25
[kname] => geonameid
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":null},{"fname":"country","ord":"2","collation":"A","cardinality":null,"is_unique":1},{"fname":"country_full","ord":"3","collation":"A","cardinality":null,"is_unique":1},{"fname":"asciiname","ord":"4","collation":"A","cardinality":null,"is_unique":1},{"fname":"county","ord":"5","collation":"A","cardinality":null,"is_unique":1},{"fname":"state_abbr","ord":"6","collation":"A","cardinality":null,"is_unique":1},{"fname":"latitude","ord":"7","collation":"A","cardinality":null,"is_unique":1},{"fname":"longitude","ord":"8","collation":"A","cardinality":null,"is_unique":1},{"fname":"timezone","ord":"9","collation":"A","cardinality":null,"is_unique":1}]
)
update stables_keys set tables_id=25,kname='geonameid',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"country\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"country_full\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"asciiname\",\"ord\":\"4\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"county\",\"ord\":\"5\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"state_abbr\",\"ord\":\"6\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"latitude\",\"ord\":\"7\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"longitude\",\"ord\":\"8\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"timezone\",\"ord\":\"9\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1}]' where tables_id='25' and kname='geonameid'asciiname_3 Array
(
[0] => Array
(
[fname] => asciiname
[ord] => 1
[collation] => A
[cardinality] => 15047
)
)
Array
(
[tables_id] => 25
[kname] => asciiname_3
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"asciiname","ord":"1","collation":"A","cardinality":"15047"}]
)
update stables_keys set tables_id=25,kname='asciiname_3',is_unique='',date_updated=now(),sjson='[{\"fname\":\"asciiname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15047\"}]' where tables_id='25' and kname='asciiname_3'name Array
(
[0] => Array
(
[fname] => asciiname
[ord] => 1
[collation] => A
[cardinality] => 15047
)
[1] => Array
(
[fname] => name
[ord] => 2
[collation] => A
[cardinality] => 15047
[is_unique] =>
)
[2] => Array
(
[fname] => feature_class
[ord] => 3
[collation] => A
[cardinality] => 15047
[is_unique] =>
)
[3] => Array
(
[fname] => admin1_code
[ord] => 4
[collation] => A
[cardinality] => 30095
[is_unique] =>
)
[4] => Array
(
[fname] => admin2_code
[ord] => 5
[collation] => A
[cardinality] => 30095
[is_unique] =>
)
[5] => Array
(
[fname] => geonameid
[ord] => 6
[collation] => A
[cardinality] => 30095
[is_unique] =>
)
[6] => Array
(
[fname] => latitude
[ord] => 7
[collation] => A
[cardinality] => 30095
[is_unique] =>
)
[7] => Array
(
[fname] => longitude
[ord] => 8
[collation] => A
[cardinality] => 30095
[is_unique] =>
)
[8] => Array
(
[fname] => timezone
[ord] => 9
[collation] => A
[cardinality] => 30095
[is_unique] =>
)
)
Array
(
[tables_id] => 25
[kname] => name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"asciiname","ord":"1","collation":"A","cardinality":"15047"},{"fname":"name","ord":"2","collation":"A","cardinality":"15047","is_unique":false},{"fname":"feature_class","ord":"3","collation":"A","cardinality":"15047","is_unique":false},{"fname":"admin1_code","ord":"4","collation":"A","cardinality":"30095","is_unique":false},{"fname":"admin2_code","ord":"5","collation":"A","cardinality":"30095","is_unique":false},{"fname":"geonameid","ord":"6","collation":"A","cardinality":"30095","is_unique":false},{"fname":"latitude","ord":"7","collation":"A","cardinality":"30095","is_unique":false},{"fname":"longitude","ord":"8","collation":"A","cardinality":"30095","is_unique":false},{"fname":"timezone","ord":"9","collation":"A","cardinality":"30095","is_unique":false}]
)
update stables_keys set tables_id=25,kname='name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"asciiname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15047\"},{\"fname\":\"name\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"15047\",\"is_unique\":false},{\"fname\":\"feature_class\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":\"15047\",\"is_unique\":false},{\"fname\":\"admin1_code\",\"ord\":\"4\",\"collation\":\"A\",\"cardinality\":\"30095\",\"is_unique\":false},{\"fname\":\"admin2_code\",\"ord\":\"5\",\"collation\":\"A\",\"cardinality\":\"30095\",\"is_unique\":false},{\"fname\":\"geonameid\",\"ord\":\"6\",\"collation\":\"A\",\"cardinality\":\"30095\",\"is_unique\":false},{\"fname\":\"latitude\",\"ord\":\"7\",\"collation\":\"A\",\"cardinality\":\"30095\",\"is_unique\":false},{\"fname\":\"longitude\",\"ord\":\"8\",\"collation\":\"A\",\"cardinality\":\"30095\",\"is_unique\":false},{\"fname\":\"timezone\",\"ord\":\"9\",\"collation\":\"A\",\"cardinality\":\"30095\",\"is_unique\":false}]' where tables_id='25' and kname='name'asciiname Array
(
[0] => Array
(
[fname] => asciiname
[ord] => 1
[collation] => A
[cardinality] => 15047
)
[1] => Array
(
[fname] => name
[ord] => 2
[collation] => A
[cardinality] => 15047
[is_unique] =>
)
[2] => Array
(
[fname] => feature_class
[ord] => 3
[collation] => A
[cardinality] => 15047
[is_unique] =>
)
)
Array
(
[tables_id] => 25
[kname] => asciiname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"asciiname","ord":"1","collation":"A","cardinality":"15047"},{"fname":"name","ord":"2","collation":"A","cardinality":"15047","is_unique":false},{"fname":"feature_class","ord":"3","collation":"A","cardinality":"15047","is_unique":false}]
)
update stables_keys set tables_id=25,kname='asciiname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"asciiname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15047\"},{\"fname\":\"name\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"15047\",\"is_unique\":false},{\"fname\":\"feature_class\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":\"15047\",\"is_unique\":false}]' where tables_id='25' and kname='asciiname'zone_id Array
(
[0] => Array
(
[fname] => zone_id
[ord] => 1
[collation] => A
[cardinality] => 30
)
)
Array
(
[tables_id] => 25
[kname] => zone_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"zone_id","ord":"1","collation":"A","cardinality":"30"}]
)
update stables_keys set tables_id=25,kname='zone_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"zone_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"30\"}]' where tables_id='25' and kname='zone_id'country Array
(
[0] => Array
(
[fname] => country
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 25
[kname] => country
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"country","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=25,kname='country',is_unique='',date_updated=now(),sjson='[{\"fname\":\"country\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='25' and kname='country'country_full Array
(
[0] => Array
(
[fname] => country_full
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 25
[kname] => country_full
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"country_full","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=25,kname='country_full',is_unique='',date_updated=now(),sjson='[{\"fname\":\"country_full\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='25' and kname='country_full'city Array
(
[0] => Array
(
[fname] => city
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 25
[kname] => city
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"city","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=25,kname='city',is_unique='',date_updated=now(),sjson='[{\"fname\":\"city\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='25' and kname='city'search_short Array
(
[0] => Array
(
[fname] => search_short
[ord] => 1
[collation] => A
[cardinality] => 30095
)
)
Array
(
[tables_id] => 25
[kname] => search_short
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"search_short","ord":"1","collation":"A","cardinality":"30095"}]
)
update stables_keys set tables_id=25,kname='search_short',is_unique='',date_updated=now(),sjson='[{\"fname\":\"search_short\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"30095\"}]' where tables_id='25' and kname='search_short'search_full Array
(
[0] => Array
(
[fname] => search_full
[ord] => 1
[collation] => A
[cardinality] => 30095
)
)
Array
(
[tables_id] => 25
[kname] => search_full
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"search_full","ord":"1","collation":"A","cardinality":"30095"}]
)
update stables_keys set tables_id=25,kname='search_full',is_unique='',date_updated=now(),sjson='[{\"fname\":\"search_full\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"30095\"}]' where tables_id='25' and kname='search_full'state Array
(
[0] => Array
(
[fname] => state
[ord] => 1
[collation] => A
[cardinality] => 51
)
)
Array
(
[tables_id] => 25
[kname] => state
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"state","ord":"1","collation":"A","cardinality":"51"}]
)
update stables_keys set tables_id=25,kname='state',is_unique='',date_updated=now(),sjson='[{\"fname\":\"state\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"51\"}]' where tables_id='25' and kname='state'state_abbr Array
(
[0] => Array
(
[fname] => state_abbr
[ord] => 1
[collation] => A
[cardinality] => 51
)
)
Array
(
[tables_id] => 25
[kname] => state_abbr
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"state_abbr","ord":"1","collation":"A","cardinality":"51"}]
)
update stables_keys set tables_id=25,kname='state_abbr',is_unique='',date_updated=now(),sjson='[{\"fname\":\"state_abbr\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"51\"}]' where tables_id='25' and kname='state_abbr'county Array
(
[0] => Array
(
[fname] => county
[ord] => 1
[collation] => A
[cardinality] => 1880
)
)
Array
(
[tables_id] => 25
[kname] => county
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"county","ord":"1","collation":"A","cardinality":"1880"}]
)
update stables_keys set tables_id=25,kname='county',is_unique='',date_updated=now(),sjson='[{\"fname\":\"county\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1880\"}]' where tables_id='25' and kname='county'slug Array
(
[0] => Array
(
[fname] => slug
[ord] => 1
[collation] => A
[cardinality] => 30095
)
)
Array
(
[tables_id] => 25
[kname] => slug
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"slug","ord":"1","collation":"A","cardinality":"30095"}]
)
update stables_keys set tables_id=25,kname='slug',is_unique='',date_updated=now(),sjson='[{\"fname\":\"slug\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"30095\"}]' where tables_id='25' and kname='slug'select * from stables_keys where tables_id='25' and kid not in (347,280,348,286,349,350,351,352,353,354,281,282,283,355,284)
No Table locations
update stables set date_removed=now() where tables_id='26'
No Table sessions_sf
update stables set date_removed=now() where tables_id='27'
No Table wmessages_OLD
update stables set date_removed=now() where tables_id='28'SHOW INDEX FROM domains
PRIMARY domains_id
url url
geonameid geonameid
last_updated last_updated
locations_id locations_id
active active
auth_key auth_key
host_name host
token token
send_updates send_updates
programs_id programs_id
origin origin
update_products update_products
subs_id subs_id
apis_id apis_id
PRIMARY Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='PRIMARY'url Array
(
[0] => Array
(
[fname] => url
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => url
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"url","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='url',is_unique='',date_updated=now(),sjson='[{\"fname\":\"url\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='url'geonameid Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => geonameid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='geonameid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='geonameid'last_updated Array
(
[0] => Array
(
[fname] => last_updated
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => last_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"last_updated","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='last_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"last_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='last_updated'locations_id Array
(
[0] => Array
(
[fname] => locations_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => locations_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"locations_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='locations_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"locations_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='locations_id'active Array
(
[0] => Array
(
[fname] => active
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => active
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"active","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='active',is_unique='',date_updated=now(),sjson='[{\"fname\":\"active\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='active'auth_key Array
(
[0] => Array
(
[fname] => auth_key
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => auth_key
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"auth_key","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='auth_key',is_unique='',date_updated=now(),sjson='[{\"fname\":\"auth_key\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='auth_key'host_name Array
(
[0] => Array
(
[fname] => host
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => host_name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"host","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='host_name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"host\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='host_name'token Array
(
[0] => Array
(
[fname] => token
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => token
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"token","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='token',is_unique='',date_updated=now(),sjson='[{\"fname\":\"token\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='token'send_updates Array
(
[0] => Array
(
[fname] => send_updates
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => send_updates
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"send_updates","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='send_updates',is_unique='',date_updated=now(),sjson='[{\"fname\":\"send_updates\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='send_updates'programs_id Array
(
[0] => Array
(
[fname] => programs_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => programs_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"programs_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='programs_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"programs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='programs_id'origin Array
(
[0] => Array
(
[fname] => origin
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => origin
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"origin","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='origin',is_unique='',date_updated=now(),sjson='[{\"fname\":\"origin\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='origin'update_products Array
(
[0] => Array
(
[fname] => update_products
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => update_products
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"update_products","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='update_products',is_unique='',date_updated=now(),sjson='[{\"fname\":\"update_products\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='update_products'subs_id Array
(
[0] => Array
(
[fname] => subs_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => subs_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"subs_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='subs_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"subs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='subs_id'apis_id Array
(
[0] => Array
(
[fname] => apis_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 29
[kname] => apis_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"apis_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=29,kname='apis_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"apis_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='29' and kname='apis_id'select * from stables_keys where tables_id='29' and kid not in (361,362,363,364,365,366,367,368,369,370,371,372,373,374,375)SHOW INDEX FROM domains_bases
PRIMARY bases_id
hosts_id hosts_id
db_name db_name
db_usert db_user
date_updated date_updated
prime prime
PRIMARY Array
(
[0] => Array
(
[fname] => bases_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 30
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"bases_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=30,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"bases_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='30' and kname='PRIMARY'hosts_id Array
(
[0] => Array
(
[fname] => hosts_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 30
[kname] => hosts_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"hosts_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=30,kname='hosts_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"hosts_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='30' and kname='hosts_id'db_name Array
(
[0] => Array
(
[fname] => db_name
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 30
[kname] => db_name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"db_name","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=30,kname='db_name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"db_name\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='30' and kname='db_name'db_usert Array
(
[0] => Array
(
[fname] => db_user
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 30
[kname] => db_usert
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"db_user","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=30,kname='db_usert',is_unique='',date_updated=now(),sjson='[{\"fname\":\"db_user\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='30' and kname='db_usert'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 30
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=30,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='30' and kname='date_updated'prime Array
(
[0] => Array
(
[fname] => prime
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 30
[kname] => prime
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"prime","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=30,kname='prime',is_unique='',date_updated=now(),sjson='[{\"fname\":\"prime\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='30' and kname='prime'select * from stables_keys where tables_id='30' and kid not in (376,377,378,379,380,381)SHOW INDEX FROM domains_folders
PRIMARY folders_id
domains_id domains_id
files_total files_total
date_created date_created
folder folder
PRIMARY Array
(
[0] => Array
(
[fname] => folders_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 31
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"folders_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=31,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"folders_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='31' and kname='PRIMARY'domains_id Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 31
[kname] => domains_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=31,kname='domains_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='31' and kname='domains_id'files_total Array
(
[0] => Array
(
[fname] => files_total
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 31
[kname] => files_total
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"files_total","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=31,kname='files_total',is_unique='',date_updated=now(),sjson='[{\"fname\":\"files_total\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='31' and kname='files_total'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 31
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=31,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='31' and kname='date_created'folder Array
(
[0] => Array
(
[fname] => folder
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 31
[kname] => folder
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"folder","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=31,kname='folder',is_unique='',date_updated=now(),sjson='[{\"fname\":\"folder\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='31' and kname='folder'select * from stables_keys where tables_id='31' and kid not in (382,383,384,385,386)SHOW INDEX FROM domains_hosts
PRIMARY hosts_id
domains_id domains_id
date_created date_created
date_updated date_updated
hid hid
ip ip
ftp ftp
url_temp url_temp
PRIMARY Array
(
[0] => Array
(
[fname] => hosts_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"hosts_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"hosts_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='PRIMARY'domains_id Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => domains_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='domains_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='domains_id'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='date_created'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='date_updated'hid Array
(
[0] => Array
(
[fname] => hid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => hid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"hid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='hid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"hid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='hid'ip Array
(
[0] => Array
(
[fname] => ip
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => ip
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ip","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='ip',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ip\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='ip'ftp Array
(
[0] => Array
(
[fname] => ftp
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => ftp
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ftp","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='ftp',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ftp\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='ftp'url_temp Array
(
[0] => Array
(
[fname] => url_temp
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 32
[kname] => url_temp
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"url_temp","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=32,kname='url_temp',is_unique='',date_updated=now(),sjson='[{\"fname\":\"url_temp\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='32' and kname='url_temp'select * from stables_keys where tables_id='32' and kid not in (387,388,389,390,391,392,393,394)