run_crons_all
run_page_cronscfile: class_tables.php Array
(
)
update_alldb_name: Tables_in_gstca_manager
* inside get_tables *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_plugins' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='3'tables_id: 3
select * from stables where tname='articles' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='4'tables_id: 4
select * from stables where tname='crons' 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_data' 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='customers_cart' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='9'tables_id: 9
select * from stables where tname='domains' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='10'tables_id: 10
select * from stables where tname='domains_bases' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='11'tables_id: 11
select * from stables where tname='domains_folders' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='12'tables_id: 12
select * from stables where tname='domains_hosts' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='13'tables_id: 13
select * from stables where tname='photos' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='26'tables_id: 26
select * from stables where tname='photos_manager' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='28'tables_id: 28
select * from stables where tname='sections' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='14'tables_id: 14
select * from stables where tname='sessions' 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' 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_history' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='17'tables_id: 17
select * from stables where tname='socials_notifications' 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' 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_afiles' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='20'tables_id: 20
select * from stables where tname='stables_fields' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='21'tables_id: 21
select * from stables where tname='stables_folders' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='22'tables_id: 22
select * from stables where tname='stables_keys' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='23'tables_id: 23
select * from stables where tname='stables_versions' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='24'tables_id: 24
select * from stables where tname='tzones' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='27'tables_id: 27
select * from stables where tname='widgets' and itype='0' and sid='1'
update stables set date_removed=NULL where tables_id='25'tables_id: 25
update stables set trows=19,avg_row_len=227,data_len=4324,data_free=0,index_len=9216,auto_increment=22,collation='latin1_swedish_ci',date_created='2023-12-26 14:04:26',date_updated='2023-12-26 14:07:07',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='1'update stables set trows=47,avg_row_len=76,data_len=3608,data_free=0,index_len=14336,auto_increment=3538,collation='latin1_swedish_ci',date_created='2023-02-01 15:00:38',date_updated='2024-07-30 12:19:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='2'update stables set trows=10,avg_row_len=24,data_len=240,data_free=0,index_len=6144,auto_increment=11,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='3'update stables set trows=12,avg_row_len=95,data_len=1140,data_free=0,index_len=27648,auto_increment=15,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='4'update stables set trows=1,avg_row_len=88,data_len=88,data_free=0,index_len=15360,auto_increment=2,collation='latin1_swedish_ci',date_created='2024-04-03 19:59:46',date_updated='2024-04-03 19:59:46',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='5'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='6'update stables set trows=62,avg_row_len=26,data_len=1652,data_free=0,index_len=7168,auto_increment=64,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-12-26 14:23:27',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='7'update stables set trows=2,avg_row_len=156,data_len=312,data_free=0,index_len=12288,auto_increment=8,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2024-01-20 21:27:51',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='8'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='9'update stables set trows=10,avg_row_len=1638,data_len=16384,data_free=0,index_len=229376,auto_increment=95,collation='latin1_swedish_ci',date_created='2024-11-08 01:37:45',date_updated=NULL,date_checked=NULL,engine='InnoDB' where tables_id='10'update stables set trows=7,avg_row_len=77,data_len=4808,data_free=4268,index_len=11264,auto_increment=91,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2024-02-26 02:04:30',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='11'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=2048,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 22:17:56',date_updated='2023-01-21 22:17:56',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='12'update stables set trows=12,avg_row_len=88,data_len=8760,data_free=7696,index_len=16384,auto_increment=101,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2024-02-26 01:58:53',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='13'update stables set trows=4859,avg_row_len=758,data_len=3686400,data_free=0,index_len=3817472,auto_increment=29908,collation='latin1_general_ci',date_created='2024-11-08 01:37:45',date_updated=NULL,date_checked=NULL,engine='InnoDB' where tables_id='26'update stables set trows=5012,avg_row_len=735,data_len=3686400,data_free=4194304,index_len=3686400,auto_increment=29908,collation='latin1_general_ci',date_created='2024-11-08 01:37:45',date_updated=NULL,date_checked=NULL,engine='InnoDB' where tables_id='28'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='14'update stables set trows=9,avg_row_len=133,data_len=6420,data_free=5216,index_len=17408,auto_increment='',collation='latin1_swedish_ci',date_created='2023-01-22 19:26:04',date_updated='2025-04-03 21:59:18',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='15'update stables set trows=2,avg_row_len=68,data_len=136,data_free=0,index_len=19456,auto_increment=3,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='16'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='17'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='18'update stables set trows=28,avg_row_len=130,data_len=3656,data_free=0,index_len=29696,auto_increment=29,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2025-04-02 10:47:03',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='19'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=2048,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:17',date_updated='2023-01-21 20:51:17',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='20'update stables set trows=433,avg_row_len=57,data_len=25080,data_free=0,index_len=81920,auto_increment=460,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:18',date_updated='2025-04-02 10:47:03',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='21'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:18',date_updated='2023-01-21 20:51:18',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='22'update stables set trows=316,avg_row_len=104,data_len=32908,data_free=0,index_len=39936,auto_increment=317,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:18',date_updated='2025-04-02 10:47:04',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='23'update stables set trows=0,avg_row_len=0,data_len=0,data_free=0,index_len=1024,auto_increment=1,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:18',date_updated='2023-01-21 20:51:18',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='24'update stables set trows=39,avg_row_len=33,data_len=1324,data_free=0,index_len=6144,auto_increment=41,collation='latin1_swedish_ci',date_created='2023-01-22 16:10:57',date_updated='2023-01-22 16:10:57',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='27'update stables set trows=15,avg_row_len=50,data_len=760,data_free=0,index_len=11264,auto_increment=16,collation='latin1_swedish_ci',date_created='2023-01-21 20:51:18',date_updated='2023-02-01 18:41:19',date_checked='2024-12-03 01:38:17',engine='MyISAM' where tables_id='25'
***get_fields select * from stables where itype=0 and sid=1 and date_removed is NULL order by tname ASC total: 28
*********** DESCRIBE all_types
**************** 1 gid
**************** 1 from_types_id
**************** 1 locked
**************** 1 in_options
**************** 1 translation
**************** 1 json delete from stables_fields where tables_id='1' and fid not in (1,399,2,3,4,5,6,319,400,7,8)
*********** DESCRIBE all_types_data
**************** 2 gid
**************** 2 content1
**************** 2 clause
**************** 2 perc
**************** 2 mindex
**************** 2 ord delete from stables_fields where tables_id='2' and fid not in (9,401,10,11,12,13,14,15,16,17,320,321,18,19,20,322,323,21,22)
*********** DESCRIBE articles
**************** 4 options_id
**************** 4 geonameid
**************** 4 print_content delete from stables_fields where tables_id='4' and fid not in (23,24,25,26,27,28,29,30,324,31,32,33,34,35,36,325,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)
*********** DESCRIBE art_plugins
delete from stables_fields where tables_id='3' and fid not in (70,71,326,73,327,78,79)
*********** DESCRIBE crons
**************** 5 wid
**************** 5 json_pms
**************** 5 minutes_max
**************** 5 top_priority
**************** 5 time_each
**************** 5 keep_as_active delete from stables_fields where tables_id='5' and fid not in (80,328,329,81,82,83,456,84,85,86,87,88,457,458,459,89,90,91,92)
*********** DESCRIBE crons_data
delete from stables_fields where tables_id='6' and fid not in (93,94,95,96,97,98)
*********** 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 (99,100,101,102,103,104,105,106)
*********** DESCRIBE customers
**************** 8 types_id
**************** 8 news delete from stables_fields where tables_id='8' and fid not in (107,108,330,331,332,333,112,334,335,336,337,118,119,120,121,338,122,123,124)
*********** DESCRIBE customers_cart
delete from stables_fields where tables_id='9' and fid not in (125,126,127,128,129,130)
*********** DESCRIBE domains
**************** 10 programs_id
**************** 10 subs_id
**************** 10 apis_id
**************** 10 geonameid
**************** 10 locations_id
**************** 10 active
**************** 10 need_update
**************** 10 send_updates
**************** 10 update_products delete from stables_fields where tables_id='10' and fid not in (131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155)
*********** DESCRIBE domains_bases
**************** 11 hosts_id
**************** 11 db_name
**************** 11 db_user
**************** 11 db_pass
**************** 11 prime
**************** 11 locked delete from stables_fields where tables_id='11' and fid not in (156,157,158,159,160,161,162,163)
*********** DESCRIBE domains_folders
**************** 12 folder
**************** 12 files_total delete from stables_fields where tables_id='12' and fid not in (164,165,166,167,168)
*********** DESCRIBE domains_hosts
**************** 13 hid
**************** 13 domains_id delete from stables_fields where tables_id='13' and fid not in (169,170,171,172,173,174,175,176,177,178)
*********** DESCRIBE photos
**************** 26 art_id
**************** 26 products_id
**************** 26 pid
**************** 26 sid
**************** 26 from_products_id
**************** 26 from_art_id
**************** 26 rssc_id
**************** 26 reviews_id
**************** 26 options_id
**************** 26 wikis_id
**************** 26 customers_id
**************** 26 spaces_id
**************** 26 hardscape_id
**************** 26 specialty_id
**************** 26 is_profile
**************** 26 is_logo
**************** 26 size
**************** 26 ord
**************** 26 menards
**************** 26 main
**************** 26 photos_type
**************** 26 geonameid
**************** 26 width
**************** 26 height
**************** 26 advert
**************** 26 published
**************** 26 tstart
**************** 26 tend
**************** 26 processed
**************** 26 manual
**************** 26 catalog delete from stables_fields where tables_id='26' and fid not in (339,340,341,342,343,344,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)
*********** DESCRIBE photos_manager
**************** 28 art_id
**************** 28 products_id
**************** 28 pid
**************** 28 sid
**************** 28 from_products_id
**************** 28 from_art_id
**************** 28 rssc_id
**************** 28 reviews_id
**************** 28 options_id
**************** 28 wikis_id
**************** 28 customers_id
**************** 28 spaces_id
**************** 28 hardscape_id
**************** 28 specialty_id
**************** 28 is_profile
**************** 28 is_logo
**************** 28 size
**************** 28 ord
**************** 28 menards
**************** 28 main
**************** 28 photos_type
**************** 28 geonameid
**************** 28 width
**************** 28 height
**************** 28 advert
**************** 28 published
**************** 28 tstart
**************** 28 tend
**************** 28 processed
**************** 28 manual
**************** 28 catalog delete from stables_fields where tables_id='28' and fid not in (402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,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,450,451,452,453)
*********** DESCRIBE sections
delete from stables_fields where tables_id='14' and fid not in (179,180,181,182,183,184,185,186,187,188,189,190,191,192)
*********** DESCRIBE sessions
**************** 15 bid
**************** 15 aid
**************** 15 last_aid
**************** 15 tz delete from stables_fields where tables_id='15' and fid not in (193,194,454,392,393,455,395,198,201,203,204,205,206,207,208,214,215)
*********** DESCRIBE socials
delete from stables_fields where tables_id='16' and fid not in (216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231)
*********** DESCRIBE socials_history
delete from stables_fields where tables_id='17' and fid not in (232,233,234,235,236,237,238)
*********** DESCRIBE socials_notifications
delete from stables_fields where tables_id='18' and fid not in (239,240,241,242)
*********** DESCRIBE stables
delete from stables_fields where tables_id='19' and fid not in (243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269)
*********** DESCRIBE stables_afiles
delete from stables_fields where tables_id='20' and fid not in (270,271,272,273,274,275,276,277)
*********** DESCRIBE stables_fields
delete from stables_fields where tables_id='21' and fid not in (278,279,280,281,282,283,284,285,286,287,288,289)
*********** DESCRIBE stables_folders
delete from stables_fields where tables_id='22' and fid not in (290,291,292,293,294,295)
*********** DESCRIBE stables_keys
delete from stables_fields where tables_id='23' and fid not in (296,297,298,299,300,301)
*********** DESCRIBE stables_versions
delete from stables_fields where tables_id='24' and fid not in (302,303,304,305,306)
*********** DESCRIBE tzones
**************** 27 tzones_name delete from stables_fields where tables_id='27' and fid not in (396,397,398)
*********** DESCRIBE widgets
delete from stables_fields where tables_id='25' and fid not in (307,308,309,310,311,312,313,314,315,316,317,318)SHOW INDEX FROM all_types
PRIMARY types_id
inposts inposts
bycode bycode
date_updated date_updated
from_types_id from_types_id
locked locked
in_options in_options
gid gid
PRIMARY Array
(
[0] => Array
(
[fname] => types_id
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 1
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"types_id","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=1,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"types_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='1' and kname='PRIMARY'inposts Array
(
[0] => Array
(
[fname] => inposts
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 1
[kname] => inposts
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"inposts","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=1,kname='inposts',is_unique='',date_updated=now(),sjson='[{\"fname\":\"inposts\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='1' and kname='inposts'bycode Array
(
[0] => Array
(
[fname] => bycode
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 1
[kname] => bycode
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"bycode","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=1,kname='bycode',is_unique='',date_updated=now(),sjson='[{\"fname\":\"bycode\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='1' and kname='bycode'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 19
)
)
Array
(
[tables_id] => 1
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"19"}]
)
update stables_keys set tables_id=1,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"19\"}]' where tables_id='1' and kname='date_updated'from_types_id Array
(
[0] => Array
(
[fname] => from_types_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 1
[kname] => from_types_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_types_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=1,kname='from_types_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_types_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='1' and kname='from_types_id'locked Array
(
[0] => Array
(
[fname] => locked
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 1
[kname] => locked
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"locked","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=1,kname='locked',is_unique='',date_updated=now(),sjson='[{\"fname\":\"locked\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='1' and kname='locked'in_options Array
(
[0] => Array
(
[fname] => in_options
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 1
[kname] => in_options
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"in_options","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=1,kname='in_options',is_unique='',date_updated=now(),sjson='[{\"fname\":\"in_options\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='1' and kname='in_options'gid Array
(
[0] => Array
(
[fname] => gid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 1
[kname] => gid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"gid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=1,kname='gid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"gid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='1' and kname='gid'select * from stables_keys where tables_id='1' and kid not in (1,2,3,4,5,6,239,281)SHOW INDEX FROM all_types_data
PRIMARY data_id
types_id types_id
code code
id codes_id
cats_id cats_id
mcats_id mcats_id
version version
date_updated date_updated
from_data_id from_data_id
ord ord
gid gid
PRIMARY Array
(
[0] => Array
(
[fname] => data_id
[ord] => 1
[collation] => A
[cardinality] => 47
)
)
Array
(
[tables_id] => 2
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"data_id","ord":"1","collation":"A","cardinality":"47"}]
)
update stables_keys set tables_id=2,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"data_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"47\"}]' where tables_id='2' and kname='PRIMARY'types_id Array
(
[0] => Array
(
[fname] => types_id
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 2
[kname] => types_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"types_id","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=2,kname='types_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"types_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='2' and kname='types_id'code Array
(
[0] => Array
(
[fname] => code
[ord] => 1
[collation] => A
[cardinality] => 47
)
)
Array
(
[tables_id] => 2
[kname] => code
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"code","ord":"1","collation":"A","cardinality":"47"}]
)
update stables_keys set tables_id=2,kname='code',is_unique='',date_updated=now(),sjson='[{\"fname\":\"code\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"47\"}]' where tables_id='2' and kname='code'id Array
(
[0] => Array
(
[fname] => codes_id
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 2
[kname] => id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"codes_id","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=2,kname='id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"codes_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='2' and kname='id'cats_id Array
(
[0] => Array
(
[fname] => cats_id
[ord] => 1
[collation] => A
[cardinality] => 47
)
)
Array
(
[tables_id] => 2
[kname] => cats_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"cats_id","ord":"1","collation":"A","cardinality":"47"}]
)
update stables_keys set tables_id=2,kname='cats_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"cats_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"47\"}]' where tables_id='2' and kname='cats_id'mcats_id Array
(
[0] => Array
(
[fname] => mcats_id
[ord] => 1
[collation] => A
[cardinality] => 47
)
)
Array
(
[tables_id] => 2
[kname] => mcats_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"mcats_id","ord":"1","collation":"A","cardinality":"47"}]
)
update stables_keys set tables_id=2,kname='mcats_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"mcats_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"47\"}]' where tables_id='2' and kname='mcats_id'version Array
(
[0] => Array
(
[fname] => version
[ord] => 1
[collation] => A
[cardinality] => 47
)
)
Array
(
[tables_id] => 2
[kname] => version
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"version","ord":"1","collation":"A","cardinality":"47"}]
)
update stables_keys set tables_id=2,kname='version',is_unique='',date_updated=now(),sjson='[{\"fname\":\"version\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"47\"}]' where tables_id='2' and kname='version'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 47
)
)
Array
(
[tables_id] => 2
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"47"}]
)
update stables_keys set tables_id=2,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"47\"}]' where tables_id='2' and kname='date_updated'from_data_id Array
(
[0] => Array
(
[fname] => from_data_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 2
[kname] => from_data_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_data_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=2,kname='from_data_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_data_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='2' and kname='from_data_id'ord Array
(
[0] => Array
(
[fname] => ord
[ord] => 1
[collation] => A
[cardinality] => 11
)
)
Array
(
[tables_id] => 2
[kname] => ord
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ord","ord":"1","collation":"A","cardinality":"11"}]
)
update stables_keys set tables_id=2,kname='ord',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ord\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"11\"}]' where tables_id='2' and kname='ord'gid Array
(
[0] => Array
(
[fname] => gid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 2
[kname] => gid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"gid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=2,kname='gid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"gid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='2' and kname='gid'select * from stables_keys where tables_id='2' and kid not in (7,8,9,10,11,12,13,14,15,16,282)SHOW INDEX FROM art_plugins
PRIMARY ap_id
art_id art_id
plugins_id plugins_id
ord ord
sections_id navs_id
PRIMARY Array
(
[0] => Array
(
[fname] => ap_id
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 3
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"ap_id","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=3,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"ap_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='3' and kname='PRIMARY'art_id Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 3
[kname] => art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=3,kname='art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='3' and kname='art_id'plugins_id Array
(
[0] => Array
(
[fname] => plugins_id
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 3
[kname] => plugins_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"plugins_id","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=3,kname='plugins_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"plugins_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='3' and kname='plugins_id'ord Array
(
[0] => Array
(
[fname] => ord
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 3
[kname] => ord
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ord","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=3,kname='ord',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ord\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='3' and kname='ord'sections_id Array
(
[0] => Array
(
[fname] => navs_id
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 3
[kname] => sections_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"navs_id","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=3,kname='sections_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"navs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='3' and kname='sections_id'select * from stables_keys where tables_id='3' and kid not in (17,18,19,22,24)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
options_id options_id
geonameid geonameid
PRIMARY Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='PRIMARY'previews Array
(
[0] => Array
(
[fname] => views
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 4
[kname] => previews
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"views","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=4,kname='previews',is_unique='',date_updated=now(),sjson='[{\"fname\":\"views\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='4' and kname='previews'removed Array
(
[0] => Array
(
[fname] => removed
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 4
[kname] => removed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"removed","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=4,kname='removed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"removed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='4' and kname='removed'review Array
(
[0] => Array
(
[fname] => review
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => review
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"review","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='review',is_unique='',date_updated=now(),sjson='[{\"fname\":\"review\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='review'private Array
(
[0] => Array
(
[fname] => private
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 4
[kname] => private
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"private","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=4,kname='private',is_unique='',date_updated=now(),sjson='[{\"fname\":\"private\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='4' and kname='private'published Array
(
[0] => Array
(
[fname] => published
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 4
[kname] => published
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"published","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=4,kname='published',is_unique='',date_updated=now(),sjson='[{\"fname\":\"published\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='4' and kname='published'sections_id Array
(
[0] => Array
(
[fname] => sections_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => sections_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sections_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='sections_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sections_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='sections_id'sections_top Array
(
[0] => Array
(
[fname] => sections_top
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => sections_top
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sections_top","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='sections_top',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sections_top\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='sections_top'temps_id Array
(
[0] => Array
(
[fname] => temps_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 4
[kname] => temps_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"temps_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=4,kname='temps_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"temps_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='4' and kname='temps_id'mtemps_id Array
(
[0] => Array
(
[fname] => mtemps_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => mtemps_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"mtemps_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='mtemps_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"mtemps_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='mtemps_id'arts_type Array
(
[0] => Array
(
[fname] => arts_type
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 4
[kname] => arts_type
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"arts_type","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=4,kname='arts_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"arts_type\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='4' and kname='arts_type'domains_id Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 4
[kname] => domains_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=4,kname='domains_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='4' and kname='domains_id'products_id Array
(
[0] => Array
(
[fname] => products_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => products_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"products_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='products_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='products_id'slug Array
(
[0] => Array
(
[fname] => slug
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => slug
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"slug","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='slug',is_unique='',date_updated=now(),sjson='[{\"fname\":\"slug\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='slug'metas_title Array
(
[0] => Array
(
[fname] => metas_title
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => metas_title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"metas_title","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='metas_title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"metas_title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='metas_title'social_image Array
(
[0] => Array
(
[fname] => social_image
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => social_image
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"social_image","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='social_image',is_unique='',date_updated=now(),sjson='[{\"fname\":\"social_image\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='social_image'versions_id Array
(
[0] => Array
(
[fname] => versions_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => versions_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"versions_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='versions_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"versions_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='versions_id'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='customers_id'from_art_id Array
(
[0] => Array
(
[fname] => from_art_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => from_art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_art_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='from_art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='from_art_id'for_art_id Array
(
[0] => Array
(
[fname] => for_art_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => for_art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"for_art_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='for_art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"for_art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='for_art_id'is_cache Array
(
[0] => Array
(
[fname] => is_cache
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 4
[kname] => is_cache
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_cache","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=4,kname='is_cache',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_cache\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='4' and kname='is_cache'options_id Array
(
[0] => Array
(
[fname] => options_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 4
[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=4,kname='options_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"options_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='4' and kname='options_id'geonameid Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 4
[kname] => geonameid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=4,kname='geonameid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='4' and kname='geonameid'select * from stables_keys where tables_id='4' and kid not in (25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,240,241)SHOW INDEX FROM crons
PRIMARY crons_id
minutes minutes
run_func run_func
date_last_run date_last_run
run_class run_class
active active
mdate_started mdate_started
mdate_ended mdate_ended
date_updated date_updated
wid wid
top_priority top_priority
PRIMARY Array
(
[0] => Array
(
[fname] => crons_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"crons_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"crons_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='PRIMARY'minutes Array
(
[0] => Array
(
[fname] => minutes
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => minutes
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"minutes","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='minutes',is_unique='',date_updated=now(),sjson='[{\"fname\":\"minutes\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='minutes'run_func Array
(
[0] => Array
(
[fname] => run_func
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => run_func
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"run_func","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='run_func',is_unique='',date_updated=now(),sjson='[{\"fname\":\"run_func\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='run_func'date_last_run Array
(
[0] => Array
(
[fname] => date_last_run
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => date_last_run
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_last_run","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='date_last_run',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_last_run\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='date_last_run'run_class Array
(
[0] => Array
(
[fname] => run_class
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => run_class
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"run_class","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='run_class',is_unique='',date_updated=now(),sjson='[{\"fname\":\"run_class\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='run_class'active Array
(
[0] => Array
(
[fname] => active
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => active
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"active","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='active',is_unique='',date_updated=now(),sjson='[{\"fname\":\"active\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='active'mdate_started Array
(
[0] => Array
(
[fname] => mdate_started
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => mdate_started
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"mdate_started","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='mdate_started',is_unique='',date_updated=now(),sjson='[{\"fname\":\"mdate_started\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='mdate_started'mdate_ended Array
(
[0] => Array
(
[fname] => mdate_ended
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => mdate_ended
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"mdate_ended","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='mdate_ended',is_unique='',date_updated=now(),sjson='[{\"fname\":\"mdate_ended\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='mdate_ended'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[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=5,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='date_updated'wid Array
(
[0] => Array
(
[fname] => wid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => wid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"wid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='wid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"wid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='wid'top_priority Array
(
[0] => Array
(
[fname] => top_priority
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 5
[kname] => top_priority
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"top_priority","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=5,kname='top_priority',is_unique='',date_updated=now(),sjson='[{\"fname\":\"top_priority\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='5' and kname='top_priority'select * from stables_keys where tables_id='5' and kid not in (46,47,48,49,50,51,52,53,54,242,316)SHOW INDEX FROM crons_data
PRIMARY cdata_id
clogs_id clogs_id
connects_id connects_id
value value
date_created date_created
date_table date_table
PRIMARY Array
(
[0] => Array
(
[fname] => cdata_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 6
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"cdata_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=6,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"cdata_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='6' and kname='PRIMARY'clogs_id Array
(
[0] => Array
(
[fname] => clogs_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 6
[kname] => clogs_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"clogs_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=6,kname='clogs_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"clogs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='6' and kname='clogs_id'connects_id Array
(
[0] => Array
(
[fname] => connects_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 6
[kname] => connects_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"connects_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=6,kname='connects_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"connects_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='6' and kname='connects_id'value Array
(
[0] => Array
(
[fname] => value
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 6
[kname] => value
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"value","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=6,kname='value',is_unique='',date_updated=now(),sjson='[{\"fname\":\"value\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='6' and kname='value'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 6
[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=6,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='6' and kname='date_created'date_table Array
(
[0] => Array
(
[fname] => date_table
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 6
[kname] => date_table
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_table","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=6,kname='date_table',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_table\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='6' and kname='date_table'select * from stables_keys where tables_id='6' and kid not in (55,56,57,58,59,60)SHOW INDEX FROM crons_logs
PRIMARY clogs_id
crons_id crons_id
date_started date_started
date_ended date_ended
stotal stotal
sdone sdone
PRIMARY Array
(
[0] => Array
(
[fname] => clogs_id
[ord] => 1
[collation] => A
[cardinality] => 62
)
)
Array
(
[tables_id] => 7
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"clogs_id","ord":"1","collation":"A","cardinality":"62"}]
)
update stables_keys set tables_id=7,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"clogs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"62\"}]' where tables_id='7' and kname='PRIMARY'crons_id Array
(
[0] => Array
(
[fname] => crons_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 7
[kname] => crons_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"crons_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=7,kname='crons_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"crons_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='7' and kname='crons_id'date_started Array
(
[0] => Array
(
[fname] => date_started
[ord] => 1
[collation] => A
[cardinality] => 62
)
)
Array
(
[tables_id] => 7
[kname] => date_started
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_started","ord":"1","collation":"A","cardinality":"62"}]
)
update stables_keys set tables_id=7,kname='date_started',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_started\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"62\"}]' where tables_id='7' and kname='date_started'date_ended Array
(
[0] => Array
(
[fname] => date_ended
[ord] => 1
[collation] => A
[cardinality] => 62
)
)
Array
(
[tables_id] => 7
[kname] => date_ended
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_ended","ord":"1","collation":"A","cardinality":"62"}]
)
update stables_keys set tables_id=7,kname='date_ended',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_ended\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"62\"}]' where tables_id='7' and kname='date_ended'stotal Array
(
[0] => Array
(
[fname] => stotal
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 7
[kname] => stotal
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"stotal","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=7,kname='stotal',is_unique='',date_updated=now(),sjson='[{\"fname\":\"stotal\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='7' and kname='stotal'sdone Array
(
[0] => Array
(
[fname] => sdone
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 7
[kname] => sdone
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sdone","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=7,kname='sdone',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sdone\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='7' and kname='sdone'select * from stables_keys where tables_id='7' and kid not in (61,62,63,64,65,66)SHOW INDEX FROM customers
PRIMARY customers_id
customers_email_address email
private private
nickname nickname
timezone timezone
cookie_code cookie_code
inactive inactive
date_updated date_updated
date_created date_created
types_id types_id
news news
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'customers_email_address Array
(
[0] => Array
(
[fname] => email
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => customers_email_address
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"email","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='customers_email_address',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"email\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='customers_email_address'private Array
(
[0] => Array
(
[fname] => private
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => private
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"private","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='private',is_unique='',date_updated=now(),sjson='[{\"fname\":\"private\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='private'nickname Array
(
[0] => Array
(
[fname] => nickname
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => nickname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"nickname","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='nickname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"nickname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='nickname'timezone Array
(
[0] => Array
(
[fname] => timezone
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => timezone
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"timezone","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='timezone',is_unique='',date_updated=now(),sjson='[{\"fname\":\"timezone\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='timezone'cookie_code Array
(
[0] => Array
(
[fname] => cookie_code
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => cookie_code
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"cookie_code","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='cookie_code',is_unique='',date_updated=now(),sjson='[{\"fname\":\"cookie_code\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='cookie_code'inactive Array
(
[0] => Array
(
[fname] => inactive
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => inactive
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"inactive","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='inactive',is_unique='',date_updated=now(),sjson='[{\"fname\":\"inactive\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='inactive'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='date_updated'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='date_created'types_id Array
(
[0] => Array
(
[fname] => types_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 8
[kname] => types_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"types_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=8,kname='types_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"types_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='8' and kname='types_id'news Array
(
[0] => Array
(
[fname] => news
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 8
[kname] => news
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"news","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=8,kname='news',is_unique='',date_updated=now(),sjson='[{\"fname\":\"news\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='8' and kname='news'select * from stables_keys where tables_id='8' and kid not in (67,68,70,71,72,73,74,75,76,243,244)SHOW INDEX FROM customers_cart
PRIMARY ctid
customers_id customers_id
date_created date_created
date_updated date_updated
PRIMARY Array
(
[0] => Array
(
[fname] => ctid
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 9
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"ctid","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=9,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"ctid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='9' and kname='PRIMARY'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 9
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=9,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='9' and kname='customers_id'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 9
[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=9,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='9' and kname='date_created'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 9
[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=9,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='9' and kname='date_updated'select * from stables_keys where tables_id='9' and kid not in (77,78,79,80)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] => 10
)
)
Array
(
[tables_id] => 10
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=10,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='10' and kname='PRIMARY'url Array
(
[0] => Array
(
[fname] => url
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 10
[kname] => url
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"url","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=10,kname='url',is_unique='',date_updated=now(),sjson='[{\"fname\":\"url\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='10' and kname='url'geonameid Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 10
[kname] => geonameid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=10,kname='geonameid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='10' and kname='geonameid'last_updated Array
(
[0] => Array
(
[fname] => last_updated
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 10
[kname] => last_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"last_updated","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=10,kname='last_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"last_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='10' and kname='last_updated'locations_id Array
(
[0] => Array
(
[fname] => locations_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 10
[kname] => locations_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"locations_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=10,kname='locations_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"locations_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='10' and kname='locations_id'active Array
(
[0] => Array
(
[fname] => active
[ord] => 1
[collation] => A
[cardinality] => 5
)
)
Array
(
[tables_id] => 10
[kname] => active
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"active","ord":"1","collation":"A","cardinality":"5"}]
)
update stables_keys set tables_id=10,kname='active',is_unique='',date_updated=now(),sjson='[{\"fname\":\"active\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5\"}]' where tables_id='10' and kname='active'auth_key Array
(
[0] => Array
(
[fname] => auth_key
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 10
[kname] => auth_key
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"auth_key","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=10,kname='auth_key',is_unique='',date_updated=now(),sjson='[{\"fname\":\"auth_key\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='10' and kname='auth_key'host_name Array
(
[0] => Array
(
[fname] => host
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 10
[kname] => host_name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"host","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=10,kname='host_name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"host\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='10' and kname='host_name'token Array
(
[0] => Array
(
[fname] => token
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 10
[kname] => token
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"token","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=10,kname='token',is_unique='',date_updated=now(),sjson='[{\"fname\":\"token\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='10' and kname='token'send_updates Array
(
[0] => Array
(
[fname] => send_updates
[ord] => 1
[collation] => A
[cardinality] => 5
)
)
Array
(
[tables_id] => 10
[kname] => send_updates
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"send_updates","ord":"1","collation":"A","cardinality":"5"}]
)
update stables_keys set tables_id=10,kname='send_updates',is_unique='',date_updated=now(),sjson='[{\"fname\":\"send_updates\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5\"}]' where tables_id='10' and kname='send_updates'programs_id Array
(
[0] => Array
(
[fname] => programs_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 10
[kname] => programs_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"programs_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=10,kname='programs_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"programs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='10' and kname='programs_id'origin Array
(
[0] => Array
(
[fname] => origin
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 10
[kname] => origin
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"origin","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=10,kname='origin',is_unique='',date_updated=now(),sjson='[{\"fname\":\"origin\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='10' and kname='origin'update_products Array
(
[0] => Array
(
[fname] => update_products
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 10
[kname] => update_products
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"update_products","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=10,kname='update_products',is_unique='',date_updated=now(),sjson='[{\"fname\":\"update_products\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='10' and kname='update_products'subs_id Array
(
[0] => Array
(
[fname] => subs_id
[ord] => 1
[collation] => A
[cardinality] => 5
)
)
Array
(
[tables_id] => 10
[kname] => subs_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"subs_id","ord":"1","collation":"A","cardinality":"5"}]
)
update stables_keys set tables_id=10,kname='subs_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"subs_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5\"}]' where tables_id='10' and kname='subs_id'apis_id Array
(
[0] => Array
(
[fname] => apis_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 10
[kname] => apis_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"apis_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=10,kname='apis_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"apis_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='10' and kname='apis_id'select * from stables_keys where tables_id='10' and kid not in (81,82,83,84,85,86,87,88,89,90,91,92,93,94,95)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] => 7
)
)
Array
(
[tables_id] => 11
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"bases_id","ord":"1","collation":"A","cardinality":"7"}]
)
update stables_keys set tables_id=11,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"bases_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"7\"}]' where tables_id='11' and kname='PRIMARY'hosts_id Array
(
[0] => Array
(
[fname] => hosts_id
[ord] => 1
[collation] => A
[cardinality] => 7
)
)
Array
(
[tables_id] => 11
[kname] => hosts_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"hosts_id","ord":"1","collation":"A","cardinality":"7"}]
)
update stables_keys set tables_id=11,kname='hosts_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"hosts_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"7\"}]' where tables_id='11' and kname='hosts_id'db_name Array
(
[0] => Array
(
[fname] => db_name
[ord] => 1
[collation] => A
[cardinality] => 7
)
)
Array
(
[tables_id] => 11
[kname] => db_name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"db_name","ord":"1","collation":"A","cardinality":"7"}]
)
update stables_keys set tables_id=11,kname='db_name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"db_name\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"7\"}]' where tables_id='11' and kname='db_name'db_usert Array
(
[0] => Array
(
[fname] => db_user
[ord] => 1
[collation] => A
[cardinality] => 7
)
)
Array
(
[tables_id] => 11
[kname] => db_usert
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"db_user","ord":"1","collation":"A","cardinality":"7"}]
)
update stables_keys set tables_id=11,kname='db_usert',is_unique='',date_updated=now(),sjson='[{\"fname\":\"db_user\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"7\"}]' where tables_id='11' and kname='db_usert'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 7
)
)
Array
(
[tables_id] => 11
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"7"}]
)
update stables_keys set tables_id=11,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"7\"}]' where tables_id='11' and kname='date_updated'prime Array
(
[0] => Array
(
[fname] => prime
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 11
[kname] => prime
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"prime","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=11,kname='prime',is_unique='',date_updated=now(),sjson='[{\"fname\":\"prime\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='11' and kname='prime'select * from stables_keys where tables_id='11' and kid not in (96,97,98,99,100,101)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] => 12
[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=12,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"folders_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='12' and kname='PRIMARY'domains_id Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 12
[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=12,kname='domains_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='12' and kname='domains_id'files_total Array
(
[0] => Array
(
[fname] => files_total
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 12
[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=12,kname='files_total',is_unique='',date_updated=now(),sjson='[{\"fname\":\"files_total\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='12' and kname='files_total'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 12
[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=12,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='12' and kname='date_created'folder Array
(
[0] => Array
(
[fname] => folder
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 12
[kname] => folder
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"folder","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=12,kname='folder',is_unique='',date_updated=now(),sjson='[{\"fname\":\"folder\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='12' and kname='folder'select * from stables_keys where tables_id='12' and kid not in (102,103,104,105,106)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] => 12
)
)
Array
(
[tables_id] => 13
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"hosts_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=13,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"hosts_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='13' and kname='PRIMARY'domains_id Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 13
[kname] => domains_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=13,kname='domains_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='13' and kname='domains_id'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 13
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=13,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='13' and kname='date_created'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 13
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=13,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='13' and kname='date_updated'hid Array
(
[0] => Array
(
[fname] => hid
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 13
[kname] => hid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"hid","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=13,kname='hid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"hid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='13' and kname='hid'ip Array
(
[0] => Array
(
[fname] => ip
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 13
[kname] => ip
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ip","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=13,kname='ip',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ip\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='13' and kname='ip'ftp Array
(
[0] => Array
(
[fname] => ftp
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 13
[kname] => ftp
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ftp","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=13,kname='ftp',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ftp\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='13' and kname='ftp'url_temp Array
(
[0] => Array
(
[fname] => url_temp
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 13
[kname] => url_temp
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"url_temp","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=13,kname='url_temp',is_unique='',date_updated=now(),sjson='[{\"fname\":\"url_temp\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='13' and kname='url_temp'select * from stables_keys where tables_id='13' and kid not in (107,108,109,110,111,112,113,114)SHOW INDEX FROM sections
PRIMARY sections_id
tops_id_2 tops_id
tops_id_2 title
tops_id_2 art_id
title title
options_id options_id
ord ord
date_created date_created
cats_id cats_id
art_id art_id
title_short title_short
tops_id tops_id
widgets_id widgets_id
date_updated date_updated
PRIMARY Array
(
[0] => Array
(
[fname] => sections_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 14
[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=14,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"sections_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='14' and kname='PRIMARY'tops_id_2 Array
(
[0] => Array
(
[fname] => tops_id
[ord] => 1
[collation] => A
[cardinality] =>
)
[1] => Array
(
[fname] => title
[ord] => 2
[collation] => A
[cardinality] =>
[is_unique] => 1
)
[2] => Array
(
[fname] => art_id
[ord] => 3
[collation] => A
[cardinality] =>
[is_unique] => 1
)
)
Array
(
[tables_id] => 14
[kname] => tops_id_2
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tops_id","ord":"1","collation":"A","cardinality":null},{"fname":"title","ord":"2","collation":"A","cardinality":null,"is_unique":1},{"fname":"art_id","ord":"3","collation":"A","cardinality":null,"is_unique":1}]
)
update stables_keys set tables_id=14,kname='tops_id_2',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tops_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null},{\"fname\":\"title\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1},{\"fname\":\"art_id\",\"ord\":\"3\",\"collation\":\"A\",\"cardinality\":null,\"is_unique\":1}]' where tables_id='14' and kname='tops_id_2'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='title'options_id Array
(
[0] => Array
(
[fname] => options_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => options_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"options_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='options_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"options_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='options_id'ord Array
(
[0] => Array
(
[fname] => ord
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => ord
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ord","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='ord',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ord\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='ord'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[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=14,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='date_created'cats_id Array
(
[0] => Array
(
[fname] => cats_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => cats_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"cats_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='cats_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"cats_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='cats_id'art_id Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='art_id'title_short Array
(
[0] => Array
(
[fname] => title_short
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => title_short
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title_short","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='title_short',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title_short\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='title_short'tops_id Array
(
[0] => Array
(
[fname] => tops_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => tops_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tops_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='tops_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tops_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='tops_id'widgets_id Array
(
[0] => Array
(
[fname] => widgets_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[kname] => widgets_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"widgets_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=14,kname='widgets_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"widgets_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='widgets_id'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 14
[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=14,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='14' and kname='date_updated'select * from stables_keys where tables_id='14' and kid not in (115,116,117,118,119,120,121,122,123,124,125,126)SHOW INDEX FROM sessions
PRIMARY sid
ip ip
customers_id customers_id
sessions_id sid
user_agent user_agent
user_origin user_origin
host host
date_created date_created
date_updated date_updated
is_secure is_secure
domains_id domains_id
connected_as bid
PRIMARY Array
(
[0] => Array
(
[fname] => sid
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"sid","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"sid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='PRIMARY'ip Array
(
[0] => Array
(
[fname] => ip
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => ip
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ip","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='ip',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ip\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='ip'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 15
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=15,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='15' and kname='customers_id'sessions_id Array
(
[0] => Array
(
[fname] => sid
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => sessions_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sid","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='sessions_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='sessions_id'user_agent Array
(
[0] => Array
(
[fname] => user_agent
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => user_agent
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"user_agent","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='user_agent',is_unique='',date_updated=now(),sjson='[{\"fname\":\"user_agent\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='user_agent'user_origin Array
(
[0] => Array
(
[fname] => user_origin
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => user_origin
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"user_origin","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='user_origin',is_unique='',date_updated=now(),sjson='[{\"fname\":\"user_origin\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='user_origin'host Array
(
[0] => Array
(
[fname] => host
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => host
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"host","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='host',is_unique='',date_updated=now(),sjson='[{\"fname\":\"host\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='host'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='date_created'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='date_updated'is_secure Array
(
[0] => Array
(
[fname] => is_secure
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => is_secure
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_secure","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='is_secure',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_secure\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='is_secure'domains_id Array
(
[0] => Array
(
[fname] => domains_id
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 15
[kname] => domains_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"domains_id","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=15,kname='domains_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"domains_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='15' and kname='domains_id'connected_as Array
(
[0] => Array
(
[fname] => bid
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 15
[kname] => connected_as
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"bid","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=15,kname='connected_as',is_unique='',date_updated=now(),sjson='[{\"fname\":\"bid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='15' and kname='connected_as'select * from stables_keys where tables_id='15' and kid not in (127,128,129,130,131,132,133,134,135,138,146,147)SHOW INDEX FROM socials
PRIMARY socials_id
username uname
customers_id_2 customers_id
customers_id_2 uname
customers_id customers_id
inactive inactive
fname cname
date_created date_created
agents_id agents_id
title title
validated validated
username_2 username
is_spam is_spam
PRIMARY Array
(
[0] => Array
(
[fname] => socials_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 16
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"socials_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=16,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"socials_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='16' and kname='PRIMARY'username Array
(
[0] => Array
(
[fname] => uname
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 16
[kname] => username
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"uname","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=16,kname='username',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"uname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='16' and kname='username'customers_id_2 Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
[1] => Array
(
[fname] => uname
[ord] => 2
[collation] => A
[cardinality] => 2
[is_unique] => 1
)
)
Array
(
[tables_id] => 16
[kname] => customers_id_2
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"2"},{"fname":"uname","ord":"2","collation":"A","cardinality":"2","is_unique":1}]
)
update stables_keys set tables_id=16,kname='customers_id_2',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"},{\"fname\":\"uname\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"2\",\"is_unique\":1}]' where tables_id='16' and kname='customers_id_2'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 16
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=16,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='16' and kname='customers_id'inactive Array
(
[0] => Array
(
[fname] => inactive
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 16
[kname] => inactive
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"inactive","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=16,kname='inactive',is_unique='',date_updated=now(),sjson='[{\"fname\":\"inactive\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='16' and kname='inactive'fname Array
(
[0] => Array
(
[fname] => cname
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 16
[kname] => fname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"cname","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=16,kname='fname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"cname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='16' and kname='fname'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 16
[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=16,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='16' and kname='date_created'agents_id Array
(
[0] => Array
(
[fname] => agents_id
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 16
[kname] => agents_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"agents_id","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=16,kname='agents_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"agents_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='16' and kname='agents_id'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 16
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=16,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='16' and kname='title'validated Array
(
[0] => Array
(
[fname] => validated
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 16
[kname] => validated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"validated","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=16,kname='validated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"validated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='16' and kname='validated'username_2 Array
(
[0] => Array
(
[fname] => username
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 16
[kname] => username_2
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"username","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=16,kname='username_2',is_unique='',date_updated=now(),sjson='[{\"fname\":\"username\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='16' and kname='username_2'is_spam Array
(
[0] => Array
(
[fname] => is_spam
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 16
[kname] => is_spam
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_spam","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=16,kname='is_spam',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_spam\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='16' and kname='is_spam'select * from stables_keys where tables_id='16' and kid not in (148,149,150,151,152,153,154,155,156,157,158,159)SHOW INDEX FROM socials_history
PRIMARY shistory_id
socials_id socials_id
events_id events_id
date_created date_created
agents_id agents_id
sales_id sales_id
vcode vcode
PRIMARY Array
(
[0] => Array
(
[fname] => shistory_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 17
[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=17,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"shistory_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='17' and kname='PRIMARY'socials_id Array
(
[0] => Array
(
[fname] => socials_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 17
[kname] => socials_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"socials_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=17,kname='socials_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"socials_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='17' and kname='socials_id'events_id Array
(
[0] => Array
(
[fname] => events_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 17
[kname] => events_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"events_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=17,kname='events_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"events_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='17' and kname='events_id'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 17
[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=17,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='17' and kname='date_created'agents_id Array
(
[0] => Array
(
[fname] => agents_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 17
[kname] => agents_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"agents_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=17,kname='agents_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"agents_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='17' and kname='agents_id'sales_id Array
(
[0] => Array
(
[fname] => sales_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 17
[kname] => sales_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sales_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=17,kname='sales_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sales_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='17' and kname='sales_id'vcode Array
(
[0] => Array
(
[fname] => vcode
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 17
[kname] => vcode
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"vcode","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=17,kname='vcode',is_unique='',date_updated=now(),sjson='[{\"fname\":\"vcode\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='17' and kname='vcode'select * from stables_keys where tables_id='17' and kid not in (160,161,162,163,164,165,166)SHOW INDEX FROM socials_notifications
PRIMARY notifications_id
socials_id socials_id
ntypes_id ntypes_id
PRIMARY Array
(
[0] => Array
(
[fname] => notifications_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 18
[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=18,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"notifications_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='18' and kname='PRIMARY'socials_id Array
(
[0] => Array
(
[fname] => socials_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 18
[kname] => socials_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"socials_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=18,kname='socials_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"socials_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='18' and kname='socials_id'ntypes_id Array
(
[0] => Array
(
[fname] => ntypes_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 18
[kname] => ntypes_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ntypes_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=18,kname='ntypes_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ntypes_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='18' and kname='ntypes_id'select * from stables_keys where tables_id='18' and kid not in (167,168,169)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] => 28
)
)
Array
(
[tables_id] => 19
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='PRIMARY'tname Array
(
[0] => Array
(
[fname] => tname
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => tname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tname","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='tname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='tname'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='title'itype Array
(
[0] => Array
(
[fname] => itype
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 19
[kname] => itype
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"itype","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=19,kname='itype',is_unique='',date_updated=now(),sjson='[{\"fname\":\"itype\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='19' and kname='itype'sid Array
(
[0] => Array
(
[fname] => sid
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 19
[kname] => sid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sid","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=19,kname='sid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='19' and kname='sid'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 14
)
)
Array
(
[tables_id] => 19
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"14"}]
)
update stables_keys set tables_id=19,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"14\"}]' where tables_id='19' and kname='date_updated'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 9
)
)
Array
(
[tables_id] => 19
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"9"}]
)
update stables_keys set tables_id=19,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"9\"}]' where tables_id='19' and kname='date_created'rows Array
(
[0] => Array
(
[fname] => trows
[ord] => 1
[collation] => A
[cardinality] => 14
)
)
Array
(
[tables_id] => 19
[kname] => rows
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"trows","ord":"1","collation":"A","cardinality":"14"}]
)
update stables_keys set tables_id=19,kname='rows',is_unique='',date_updated=now(),sjson='[{\"fname\":\"trows\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"14\"}]' where tables_id='19' and kname='rows'avg_row_len Array
(
[0] => Array
(
[fname] => avg_row_len
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => avg_row_len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"avg_row_len","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='avg_row_len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"avg_row_len\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='avg_row_len'data_len Array
(
[0] => Array
(
[fname] => data_len
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => data_len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"data_len","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='data_len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"data_len\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='data_len'data_free Array
(
[0] => Array
(
[fname] => data_free
[ord] => 1
[collation] => A
[cardinality] => 5
)
)
Array
(
[tables_id] => 19
[kname] => data_free
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"data_free","ord":"1","collation":"A","cardinality":"5"}]
)
update stables_keys set tables_id=19,kname='data_free',is_unique='',date_updated=now(),sjson='[{\"fname\":\"data_free\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5\"}]' where tables_id='19' and kname='data_free'index_len Array
(
[0] => Array
(
[fname] => index_len
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => index_len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"index_len","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='index_len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"index_len\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='index_len'auto_increment Array
(
[0] => Array
(
[fname] => auto_increment
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => auto_increment
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"auto_increment","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='auto_increment',is_unique='',date_updated=now(),sjson='[{\"fname\":\"auto_increment\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='auto_increment'date_checked Array
(
[0] => Array
(
[fname] => date_checked
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 19
[kname] => date_checked
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_checked","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=19,kname='date_checked',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_checked\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='19' and kname='date_checked'file_size Array
(
[0] => Array
(
[fname] => file_size
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => file_size
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"file_size","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='file_size',is_unique='',date_updated=now(),sjson='[{\"fname\":\"file_size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='file_size'total_files Array
(
[0] => Array
(
[fname] => max_files
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => total_files
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"max_files","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='total_files',is_unique='',date_updated=now(),sjson='[{\"fname\":\"max_files\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='total_files'date_last_archived Array
(
[0] => Array
(
[fname] => date_last
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => date_last_archived
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_last","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='date_last_archived',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_last\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='date_last_archived'table_type Array
(
[0] => Array
(
[fname] => engine
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 19
[kname] => table_type
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"engine","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=19,kname='table_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"engine\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='19' and kname='table_type'data_len_last Array
(
[0] => Array
(
[fname] => data_len_last
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => data_len_last
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"data_len_last","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='data_len_last',is_unique='',date_updated=now(),sjson='[{\"fname\":\"data_len_last\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='data_len_last'not_editable Array
(
[0] => Array
(
[fname] => not_editable
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => not_editable
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"not_editable","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='not_editable',is_unique='',date_updated=now(),sjson='[{\"fname\":\"not_editable\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='not_editable'not_zippable Array
(
[0] => Array
(
[fname] => not_zippable
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => not_zippable
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"not_zippable","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='not_zippable',is_unique='',date_updated=now(),sjson='[{\"fname\":\"not_zippable\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='not_zippable'last_id Array
(
[0] => Array
(
[fname] => last_primary
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => last_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"last_primary","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='last_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"last_primary\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='last_id'min_rows Array
(
[0] => Array
(
[fname] => min_rows
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => min_rows
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"min_rows","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='min_rows',is_unique='',date_updated=now(),sjson='[{\"fname\":\"min_rows\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='min_rows'date_removed Array
(
[0] => Array
(
[fname] => date_removed
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => date_removed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_removed","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='date_removed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_removed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='date_removed'get_updates Array
(
[0] => Array
(
[fname] => get_updates
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 19
[kname] => get_updates
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"get_updates","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=19,kname='get_updates',is_unique='',date_updated=now(),sjson='[{\"fname\":\"get_updates\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='19' and kname='get_updates'select * from stables_keys where tables_id='19' and kid not in (170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194)SHOW INDEX FROM stables_afiles
PRIMARY files_id
file_name file_name
date_started date_created
date_ended date_updated
file_size file_size
start_id start_id
end_id end_id
tables_id tables_id
PRIMARY Array
(
[0] => Array
(
[fname] => files_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 20
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"files_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=20,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"files_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='20' and kname='PRIMARY'file_name Array
(
[0] => Array
(
[fname] => file_name
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 20
[kname] => file_name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"file_name","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=20,kname='file_name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"file_name\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='20' and kname='file_name'date_started Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 20
[kname] => date_started
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=20,kname='date_started',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='20' and kname='date_started'date_ended Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 20
[kname] => date_ended
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=20,kname='date_ended',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='20' and kname='date_ended'file_size Array
(
[0] => Array
(
[fname] => file_size
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 20
[kname] => file_size
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"file_size","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=20,kname='file_size',is_unique='',date_updated=now(),sjson='[{\"fname\":\"file_size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='20' and kname='file_size'start_id Array
(
[0] => Array
(
[fname] => start_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 20
[kname] => start_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"start_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=20,kname='start_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"start_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='20' and kname='start_id'end_id Array
(
[0] => Array
(
[fname] => end_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 20
[kname] => end_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"end_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=20,kname='end_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"end_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='20' and kname='end_id'tables_id Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 20
[kname] => tables_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=20,kname='tables_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='20' and kname='tables_id'select * from stables_keys where tables_id='20' and kid not in (195,196,197,198,199,200,201,202)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] => 433
)
)
Array
(
[tables_id] => 21
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"fid","ord":"1","collation":"A","cardinality":"433"}]
)
update stables_keys set tables_id=21,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"fid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"433\"}]' where tables_id='21' and kname='PRIMARY'tables_id_2 Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] => 28
)
[1] => Array
(
[fname] => fname
[ord] => 2
[collation] => A
[cardinality] => 433
[is_unique] => 1
)
)
Array
(
[tables_id] => 21
[kname] => tables_id_2
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"28"},{"fname":"fname","ord":"2","collation":"A","cardinality":"433","is_unique":1}]
)
update stables_keys set tables_id=21,kname='tables_id_2',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"},{\"fname\":\"fname\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"433\",\"is_unique\":1}]' where tables_id='21' and kname='tables_id_2'tables_id Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 21
[kname] => tables_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=21,kname='tables_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='21' and kname='tables_id'fname Array
(
[0] => Array
(
[fname] => fname
[ord] => 1
[collation] => A
[cardinality] => 216
)
)
Array
(
[tables_id] => 21
[kname] => fname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"fname","ord":"1","collation":"A","cardinality":"216"}]
)
update stables_keys set tables_id=21,kname='fname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"fname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"216\"}]' where tables_id='21' and kname='fname'ftype Array
(
[0] => Array
(
[fname] => ftype
[ord] => 1
[collation] => A
[cardinality] => 36
)
)
Array
(
[tables_id] => 21
[kname] => ftype
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ftype","ord":"1","collation":"A","cardinality":"36"}]
)
update stables_keys set tables_id=21,kname='ftype',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ftype\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"36\"}]' where tables_id='21' and kname='ftype'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] => 433
)
)
Array
(
[tables_id] => 21
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":"433"}]
)
update stables_keys set tables_id=21,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"433\"}]' where tables_id='21' and kname='title'types_id Array
(
[0] => Array
(
[fname] => ftypes_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 21
[kname] => types_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ftypes_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=21,kname='types_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ftypes_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='21' and kname='types_id'date_created Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 21
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"1"}]
)
update stables_keys set tables_id=21,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='21' and kname='date_created'fkey Array
(
[0] => Array
(
[fname] => fkey
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 21
[kname] => fkey
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"fkey","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=21,kname='fkey',is_unique='',date_updated=now(),sjson='[{\"fname\":\"fkey\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='21' and kname='fkey'auto_increment Array
(
[0] => Array
(
[fname] => auto_increment
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 21
[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=21,kname='auto_increment',is_unique='',date_updated=now(),sjson='[{\"fname\":\"auto_increment\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='21' and kname='auto_increment'fdefault Array
(
[0] => Array
(
[fname] => fdefault
[ord] => 1
[collation] => A
[cardinality] => 6
)
)
Array
(
[tables_id] => 21
[kname] => fdefault
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"fdefault","ord":"1","collation":"A","cardinality":"6"}]
)
update stables_keys set tables_id=21,kname='fdefault',is_unique='',date_updated=now(),sjson='[{\"fname\":\"fdefault\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"6\"}]' where tables_id='21' and kname='fdefault'select * from stables_keys where tables_id='21' and kid not in (203,204,205,206,207,208,209,210,211,212,213)SHOW INDEX FROM stables_folders
PRIMARY folders_id
tables_id folder
total_files total_files
date_started date_created
keeping keeping
total_size total_size
PRIMARY Array
(
[0] => Array
(
[fname] => folders_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 22
[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=22,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"folders_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='22' and kname='PRIMARY'tables_id Array
(
[0] => Array
(
[fname] => folder
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 22
[kname] => tables_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"folder","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=22,kname='tables_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"folder\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='22' and kname='tables_id'total_files Array
(
[0] => Array
(
[fname] => total_files
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 22
[kname] => total_files
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"total_files","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=22,kname='total_files',is_unique='',date_updated=now(),sjson='[{\"fname\":\"total_files\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='22' and kname='total_files'date_started Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 22
[kname] => date_started
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=22,kname='date_started',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='22' and kname='date_started'keeping Array
(
[0] => Array
(
[fname] => keeping
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 22
[kname] => keeping
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"keeping","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=22,kname='keeping',is_unique='',date_updated=now(),sjson='[{\"fname\":\"keeping\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='22' and kname='keeping'total_size Array
(
[0] => Array
(
[fname] => total_size
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 22
[kname] => total_size
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"total_size","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=22,kname='total_size',is_unique='',date_updated=now(),sjson='[{\"fname\":\"total_size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='22' and kname='total_size'select * from stables_keys where tables_id='22' and kid not in (214,215,216,217,218,219)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] => 316
)
)
Array
(
[tables_id] => 23
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"kid","ord":"1","collation":"A","cardinality":"316"}]
)
update stables_keys set tables_id=23,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"kid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"316\"}]' where tables_id='23' and kname='PRIMARY'tables_id_2 Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] => 28
)
[1] => Array
(
[fname] => kname
[ord] => 2
[collation] => A
[cardinality] => 316
[is_unique] => 1
)
)
Array
(
[tables_id] => 23
[kname] => tables_id_2
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"28"},{"fname":"kname","ord":"2","collation":"A","cardinality":"316","is_unique":1}]
)
update stables_keys set tables_id=23,kname='tables_id_2',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"},{\"fname\":\"kname\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"316\",\"is_unique\":1}]' where tables_id='23' and kname='tables_id_2'kname Array
(
[0] => Array
(
[fname] => kname
[ord] => 1
[collation] => A
[cardinality] => 158
)
)
Array
(
[tables_id] => 23
[kname] => kname
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"kname","ord":"1","collation":"A","cardinality":"158"}]
)
update stables_keys set tables_id=23,kname='kname',is_unique='',date_updated=now(),sjson='[{\"fname\":\"kname\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"158\"}]' where tables_id='23' and kname='kname'is_unique Array
(
[0] => Array
(
[fname] => is_unique
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 23
[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=23,kname='is_unique',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_unique\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='23' and kname='is_unique'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 23
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"3"}]
)
update stables_keys set tables_id=23,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='23' and kname='date_updated'tables_id Array
(
[0] => Array
(
[fname] => tables_id
[ord] => 1
[collation] => A
[cardinality] => 28
)
)
Array
(
[tables_id] => 23
[kname] => tables_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tables_id","ord":"1","collation":"A","cardinality":"28"}]
)
update stables_keys set tables_id=23,kname='tables_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tables_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"28\"}]' where tables_id='23' and kname='tables_id'select * from stables_keys where tables_id='23' and kid not in (220,221,222,223,224,225)SHOW INDEX FROM stables_versions
PRIMARY versions_id
files_id files_id
folders_id folders_id
file_size file_size
date_created date_created
PRIMARY Array
(
[0] => Array
(
[fname] => versions_id
[ord] => 1
[collation] => A
[cardinality] => 0
)
)
Array
(
[tables_id] => 24
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"versions_id","ord":"1","collation":"A","cardinality":"0"}]
)
update stables_keys set tables_id=24,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"versions_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"0\"}]' where tables_id='24' and kname='PRIMARY'files_id Array
(
[0] => Array
(
[fname] => files_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 24
[kname] => files_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"files_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=24,kname='files_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"files_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='24' and kname='files_id'folders_id Array
(
[0] => Array
(
[fname] => folders_id
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 24
[kname] => folders_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"folders_id","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=24,kname='folders_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"folders_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='24' and kname='folders_id'file_size Array
(
[0] => Array
(
[fname] => file_size
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 24
[kname] => file_size
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"file_size","ord":"1","collation":"A","cardinality":null}]
)
update stables_keys set tables_id=24,kname='file_size',is_unique='',date_updated=now(),sjson='[{\"fname\":\"file_size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='24' and kname='file_size'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] =>
)
)
Array
(
[tables_id] => 24
[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=24,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":null}]' where tables_id='24' and kname='date_created'select * from stables_keys where tables_id='24' and kid not in (226,227,228,229,230)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] => 15
)
)
Array
(
[tables_id] => 25
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"wid","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=25,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"wid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='25' and kname='PRIMARY'php_file Array
(
[0] => Array
(
[fname] => php_file
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 25
[kname] => php_file
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"php_file","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=25,kname='php_file',is_unique='',date_updated=now(),sjson='[{\"fname\":\"php_file\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='25' and kname='php_file'short_code Array
(
[0] => Array
(
[fname] => action
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 25
[kname] => short_code
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"action","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=25,kname='short_code',is_unique='',date_updated=now(),sjson='[{\"fname\":\"action\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='25' and kname='short_code'wid_type Array
(
[0] => Array
(
[fname] => wid_type
[ord] => 1
[collation] => A
[cardinality] => 3
)
)
Array
(
[tables_id] => 25
[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=25,kname='wid_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"wid_type\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"3\"}]' where tables_id='25' and kname='wid_type'title Array
(
[0] => Array
(
[fname] => title
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 25
[kname] => title
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"title","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=25,kname='title',is_unique='',date_updated=now(),sjson='[{\"fname\":\"title\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='25' and kname='title'from_wid Array
(
[0] => Array
(
[fname] => from_wid
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 25
[kname] => from_wid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_wid","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=25,kname='from_wid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_wid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='25' and kname='from_wid'is_cache Array
(
[0] => Array
(
[fname] => is_cache
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 25
[kname] => is_cache
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_cache","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=25,kname='is_cache',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_cache\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='25' and kname='is_cache'date_updated Array
(
[0] => Array
(
[fname] => date_updated
[ord] => 1
[collation] => A
[cardinality] => 15
)
)
Array
(
[tables_id] => 25
[kname] => date_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_updated","ord":"1","collation":"A","cardinality":"15"}]
)
update stables_keys set tables_id=25,kname='date_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"15\"}]' where tables_id='25' and kname='date_updated'select * from stables_keys where tables_id='25' and kid not in (231,232,233,234,235,236,237,238)SHOW INDEX FROM photos
PRIMARY id
art_id art_id
art_id type
len size
products_id products_id
ord ord
main main
menards menards
date_created date_created
options_id options_id
reviews_id reviews_id
photos_type photos_type
geonameid geonameid
url url
svg svg
wikis_id wikis_id
date_size_updated date_size_updated
pid pid
from_products_id from_products_id
advert advert
sid sid
rssc_id rssc_id
customers_id customers_id
is_profile is_profile
is_logo is_logo
published published
from_art_id from_art_id
date_new_resize date_new_resize
spaces_id spaces_id
hardscape_id hardscape_id
specialty_id specialty_id
processed processed
date_metas_updated date_metas_updated
catalog catalog
PRIMARY Array
(
[0] => Array
(
[fname] => id
[ord] => 1
[collation] => A
[cardinality] => 4859
)
)
Array
(
[tables_id] => 26
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"id","ord":"1","collation":"A","cardinality":"4859"}]
)
update stables_keys set tables_id=26,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4859\"}]' where tables_id='26' and kname='PRIMARY'art_id Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] => 2429
)
[1] => Array
(
[fname] => type
[ord] => 2
[collation] => A
[cardinality] => 2429
[is_unique] =>
)
)
Array
(
[tables_id] => 26
[kname] => art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":"2429"},{"fname":"type","ord":"2","collation":"A","cardinality":"2429","is_unique":false}]
)
update stables_keys set tables_id=26,kname='art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2429\"},{\"fname\":\"type\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"2429\",\"is_unique\":false}]' where tables_id='26' and kname='art_id'len Array
(
[0] => Array
(
[fname] => size
[ord] => 1
[collation] => A
[cardinality] => 4859
)
)
Array
(
[tables_id] => 26
[kname] => len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"size","ord":"1","collation":"A","cardinality":"4859"}]
)
update stables_keys set tables_id=26,kname='len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4859\"}]' where tables_id='26' and kname='len'products_id Array
(
[0] => Array
(
[fname] => products_id
[ord] => 1
[collation] => A
[cardinality] => 485
)
)
Array
(
[tables_id] => 26
[kname] => products_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"products_id","ord":"1","collation":"A","cardinality":"485"}]
)
update stables_keys set tables_id=26,kname='products_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"485\"}]' where tables_id='26' and kname='products_id'ord Array
(
[0] => Array
(
[fname] => ord
[ord] => 1
[collation] => A
[cardinality] => 36
)
)
Array
(
[tables_id] => 26
[kname] => ord
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ord","ord":"1","collation":"A","cardinality":"36"}]
)
update stables_keys set tables_id=26,kname='ord',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ord\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"36\"}]' where tables_id='26' and kname='ord'main Array
(
[0] => Array
(
[fname] => main
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 26
[kname] => main
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"main","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=26,kname='main',is_unique='',date_updated=now(),sjson='[{\"fname\":\"main\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='26' and kname='main'menards Array
(
[0] => Array
(
[fname] => menards
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 26
[kname] => menards
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"menards","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=26,kname='menards',is_unique='',date_updated=now(),sjson='[{\"fname\":\"menards\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='26' and kname='menards'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 4859
)
)
Array
(
[tables_id] => 26
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"4859"}]
)
update stables_keys set tables_id=26,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4859\"}]' where tables_id='26' and kname='date_created'options_id Array
(
[0] => Array
(
[fname] => options_id
[ord] => 1
[collation] => A
[cardinality] => 30
)
)
Array
(
[tables_id] => 26
[kname] => options_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"options_id","ord":"1","collation":"A","cardinality":"30"}]
)
update stables_keys set tables_id=26,kname='options_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"options_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"30\"}]' where tables_id='26' and kname='options_id'reviews_id Array
(
[0] => Array
(
[fname] => reviews_id
[ord] => 1
[collation] => A
[cardinality] => 971
)
)
Array
(
[tables_id] => 26
[kname] => reviews_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"reviews_id","ord":"1","collation":"A","cardinality":"971"}]
)
update stables_keys set tables_id=26,kname='reviews_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"reviews_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"971\"}]' where tables_id='26' and kname='reviews_id'photos_type Array
(
[0] => Array
(
[fname] => photos_type
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 26
[kname] => photos_type
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"photos_type","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=26,kname='photos_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"photos_type\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='26' and kname='photos_type'geonameid Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 1619
)
)
Array
(
[tables_id] => 26
[kname] => geonameid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"1619"}]
)
update stables_keys set tables_id=26,kname='geonameid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1619\"}]' where tables_id='26' and kname='geonameid'url Array
(
[0] => Array
(
[fname] => url
[ord] => 1
[collation] => A
[cardinality] => 4859
)
)
Array
(
[tables_id] => 26
[kname] => url
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"url","ord":"1","collation":"A","cardinality":"4859"}]
)
update stables_keys set tables_id=26,kname='url',is_unique='',date_updated=now(),sjson='[{\"fname\":\"url\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4859\"}]' where tables_id='26' and kname='url'svg Array
(
[0] => Array
(
[fname] => svg
[ord] => 1
[collation] => A
[cardinality] => 44
)
)
Array
(
[tables_id] => 26
[kname] => svg
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"svg","ord":"1","collation":"A","cardinality":"44"}]
)
update stables_keys set tables_id=26,kname='svg',is_unique='',date_updated=now(),sjson='[{\"fname\":\"svg\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"44\"}]' where tables_id='26' and kname='svg'wikis_id Array
(
[0] => Array
(
[fname] => wikis_id
[ord] => 1
[collation] => A
[cardinality] => 34
)
)
Array
(
[tables_id] => 26
[kname] => wikis_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"wikis_id","ord":"1","collation":"A","cardinality":"34"}]
)
update stables_keys set tables_id=26,kname='wikis_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"wikis_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"34\"}]' where tables_id='26' and kname='wikis_id'date_size_updated Array
(
[0] => Array
(
[fname] => date_size_updated
[ord] => 1
[collation] => A
[cardinality] => 4859
)
)
Array
(
[tables_id] => 26
[kname] => date_size_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_size_updated","ord":"1","collation":"A","cardinality":"4859"}]
)
update stables_keys set tables_id=26,kname='date_size_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_size_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4859\"}]' where tables_id='26' and kname='date_size_updated'pid Array
(
[0] => Array
(
[fname] => pid
[ord] => 1
[collation] => A
[cardinality] => 167
)
)
Array
(
[tables_id] => 26
[kname] => pid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"pid","ord":"1","collation":"A","cardinality":"167"}]
)
update stables_keys set tables_id=26,kname='pid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"pid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"167\"}]' where tables_id='26' and kname='pid'from_products_id Array
(
[0] => Array
(
[fname] => from_products_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 26
[kname] => from_products_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_products_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=26,kname='from_products_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='26' and kname='from_products_id'advert Array
(
[0] => Array
(
[fname] => advert
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 26
[kname] => advert
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"advert","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=26,kname='advert',is_unique='',date_updated=now(),sjson='[{\"fname\":\"advert\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='26' and kname='advert'sid Array
(
[0] => Array
(
[fname] => sid
[ord] => 1
[collation] => A
[cardinality] => 20
)
)
Array
(
[tables_id] => 26
[kname] => sid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sid","ord":"1","collation":"A","cardinality":"20"}]
)
update stables_keys set tables_id=26,kname='sid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"20\"}]' where tables_id='26' and kname='sid'rssc_id Array
(
[0] => Array
(
[fname] => rssc_id
[ord] => 1
[collation] => A
[cardinality] => 4859
)
)
Array
(
[tables_id] => 26
[kname] => rssc_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"rssc_id","ord":"1","collation":"A","cardinality":"4859"}]
)
update stables_keys set tables_id=26,kname='rssc_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"rssc_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4859\"}]' where tables_id='26' and kname='rssc_id'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 971
)
)
Array
(
[tables_id] => 26
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"971"}]
)
update stables_keys set tables_id=26,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"971\"}]' where tables_id='26' and kname='customers_id'is_profile Array
(
[0] => Array
(
[fname] => is_profile
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 26
[kname] => is_profile
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_profile","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=26,kname='is_profile',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_profile\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='26' and kname='is_profile'is_logo Array
(
[0] => Array
(
[fname] => is_logo
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 26
[kname] => is_logo
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_logo","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=26,kname='is_logo',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_logo\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='26' and kname='is_logo'published Array
(
[0] => Array
(
[fname] => published
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 26
[kname] => published
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"published","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=26,kname='published',is_unique='',date_updated=now(),sjson='[{\"fname\":\"published\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='26' and kname='published'from_art_id Array
(
[0] => Array
(
[fname] => from_art_id
[ord] => 1
[collation] => A
[cardinality] => 97
)
)
Array
(
[tables_id] => 26
[kname] => from_art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_art_id","ord":"1","collation":"A","cardinality":"97"}]
)
update stables_keys set tables_id=26,kname='from_art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"97\"}]' where tables_id='26' and kname='from_art_id'date_new_resize Array
(
[0] => Array
(
[fname] => date_new_resize
[ord] => 1
[collation] => A
[cardinality] => 4859
)
)
Array
(
[tables_id] => 26
[kname] => date_new_resize
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_new_resize","ord":"1","collation":"A","cardinality":"4859"}]
)
update stables_keys set tables_id=26,kname='date_new_resize',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_new_resize\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4859\"}]' where tables_id='26' and kname='date_new_resize'spaces_id Array
(
[0] => Array
(
[fname] => spaces_id
[ord] => 1
[collation] => A
[cardinality] => 18
)
)
Array
(
[tables_id] => 26
[kname] => spaces_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"spaces_id","ord":"1","collation":"A","cardinality":"18"}]
)
update stables_keys set tables_id=26,kname='spaces_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"spaces_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"18\"}]' where tables_id='26' and kname='spaces_id'hardscape_id Array
(
[0] => Array
(
[fname] => hardscape_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 26
[kname] => hardscape_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"hardscape_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=26,kname='hardscape_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"hardscape_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='26' and kname='hardscape_id'specialty_id Array
(
[0] => Array
(
[fname] => specialty_id
[ord] => 1
[collation] => A
[cardinality] => 20
)
)
Array
(
[tables_id] => 26
[kname] => specialty_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"specialty_id","ord":"1","collation":"A","cardinality":"20"}]
)
update stables_keys set tables_id=26,kname='specialty_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"specialty_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"20\"}]' where tables_id='26' and kname='specialty_id'processed Array
(
[0] => Array
(
[fname] => processed
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 26
[kname] => processed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"processed","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=26,kname='processed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"processed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='26' and kname='processed'date_metas_updated Array
(
[0] => Array
(
[fname] => date_metas_updated
[ord] => 1
[collation] => A
[cardinality] => 285
)
)
Array
(
[tables_id] => 26
[kname] => date_metas_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_metas_updated","ord":"1","collation":"A","cardinality":"285"}]
)
update stables_keys set tables_id=26,kname='date_metas_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_metas_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"285\"}]' where tables_id='26' and kname='date_metas_updated'catalog Array
(
[0] => Array
(
[fname] => catalog
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 26
[kname] => catalog
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"catalog","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=26,kname='catalog',is_unique='',date_updated=now(),sjson='[{\"fname\":\"catalog\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='26' and kname='catalog'select * from stables_keys where tables_id='26' and kid not in (245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277)SHOW INDEX FROM tzones
PRIMARY tzones_id
tzones_name tzones_name
date_created date_created
PRIMARY Array
(
[0] => Array
(
[fname] => tzones_id
[ord] => 1
[collation] => A
[cardinality] => 39
)
)
Array
(
[tables_id] => 27
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"tzones_id","ord":"1","collation":"A","cardinality":"39"}]
)
update stables_keys set tables_id=27,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"tzones_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"39\"}]' where tables_id='27' and kname='PRIMARY'tzones_name Array
(
[0] => Array
(
[fname] => tzones_name
[ord] => 1
[collation] => A
[cardinality] => 39
)
)
Array
(
[tables_id] => 27
[kname] => tzones_name
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"tzones_name","ord":"1","collation":"A","cardinality":"39"}]
)
update stables_keys set tables_id=27,kname='tzones_name',is_unique='',date_updated=now(),sjson='[{\"fname\":\"tzones_name\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"39\"}]' where tables_id='27' and kname='tzones_name'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 1
)
)
Array
(
[tables_id] => 27
[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=27,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1\"}]' where tables_id='27' and kname='date_created'select * from stables_keys where tables_id='27' and kid not in (278,279,280)SHOW INDEX FROM photos_manager
PRIMARY id
art_id art_id
art_id type
len size
products_id products_id
ord ord
main main
menards menards
date_created date_created
options_id options_id
reviews_id reviews_id
photos_type photos_type
geonameid geonameid
url url
svg svg
wikis_id wikis_id
date_size_updated date_size_updated
pid pid
from_products_id from_products_id
advert advert
sid sid
rssc_id rssc_id
customers_id customers_id
is_profile is_profile
is_logo is_logo
published published
from_art_id from_art_id
date_new_resize date_new_resize
spaces_id spaces_id
hardscape_id hardscape_id
specialty_id specialty_id
processed processed
date_metas_updated date_metas_updated
catalog catalog
PRIMARY Array
(
[0] => Array
(
[fname] => id
[ord] => 1
[collation] => A
[cardinality] => 5012
)
)
Array
(
[tables_id] => 28
[kname] => PRIMARY
[is_unique] => 1
[date_updated] => time_now
[sjson] => [{"fname":"id","ord":"1","collation":"A","cardinality":"5012"}]
)
update stables_keys set tables_id=28,kname='PRIMARY',is_unique=1,date_updated=now(),sjson='[{\"fname\":\"id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5012\"}]' where tables_id='28' and kname='PRIMARY'art_id Array
(
[0] => Array
(
[fname] => art_id
[ord] => 1
[collation] => A
[cardinality] => 2506
)
[1] => Array
(
[fname] => type
[ord] => 2
[collation] => A
[cardinality] => 2506
[is_unique] =>
)
)
Array
(
[tables_id] => 28
[kname] => art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"art_id","ord":"1","collation":"A","cardinality":"2506"},{"fname":"type","ord":"2","collation":"A","cardinality":"2506","is_unique":false}]
)
update stables_keys set tables_id=28,kname='art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2506\"},{\"fname\":\"type\",\"ord\":\"2\",\"collation\":\"A\",\"cardinality\":\"2506\",\"is_unique\":false}]' where tables_id='28' and kname='art_id'len Array
(
[0] => Array
(
[fname] => size
[ord] => 1
[collation] => A
[cardinality] => 5012
)
)
Array
(
[tables_id] => 28
[kname] => len
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"size","ord":"1","collation":"A","cardinality":"5012"}]
)
update stables_keys set tables_id=28,kname='len',is_unique='',date_updated=now(),sjson='[{\"fname\":\"size\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5012\"}]' where tables_id='28' and kname='len'products_id Array
(
[0] => Array
(
[fname] => products_id
[ord] => 1
[collation] => A
[cardinality] => 501
)
)
Array
(
[tables_id] => 28
[kname] => products_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"products_id","ord":"1","collation":"A","cardinality":"501"}]
)
update stables_keys set tables_id=28,kname='products_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"501\"}]' where tables_id='28' and kname='products_id'ord Array
(
[0] => Array
(
[fname] => ord
[ord] => 1
[collation] => A
[cardinality] => 36
)
)
Array
(
[tables_id] => 28
[kname] => ord
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"ord","ord":"1","collation":"A","cardinality":"36"}]
)
update stables_keys set tables_id=28,kname='ord',is_unique='',date_updated=now(),sjson='[{\"fname\":\"ord\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"36\"}]' where tables_id='28' and kname='ord'main Array
(
[0] => Array
(
[fname] => main
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 28
[kname] => main
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"main","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=28,kname='main',is_unique='',date_updated=now(),sjson='[{\"fname\":\"main\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='28' and kname='main'menards Array
(
[0] => Array
(
[fname] => menards
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 28
[kname] => menards
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"menards","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=28,kname='menards',is_unique='',date_updated=now(),sjson='[{\"fname\":\"menards\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='28' and kname='menards'date_created Array
(
[0] => Array
(
[fname] => date_created
[ord] => 1
[collation] => A
[cardinality] => 5012
)
)
Array
(
[tables_id] => 28
[kname] => date_created
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_created","ord":"1","collation":"A","cardinality":"5012"}]
)
update stables_keys set tables_id=28,kname='date_created',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_created\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5012\"}]' where tables_id='28' and kname='date_created'options_id Array
(
[0] => Array
(
[fname] => options_id
[ord] => 1
[collation] => A
[cardinality] => 30
)
)
Array
(
[tables_id] => 28
[kname] => options_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"options_id","ord":"1","collation":"A","cardinality":"30"}]
)
update stables_keys set tables_id=28,kname='options_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"options_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"30\"}]' where tables_id='28' and kname='options_id'reviews_id Array
(
[0] => Array
(
[fname] => reviews_id
[ord] => 1
[collation] => A
[cardinality] => 1002
)
)
Array
(
[tables_id] => 28
[kname] => reviews_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"reviews_id","ord":"1","collation":"A","cardinality":"1002"}]
)
update stables_keys set tables_id=28,kname='reviews_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"reviews_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1002\"}]' where tables_id='28' and kname='reviews_id'photos_type Array
(
[0] => Array
(
[fname] => photos_type
[ord] => 1
[collation] => A
[cardinality] => 10
)
)
Array
(
[tables_id] => 28
[kname] => photos_type
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"photos_type","ord":"1","collation":"A","cardinality":"10"}]
)
update stables_keys set tables_id=28,kname='photos_type',is_unique='',date_updated=now(),sjson='[{\"fname\":\"photos_type\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"10\"}]' where tables_id='28' and kname='photos_type'geonameid Array
(
[0] => Array
(
[fname] => geonameid
[ord] => 1
[collation] => A
[cardinality] => 1670
)
)
Array
(
[tables_id] => 28
[kname] => geonameid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"geonameid","ord":"1","collation":"A","cardinality":"1670"}]
)
update stables_keys set tables_id=28,kname='geonameid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"geonameid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1670\"}]' where tables_id='28' and kname='geonameid'url Array
(
[0] => Array
(
[fname] => url
[ord] => 1
[collation] => A
[cardinality] => 5012
)
)
Array
(
[tables_id] => 28
[kname] => url
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"url","ord":"1","collation":"A","cardinality":"5012"}]
)
update stables_keys set tables_id=28,kname='url',is_unique='',date_updated=now(),sjson='[{\"fname\":\"url\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5012\"}]' where tables_id='28' and kname='url'svg Array
(
[0] => Array
(
[fname] => svg
[ord] => 1
[collation] => A
[cardinality] => 44
)
)
Array
(
[tables_id] => 28
[kname] => svg
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"svg","ord":"1","collation":"A","cardinality":"44"}]
)
update stables_keys set tables_id=28,kname='svg',is_unique='',date_updated=now(),sjson='[{\"fname\":\"svg\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"44\"}]' where tables_id='28' and kname='svg'wikis_id Array
(
[0] => Array
(
[fname] => wikis_id
[ord] => 1
[collation] => A
[cardinality] => 34
)
)
Array
(
[tables_id] => 28
[kname] => wikis_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"wikis_id","ord":"1","collation":"A","cardinality":"34"}]
)
update stables_keys set tables_id=28,kname='wikis_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"wikis_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"34\"}]' where tables_id='28' and kname='wikis_id'date_size_updated Array
(
[0] => Array
(
[fname] => date_size_updated
[ord] => 1
[collation] => A
[cardinality] => 5012
)
)
Array
(
[tables_id] => 28
[kname] => date_size_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_size_updated","ord":"1","collation":"A","cardinality":"5012"}]
)
update stables_keys set tables_id=28,kname='date_size_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_size_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5012\"}]' where tables_id='28' and kname='date_size_updated'pid Array
(
[0] => Array
(
[fname] => pid
[ord] => 1
[collation] => A
[cardinality] => 172
)
)
Array
(
[tables_id] => 28
[kname] => pid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"pid","ord":"1","collation":"A","cardinality":"172"}]
)
update stables_keys set tables_id=28,kname='pid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"pid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"172\"}]' where tables_id='28' and kname='pid'from_products_id Array
(
[0] => Array
(
[fname] => from_products_id
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 28
[kname] => from_products_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_products_id","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=28,kname='from_products_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_products_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='28' and kname='from_products_id'advert Array
(
[0] => Array
(
[fname] => advert
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 28
[kname] => advert
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"advert","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=28,kname='advert',is_unique='',date_updated=now(),sjson='[{\"fname\":\"advert\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='28' and kname='advert'sid Array
(
[0] => Array
(
[fname] => sid
[ord] => 1
[collation] => A
[cardinality] => 20
)
)
Array
(
[tables_id] => 28
[kname] => sid
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"sid","ord":"1","collation":"A","cardinality":"20"}]
)
update stables_keys set tables_id=28,kname='sid',is_unique='',date_updated=now(),sjson='[{\"fname\":\"sid\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"20\"}]' where tables_id='28' and kname='sid'rssc_id Array
(
[0] => Array
(
[fname] => rssc_id
[ord] => 1
[collation] => A
[cardinality] => 5012
)
)
Array
(
[tables_id] => 28
[kname] => rssc_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"rssc_id","ord":"1","collation":"A","cardinality":"5012"}]
)
update stables_keys set tables_id=28,kname='rssc_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"rssc_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5012\"}]' where tables_id='28' and kname='rssc_id'customers_id Array
(
[0] => Array
(
[fname] => customers_id
[ord] => 1
[collation] => A
[cardinality] => 1002
)
)
Array
(
[tables_id] => 28
[kname] => customers_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"customers_id","ord":"1","collation":"A","cardinality":"1002"}]
)
update stables_keys set tables_id=28,kname='customers_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"customers_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"1002\"}]' where tables_id='28' and kname='customers_id'is_profile Array
(
[0] => Array
(
[fname] => is_profile
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 28
[kname] => is_profile
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_profile","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=28,kname='is_profile',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_profile\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='28' and kname='is_profile'is_logo Array
(
[0] => Array
(
[fname] => is_logo
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 28
[kname] => is_logo
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"is_logo","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=28,kname='is_logo',is_unique='',date_updated=now(),sjson='[{\"fname\":\"is_logo\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='28' and kname='is_logo'published Array
(
[0] => Array
(
[fname] => published
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 28
[kname] => published
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"published","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=28,kname='published',is_unique='',date_updated=now(),sjson='[{\"fname\":\"published\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='28' and kname='published'from_art_id Array
(
[0] => Array
(
[fname] => from_art_id
[ord] => 1
[collation] => A
[cardinality] => 96
)
)
Array
(
[tables_id] => 28
[kname] => from_art_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"from_art_id","ord":"1","collation":"A","cardinality":"96"}]
)
update stables_keys set tables_id=28,kname='from_art_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"from_art_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"96\"}]' where tables_id='28' and kname='from_art_id'date_new_resize Array
(
[0] => Array
(
[fname] => date_new_resize
[ord] => 1
[collation] => A
[cardinality] => 5012
)
)
Array
(
[tables_id] => 28
[kname] => date_new_resize
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_new_resize","ord":"1","collation":"A","cardinality":"5012"}]
)
update stables_keys set tables_id=28,kname='date_new_resize',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_new_resize\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"5012\"}]' where tables_id='28' and kname='date_new_resize'spaces_id Array
(
[0] => Array
(
[fname] => spaces_id
[ord] => 1
[collation] => A
[cardinality] => 18
)
)
Array
(
[tables_id] => 28
[kname] => spaces_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"spaces_id","ord":"1","collation":"A","cardinality":"18"}]
)
update stables_keys set tables_id=28,kname='spaces_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"spaces_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"18\"}]' where tables_id='28' and kname='spaces_id'hardscape_id Array
(
[0] => Array
(
[fname] => hardscape_id
[ord] => 1
[collation] => A
[cardinality] => 12
)
)
Array
(
[tables_id] => 28
[kname] => hardscape_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"hardscape_id","ord":"1","collation":"A","cardinality":"12"}]
)
update stables_keys set tables_id=28,kname='hardscape_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"hardscape_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"12\"}]' where tables_id='28' and kname='hardscape_id'specialty_id Array
(
[0] => Array
(
[fname] => specialty_id
[ord] => 1
[collation] => A
[cardinality] => 20
)
)
Array
(
[tables_id] => 28
[kname] => specialty_id
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"specialty_id","ord":"1","collation":"A","cardinality":"20"}]
)
update stables_keys set tables_id=28,kname='specialty_id',is_unique='',date_updated=now(),sjson='[{\"fname\":\"specialty_id\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"20\"}]' where tables_id='28' and kname='specialty_id'processed Array
(
[0] => Array
(
[fname] => processed
[ord] => 1
[collation] => A
[cardinality] => 2
)
)
Array
(
[tables_id] => 28
[kname] => processed
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"processed","ord":"1","collation":"A","cardinality":"2"}]
)
update stables_keys set tables_id=28,kname='processed',is_unique='',date_updated=now(),sjson='[{\"fname\":\"processed\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"2\"}]' where tables_id='28' and kname='processed'date_metas_updated Array
(
[0] => Array
(
[fname] => date_metas_updated
[ord] => 1
[collation] => A
[cardinality] => 294
)
)
Array
(
[tables_id] => 28
[kname] => date_metas_updated
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"date_metas_updated","ord":"1","collation":"A","cardinality":"294"}]
)
update stables_keys set tables_id=28,kname='date_metas_updated',is_unique='',date_updated=now(),sjson='[{\"fname\":\"date_metas_updated\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"294\"}]' where tables_id='28' and kname='date_metas_updated'catalog Array
(
[0] => Array
(
[fname] => catalog
[ord] => 1
[collation] => A
[cardinality] => 4
)
)
Array
(
[tables_id] => 28
[kname] => catalog
[is_unique] =>
[date_updated] => time_now
[sjson] => [{"fname":"catalog","ord":"1","collation":"A","cardinality":"4"}]
)
update stables_keys set tables_id=28,kname='catalog',is_unique='',date_updated=now(),sjson='[{\"fname\":\"catalog\",\"ord\":\"1\",\"collation\":\"A\",\"cardinality\":\"4\"}]' where tables_id='28' and kname='catalog'select * from stables_keys where tables_id='28' and kid not in (283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315)