1. Lee tablas ...
  2. No link table: agoda_transaction field: bookingidexternal_reference_id
  3. No link table: alumnos_becados field: estudiante_id
  4. No link table: alumnos_becados_350 field: estudiante_id
  5. No link table: alumnos_becados_350 field: run_id
  6. No link table: alumnos_becados_350 field: portal_confirmed_id
  7. No link table: alumnos_becados_350 field: portal_receipt_id
  8. No link table: alumnos_becados_ags97 field: estudiante_id
  9. No link table: alumnos_becados_ags97 field: run_id
  10. No link table: alumnos_becados_ags97 field: portal_confirmed_id
  11. No link table: alumnos_becados_ags97 field: portal_receipt_id
  12. No link table: alumnos_becados_gdl field: estudiante_id
  13. No link table: alumnos_becados_gdl field: run_id
  14. No link table: alumnos_becados_gdl field: portal_confirmed_id
  15. No link table: alumnos_becados_gdl field: portal_receipt_id
  16. No link table: banco_cuenta_mov field: mov_verificado_id
  17. No link table: banco_cuenta_mov field: contpaq_cliente_id
  18. No link table: banco_cuenta_mov field: categoria_gasto_id
  19. No link table: banco_cuenta_mov field: mov_repetido_id
  20. No link table: banco_cuenta_mov_con_links field: mov_verificado_id
  21. No link table: banco_cuenta_mov_con_links field: categoria_gasto_id
  22. No link table: banco_cuenta_mov_plantilla field: plantilla_id
  23. No link table: banco_cuenta_trans field: origen_mov_id
  24. No link table: banco_cuenta_trans field: contpaq_cliente_id
  25. No link table: banco_diccionario_dato field: categoria_gasto_id
  26. No link table: booking_transaction field: property_id
  27. No link table: booking_transaction field: legal_id
  28. No link table: cfdi_matcher_failures field: iteration_id
  29. No link table: cfdi_matcher_failures field: invoice_id
  30. No link table: cfdi_matcher_failures field: deposit_id
  31. No link table: cfdi_matcher_failures field: closest_match_id
  32. No link table: cfdi_matcher_failures field: resolved_match_id
  33. No link table: cfdi_matcher_failures field: pattern_id
  34. No link table: cfdi_matcher_links field: iteration_id
  35. No link table: cfdi_matcher_links field: invoice_id
  36. No link table: cfdi_matcher_links field: deposit_id
  37. No link table: cfdi_matcher_patterns field: example_invoice_id
  38. No link table: cfdi_matcher_patterns field: example_deposit_id
  39. No link table: cfdi_matcher_results field: iteration_id
  40. No link table: cfdi_matcher_results field: invoice_id
  41. No link table: cfdi_matcher_results field: deposit_id
  42. No link table: cfdi_matcher_results field: alternative_deposit_1_id
  43. No link table: cfdi_matcher_results field: alternative_deposit_2_id
  44. No link table: cfdi_matcher_results field: alternative_deposit_3_id
  45. No link table: cfdi_matcher_results field: corrected_deposit_id
  46. No link table: cuentat_mov field: origen_mov_id
  47. No link table: cuentat_mov field: contra_mov_id
  48. No link table: empresa field: cp_cliente_direccion_id
  49. No link table: iac_usr field: plantilla_id
  50. No link table: iac_usr field: plantillatienda_id
  51. No link table: import_schema_logs field: import_log_id
  52. No link table: kv_record_log field: collection_id
  53. No link table: kv_record_log field: record_id
  54. No link table: login_log field: session_id
  55. No link table: matcher_failures field: iteration_id
  56. No link table: matcher_failures field: reservation_id
  57. No link table: matcher_failures field: auto_generated_pattern_id
  58. No link table: matcher_results field: iteration_id
  59. No link table: matcher_results field: reservation_id
  60. No link table: matcher_results field: matched_property_id
  61. No link table: matcher_results field: corrected_property_id
  62. No link table: ota_pms_match field: ota_transaction_id
  63. No link table: ota_pms_match field: pms_reserva_id
  64. No link table: tienda field: cp_cliente_direccion_id
  65. No link table: v_propiedad_latest_analytics field: analytics_id
  66. Procesa tablas para generar archivos ....
  67. combo_tabla: banco_cuenta_mov no pk_single_field
  68. combo_tabla: banco_cuenta_mov_con_links no pk_single_field
  69. combo_tabla: iac_log no pk_single_field
  70. combo_tabla: iac_log_view no pk_single_field
  71. combo_tabla: propiedad_backup_20250102 no pk_single_field
  72. combo_tabla: v_analytics_iteration_summary no pk_single_field
  73. combo_tabla: v_propiedad_latest_analytics no pk_single_field
  74. class appRelate re-escribe /lamp/www/quantixTest/app/appRelate.php
    1. dime copiar de ia_case/copiar
    2. iac_aviso copiar de ia_case/copiar
    3. iac_class copiar de ia_case/copiar
    4. iac_enum_class copiar de ia_case/copiar
    5. iac_feriado copiar de ia_case/copiar
    6. iac_field_permission copiar de ia_case/copiar
    7. iac_issue copiar de ia_case/copiar
    8. iac_log copiar de ia_case/copiar
    9. iac_log_hecho copiar de ia_case/copiar
    10. iac_log_view copiar de ia_case/copiar
    11. iac_seq copiar de ia_case/copiar
    12. iac_table copiar de ia_case/copiar
    13. iac_table_permission copiar de ia_case/copiar
    14. iac_usr_online copiar de ia_case/copiar
DB
Create path
Hojas path Do
inc path
app_TABLE extends
sql trace Show Hide
Setup Create base tables Comenta tablas Sin comentar o Todas Show tables
Do Preview appRelate Create
De /lamp/www/quantixTest//app/appRelate.php:
Revisar Show All enum/links App Table Types Show Delete Rules Show link relations Show Parent/Child
Test Test enum/links Test
Show Show base tables Show databases
Doc Doc AppRelates tables array
Issues del iacase
Top
Script Time
Request time 1 sec 648 ms
Script time 735 ms
Apache time 913 ms
RAM
UsageUsage mallocPeakPeak malloc
3.65 Mb8.00 Mb6.21 Mb8.00 Mb
R Usage
ItemValueUnits
ru_oublock 16,728# veces
ru_inblock 55,984# veces
ru_msgsnd 0# IPC messages
ru_msgrcv 0# IPC messages
ru_maxrss 284,828Kb.
ru_ixrss 0kb * ticks-of-execution
ru_idrss 0kb * ticks-of-execution
ru_minflt 164,972pages
ru_majflt 198pages
ru_nsignals 0# señales
ru_nvcsw 11,763# context switches
ru_nivcsw 13,556# context switches
ru_nswap 0# veces
ru_utime.tv_usec 520,542microseconds
ru_utime.tv_sec 15secs.
ru_stime.tv_usec 633,823microseconds
ru_stime.tv_sec 3secs.
Sql Errors
  1. 1146 Table 'quantix.bookingidexternal_reference' doesn't exist
    EXPLAIN bookingidexternal_reference
  2. 1146 Table 'quantix.bookingidexternal' doesn't exist
    EXPLAIN bookingidexternal
  3. 1146 Table 'quantix.reference' doesn't exist
    EXPLAIN reference
  4. 1146 Table 'quantix.reference' doesn't exist
    EXPLAIN reference
  5. 1146 Table 'quantix.bookingidexternal' doesn't exist
    EXPLAIN bookingidexternal
  6. 1146 Table 'quantix.bookingidexternal_reference' doesn't exist
    EXPLAIN bookingidexternal_reference
  7. 1146 Table 'quantix.estudiante' doesn't exist
    EXPLAIN estudiante
  8. 1146 Table 'quantix.estudiante' doesn't exist
    EXPLAIN estudiante
  9. 1146 Table 'quantix.run' doesn't exist
    EXPLAIN run
  10. 1146 Table 'quantix.portal_confirmed' doesn't exist
    EXPLAIN portal_confirmed
  11. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  12. 1146 Table 'quantix.confirmed' doesn't exist
    EXPLAIN confirmed
  13. 1146 Table 'quantix.confirmed' doesn't exist
    EXPLAIN confirmed
  14. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  15. 1146 Table 'quantix.portal_confirmed' doesn't exist
    EXPLAIN portal_confirmed
  16. 1146 Table 'quantix.portal_receipt' doesn't exist
    EXPLAIN portal_receipt
  17. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  18. 1146 Table 'quantix.receipt' doesn't exist
    EXPLAIN receipt
  19. 1146 Table 'quantix.receipt' doesn't exist
    EXPLAIN receipt
  20. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  21. 1146 Table 'quantix.portal_receipt' doesn't exist
    EXPLAIN portal_receipt
  22. 1146 Table 'quantix.estudiante' doesn't exist
    EXPLAIN estudiante
  23. 1146 Table 'quantix.run' doesn't exist
    EXPLAIN run
  24. 1146 Table 'quantix.portal_confirmed' doesn't exist
    EXPLAIN portal_confirmed
  25. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  26. 1146 Table 'quantix.confirmed' doesn't exist
    EXPLAIN confirmed
  27. 1146 Table 'quantix.confirmed' doesn't exist
    EXPLAIN confirmed
  28. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  29. 1146 Table 'quantix.portal_confirmed' doesn't exist
    EXPLAIN portal_confirmed
  30. 1146 Table 'quantix.portal_receipt' doesn't exist
    EXPLAIN portal_receipt
  31. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  32. 1146 Table 'quantix.receipt' doesn't exist
    EXPLAIN receipt
  33. 1146 Table 'quantix.receipt' doesn't exist
    EXPLAIN receipt
  34. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  35. 1146 Table 'quantix.portal_receipt' doesn't exist
    EXPLAIN portal_receipt
  36. 1146 Table 'quantix.estudiante' doesn't exist
    EXPLAIN estudiante
  37. 1146 Table 'quantix.run' doesn't exist
    EXPLAIN run
  38. 1146 Table 'quantix.portal_confirmed' doesn't exist
    EXPLAIN portal_confirmed
  39. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  40. 1146 Table 'quantix.confirmed' doesn't exist
    EXPLAIN confirmed
  41. 1146 Table 'quantix.confirmed' doesn't exist
    EXPLAIN confirmed
  42. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  43. 1146 Table 'quantix.portal_confirmed' doesn't exist
    EXPLAIN portal_confirmed
  44. 1146 Table 'quantix.portal_receipt' doesn't exist
    EXPLAIN portal_receipt
  45. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  46. 1146 Table 'quantix.receipt' doesn't exist
    EXPLAIN receipt
  47. 1146 Table 'quantix.receipt' doesn't exist
    EXPLAIN receipt
  48. 1146 Table 'quantix.portal' doesn't exist
    EXPLAIN portal
  49. 1146 Table 'quantix.portal_receipt' doesn't exist
    EXPLAIN portal_receipt
  50. 1146 Table 'quantix.mov_verificado' doesn't exist
    EXPLAIN mov_verificado
  51. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  52. 1146 Table 'quantix.verificado' doesn't exist
    EXPLAIN verificado
  53. 1146 Table 'quantix.verificado' doesn't exist
    EXPLAIN verificado
  54. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  55. 1146 Table 'quantix.mov_verificado' doesn't exist
    EXPLAIN mov_verificado
  56. 1146 Table 'quantix.linkconfirmado_tienda' doesn't exist
    EXPLAIN linkconfirmado_tienda
  57. 1146 Table 'quantix.linkconfirmado' doesn't exist
    EXPLAIN linkconfirmado
  58. 1146 Table 'quantix.contpaq_cliente' doesn't exist
    EXPLAIN contpaq_cliente
  59. 1146 Table 'quantix.contpaq' doesn't exist
    EXPLAIN contpaq
  60. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  61. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  62. 1146 Table 'quantix.contpaq' doesn't exist
    EXPLAIN contpaq
  63. 1146 Table 'quantix.contpaq_cliente' doesn't exist
    EXPLAIN contpaq_cliente
  64. 1146 Table 'quantix.categoria_gasto' doesn't exist
    EXPLAIN categoria_gasto
  65. 1146 Table 'quantix.categoria' doesn't exist
    EXPLAIN categoria
  66. 1146 Table 'quantix.gasto' doesn't exist
    EXPLAIN gasto
  67. 1146 Table 'quantix.gasto' doesn't exist
    EXPLAIN gasto
  68. 1146 Table 'quantix.categoria' doesn't exist
    EXPLAIN categoria
  69. 1146 Table 'quantix.categoria_gasto' doesn't exist
    EXPLAIN categoria_gasto
  70. 1146 Table 'quantix.bc_empresa' doesn't exist
    EXPLAIN bc_empresa
  71. 1146 Table 'quantix.bc' doesn't exist
    EXPLAIN bc
  72. 1146 Table 'quantix.mov_repetido' doesn't exist
    EXPLAIN mov_repetido
  73. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  74. 1146 Table 'quantix.repetido' doesn't exist
    EXPLAIN repetido
  75. 1146 Table 'quantix.repetido' doesn't exist
    EXPLAIN repetido
  76. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  77. 1146 Table 'quantix.mov_repetido' doesn't exist
    EXPLAIN mov_repetido
  78. 1146 Table 'quantix.plantilla_withdrawals_de_banco' doesn't exist
    EXPLAIN plantilla_withdrawals_de_banco
  79. 1146 Table 'quantix.plantilla' doesn't exist
    EXPLAIN plantilla
  80. 1146 Table 'quantix.withdrawals' doesn't exist
    EXPLAIN withdrawals
  81. 1146 Table 'quantix.de' doesn't exist
    EXPLAIN de
  82. 1146 Table 'quantix.mov_verificado' doesn't exist
    EXPLAIN mov_verificado
  83. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  84. 1146 Table 'quantix.verificado' doesn't exist
    EXPLAIN verificado
  85. 1146 Table 'quantix.verificado' doesn't exist
    EXPLAIN verificado
  86. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  87. 1146 Table 'quantix.mov_verificado' doesn't exist
    EXPLAIN mov_verificado
  88. 1146 Table 'quantix.categoria_gasto' doesn't exist
    EXPLAIN categoria_gasto
  89. 1146 Table 'quantix.categoria' doesn't exist
    EXPLAIN categoria
  90. 1146 Table 'quantix.gasto' doesn't exist
    EXPLAIN gasto
  91. 1146 Table 'quantix.gasto' doesn't exist
    EXPLAIN gasto
  92. 1146 Table 'quantix.categoria' doesn't exist
    EXPLAIN categoria
  93. 1146 Table 'quantix.categoria_gasto' doesn't exist
    EXPLAIN categoria_gasto
  94. 1146 Table 'quantix.link_tienda' doesn't exist
    EXPLAIN link_tienda
  95. 1146 Table 'quantix.link' doesn't exist
    EXPLAIN link
  96. 1146 Table 'quantix.plantilla' doesn't exist
    EXPLAIN plantilla
  97. 1146 Table 'quantix.origen_banco_cuenta' doesn't exist
    EXPLAIN origen_banco_cuenta
  98. 1146 Table 'quantix.origen' doesn't exist
    EXPLAIN origen
  99. 1146 Table 'quantix.destino_banco_cuenta' doesn't exist
    EXPLAIN destino_banco_cuenta
  100. 1146 Table 'quantix.destino' doesn't exist
    EXPLAIN destino
  101. 1146 Table 'quantix.cuentat_deliveredto' doesn't exist
    EXPLAIN cuentat_deliveredto
  102. 1146 Table 'quantix.cuentat_transferto' doesn't exist
    EXPLAIN cuentat_transferto
  103. 1146 Table 'quantix.origen_mov' doesn't exist
    EXPLAIN origen_mov
  104. 1146 Table 'quantix.origen' doesn't exist
    EXPLAIN origen
  105. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  106. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  107. 1146 Table 'quantix.origen' doesn't exist
    EXPLAIN origen
  108. 1146 Table 'quantix.origen_mov' doesn't exist
    EXPLAIN origen_mov
  109. 1146 Table 'quantix.contpaq_cliente' doesn't exist
    EXPLAIN contpaq_cliente
  110. 1146 Table 'quantix.contpaq' doesn't exist
    EXPLAIN contpaq
  111. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  112. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  113. 1146 Table 'quantix.contpaq' doesn't exist
    EXPLAIN contpaq
  114. 1146 Table 'quantix.contpaq_cliente' doesn't exist
    EXPLAIN contpaq_cliente
  115. 1146 Table 'quantix.origen_moneda' doesn't exist
    EXPLAIN origen_moneda
  116. 1146 Table 'quantix.origen' doesn't exist
    EXPLAIN origen
  117. 1146 Table 'quantix.origen_banco_cuenta' doesn't exist
    EXPLAIN origen_banco_cuenta
  118. 1146 Table 'quantix.origen' doesn't exist
    EXPLAIN origen
  119. 1146 Table 'quantix.destino_banco_cuenta' doesn't exist
    EXPLAIN destino_banco_cuenta
  120. 1146 Table 'quantix.destino' doesn't exist
    EXPLAIN destino
  121. 1146 Table 'quantix.categoria_gasto' doesn't exist
    EXPLAIN categoria_gasto
  122. 1146 Table 'quantix.categoria' doesn't exist
    EXPLAIN categoria
  123. 1146 Table 'quantix.gasto' doesn't exist
    EXPLAIN gasto
  124. 1146 Table 'quantix.gasto' doesn't exist
    EXPLAIN gasto
  125. 1146 Table 'quantix.categoria' doesn't exist
    EXPLAIN categoria
  126. 1146 Table 'quantix.categoria_gasto' doesn't exist
    EXPLAIN categoria_gasto
  127. 1146 Table 'quantix.plantilla_withdrawals_de_banco' doesn't exist
    EXPLAIN plantilla_withdrawals_de_banco
  128. 1146 Table 'quantix.plantilla' doesn't exist
    EXPLAIN plantilla
  129. 1146 Table 'quantix.withdrawals' doesn't exist
    EXPLAIN withdrawals
  130. 1146 Table 'quantix.de' doesn't exist
    EXPLAIN de
  131. 1146 Table 'quantix.plantilla_withdrawals_de_banco' doesn't exist
    EXPLAIN plantilla_withdrawals_de_banco
  132. 1146 Table 'quantix.plantilla' doesn't exist
    EXPLAIN plantilla
  133. 1146 Table 'quantix.withdrawals' doesn't exist
    EXPLAIN withdrawals
  134. 1146 Table 'quantix.de' doesn't exist
    EXPLAIN de
  135. 1146 Table 'quantix.property' doesn't exist
    EXPLAIN property
  136. 1146 Table 'quantix.legal' doesn't exist
    EXPLAIN legal
  137. 1146 Table 'quantix.iteration' doesn't exist
    EXPLAIN iteration
  138. 1146 Table 'quantix.invoice' doesn't exist
    EXPLAIN invoice
  139. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  140. 1146 Table 'quantix.closest_match' doesn't exist
    EXPLAIN closest_match
  141. 1146 Table 'quantix.closest' doesn't exist
    EXPLAIN closest
  142. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match' at line 1
    EXPLAIN match
  143. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match' at line 1
    EXPLAIN match
  144. 1146 Table 'quantix.closest' doesn't exist
    EXPLAIN closest
  145. 1146 Table 'quantix.closest_match' doesn't exist
    EXPLAIN closest_match
  146. 1146 Table 'quantix.resolved_match' doesn't exist
    EXPLAIN resolved_match
  147. 1146 Table 'quantix.resolved' doesn't exist
    EXPLAIN resolved
  148. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match' at line 1
    EXPLAIN match
  149. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match' at line 1
    EXPLAIN match
  150. 1146 Table 'quantix.resolved' doesn't exist
    EXPLAIN resolved
  151. 1146 Table 'quantix.resolved_match' doesn't exist
    EXPLAIN resolved_match
  152. 1146 Table 'quantix.pattern' doesn't exist
    EXPLAIN pattern
  153. 1146 Table 'quantix.iteration' doesn't exist
    EXPLAIN iteration
  154. 1146 Table 'quantix.invoice' doesn't exist
    EXPLAIN invoice
  155. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  156. 1146 Table 'quantix.example_invoice' doesn't exist
    EXPLAIN example_invoice
  157. 1146 Table 'quantix.example' doesn't exist
    EXPLAIN example
  158. 1146 Table 'quantix.invoice' doesn't exist
    EXPLAIN invoice
  159. 1146 Table 'quantix.invoice' doesn't exist
    EXPLAIN invoice
  160. 1146 Table 'quantix.example' doesn't exist
    EXPLAIN example
  161. 1146 Table 'quantix.example_invoice' doesn't exist
    EXPLAIN example_invoice
  162. 1146 Table 'quantix.example_deposit' doesn't exist
    EXPLAIN example_deposit
  163. 1146 Table 'quantix.example' doesn't exist
    EXPLAIN example
  164. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  165. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  166. 1146 Table 'quantix.example' doesn't exist
    EXPLAIN example
  167. 1146 Table 'quantix.example_deposit' doesn't exist
    EXPLAIN example_deposit
  168. 1146 Table 'quantix.iteration' doesn't exist
    EXPLAIN iteration
  169. 1146 Table 'quantix.invoice' doesn't exist
    EXPLAIN invoice
  170. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  171. 1146 Table 'quantix.alternative_deposit_1' doesn't exist
    EXPLAIN alternative_deposit_1
  172. 1146 Table 'quantix.alternative' doesn't exist
    EXPLAIN alternative
  173. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  174. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1
    EXPLAIN 1
  175. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  176. 1146 Table 'quantix.deposit_1' doesn't exist
    EXPLAIN deposit_1
  177. 1146 Table 'quantix.alternative' doesn't exist
    EXPLAIN alternative
  178. 1146 Table 'quantix.alternative_deposit' doesn't exist
    EXPLAIN alternative_deposit
  179. 1146 Table 'quantix.alternative_deposit_1' doesn't exist
    EXPLAIN alternative_deposit_1
  180. 1146 Table 'quantix.alternative_deposit_2' doesn't exist
    EXPLAIN alternative_deposit_2
  181. 1146 Table 'quantix.alternative' doesn't exist
    EXPLAIN alternative
  182. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  183. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2' at line 1
    EXPLAIN 2
  184. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  185. 1146 Table 'quantix.deposit_2' doesn't exist
    EXPLAIN deposit_2
  186. 1146 Table 'quantix.alternative' doesn't exist
    EXPLAIN alternative
  187. 1146 Table 'quantix.alternative_deposit' doesn't exist
    EXPLAIN alternative_deposit
  188. 1146 Table 'quantix.alternative_deposit_2' doesn't exist
    EXPLAIN alternative_deposit_2
  189. 1146 Table 'quantix.alternative_deposit_3' doesn't exist
    EXPLAIN alternative_deposit_3
  190. 1146 Table 'quantix.alternative' doesn't exist
    EXPLAIN alternative
  191. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  192. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3' at line 1
    EXPLAIN 3
  193. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  194. 1146 Table 'quantix.deposit_3' doesn't exist
    EXPLAIN deposit_3
  195. 1146 Table 'quantix.alternative' doesn't exist
    EXPLAIN alternative
  196. 1146 Table 'quantix.alternative_deposit' doesn't exist
    EXPLAIN alternative_deposit
  197. 1146 Table 'quantix.alternative_deposit_3' doesn't exist
    EXPLAIN alternative_deposit_3
  198. 1146 Table 'quantix.corrected_deposit' doesn't exist
    EXPLAIN corrected_deposit
  199. 1146 Table 'quantix.corrected' doesn't exist
    EXPLAIN corrected
  200. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  201. 1146 Table 'quantix.deposit' doesn't exist
    EXPLAIN deposit
  202. 1146 Table 'quantix.corrected' doesn't exist
    EXPLAIN corrected
  203. 1146 Table 'quantix.corrected_deposit' doesn't exist
    EXPLAIN corrected_deposit
  204. 1146 Table 'quantix.usuario' doesn't exist
    EXPLAIN usuario
  205. 1146 Table 'quantix.aceptar_cuentat' doesn't exist
    EXPLAIN aceptar_cuentat
  206. 1146 Table 'quantix.aceptar' doesn't exist
    EXPLAIN aceptar
  207. 1146 Table 'quantix.cuentat_deliveredto' doesn't exist
    EXPLAIN cuentat_deliveredto
  208. 1146 Table 'quantix.cuentat_transferto' doesn't exist
    EXPLAIN cuentat_transferto
  209. 1146 Table 'quantix.origen_mov' doesn't exist
    EXPLAIN origen_mov
  210. 1146 Table 'quantix.origen' doesn't exist
    EXPLAIN origen
  211. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  212. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  213. 1146 Table 'quantix.origen' doesn't exist
    EXPLAIN origen
  214. 1146 Table 'quantix.origen_mov' doesn't exist
    EXPLAIN origen_mov
  215. 1146 Table 'quantix.contra_mov' doesn't exist
    EXPLAIN contra_mov
  216. 1146 Table 'quantix.contra' doesn't exist
    EXPLAIN contra
  217. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  218. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  219. 1146 Table 'quantix.contra' doesn't exist
    EXPLAIN contra
  220. 1146 Table 'quantix.contra_mov' doesn't exist
    EXPLAIN contra_mov
  221. 1146 Table 'quantix.cp_cliente_direccion' doesn't exist
    EXPLAIN cp_cliente_direccion
  222. 1146 Table 'quantix.cp' doesn't exist
    EXPLAIN cp
  223. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  224. 1146 Table 'quantix.direccion' doesn't exist
    EXPLAIN direccion
  225. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  226. 1146 Table 'quantix.cliente_direccion' doesn't exist
    EXPLAIN cliente_direccion
  227. 1146 Table 'quantix.cp' doesn't exist
    EXPLAIN cp
  228. 1146 Table 'quantix.cp_cliente' doesn't exist
    EXPLAIN cp_cliente
  229. 1146 Table 'quantix.cp_cliente_direccion' doesn't exist
    EXPLAIN cp_cliente_direccion
  230. 1146 Table 'quantix.usuario' doesn't exist
    EXPLAIN usuario
  231. 1146 Table 'quantix.plantilla' doesn't exist
    EXPLAIN plantilla
  232. 1146 Table 'quantix.plantillatienda' doesn't exist
    EXPLAIN plantillatienda
  233. 1146 Table 'quantix.cuentat_preferida' doesn't exist
    EXPLAIN cuentat_preferida
  234. 1146 Table 'quantix.import_log' doesn't exist
    EXPLAIN import_log
  235. 1146 Table 'quantix.import' doesn't exist
    EXPLAIN import
  236. 1146 Table 'quantix.log' doesn't exist
    EXPLAIN log
  237. 1146 Table 'quantix.log' doesn't exist
    EXPLAIN log
  238. 1146 Table 'quantix.import' doesn't exist
    EXPLAIN import
  239. 1146 Table 'quantix.import_log' doesn't exist
    EXPLAIN import_log
  240. 1146 Table 'quantix.collection' doesn't exist
    EXPLAIN collection
  241. 1146 Table 'quantix.record' doesn't exist
    EXPLAIN record
  242. 1146 Table 'quantix.session' doesn't exist
    EXPLAIN session
  243. 1146 Table 'quantix.usuario' doesn't exist
    EXPLAIN usuario
  244. 1146 Table 'quantix.iteration' doesn't exist
    EXPLAIN iteration
  245. 1146 Table 'quantix.reservation' doesn't exist
    EXPLAIN reservation
  246. 1146 Table 'quantix.auto_generated_pattern' doesn't exist
    EXPLAIN auto_generated_pattern
  247. 1146 Table 'quantix.auto' doesn't exist
    EXPLAIN auto
  248. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'generated' at line 1
    EXPLAIN generated
  249. 1146 Table 'quantix.pattern' doesn't exist
    EXPLAIN pattern
  250. 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'generated' at line 1
    EXPLAIN generated
  251. 1146 Table 'quantix.generated_pattern' doesn't exist
    EXPLAIN generated_pattern
  252. 1146 Table 'quantix.auto' doesn't exist
    EXPLAIN auto
  253. 1146 Table 'quantix.auto_generated' doesn't exist
    EXPLAIN auto_generated
  254. 1146 Table 'quantix.auto_generated_pattern' doesn't exist
    EXPLAIN auto_generated_pattern
  255. 1146 Table 'quantix.iteration' doesn't exist
    EXPLAIN iteration
  256. 1146 Table 'quantix.reservation' doesn't exist
    EXPLAIN reservation
  257. 1146 Table 'quantix.matched_property' doesn't exist
    EXPLAIN matched_property
  258. 1146 Table 'quantix.matched' doesn't exist
    EXPLAIN matched
  259. 1146 Table 'quantix.property' doesn't exist
    EXPLAIN property
  260. 1146 Table 'quantix.property' doesn't exist
    EXPLAIN property
  261. 1146 Table 'quantix.matched' doesn't exist
    EXPLAIN matched
  262. 1146 Table 'quantix.matched_property' doesn't exist
    EXPLAIN matched_property
  263. 1146 Table 'quantix.corrected_property' doesn't exist
    EXPLAIN corrected_property
  264. 1146 Table 'quantix.corrected' doesn't exist
    EXPLAIN corrected
  265. 1146 Table 'quantix.property' doesn't exist
    EXPLAIN property
  266. 1146 Table 'quantix.property' doesn't exist
    EXPLAIN property
  267. 1146 Table 'quantix.corrected' doesn't exist
    EXPLAIN corrected
  268. 1146 Table 'quantix.corrected_property' doesn't exist
    EXPLAIN corrected_property
  269. 1146 Table 'quantix.cuenta_t_mov' doesn't exist
    EXPLAIN cuenta_t_mov
  270. 1146 Table 'quantix.cuenta' doesn't exist
    EXPLAIN cuenta
  271. 1146 Table 'quantix.t' doesn't exist
    EXPLAIN t
  272. 1146 Table 'quantix.mov' doesn't exist
    EXPLAIN mov
  273. 1146 Table 'quantix.t' doesn't exist
    EXPLAIN t
  274. 1146 Table 'quantix.t_mov' doesn't exist
    EXPLAIN t_mov
  275. 1146 Table 'quantix.cuenta' doesn't exist
    EXPLAIN cuenta
  276. 1146 Table 'quantix.cuenta_t' doesn't exist
    EXPLAIN cuenta_t
  277. 1146 Table 'quantix.cuenta_t_mov' doesn't exist
    EXPLAIN cuenta_t_mov
  278. 1146 Table 'quantix.ota_transaction' doesn't exist
    EXPLAIN ota_transaction
  279. 1146 Table 'quantix.ota' doesn't exist
    EXPLAIN ota
  280. 1146 Table 'quantix.transaction' doesn't exist
    EXPLAIN transaction
  281. 1146 Table 'quantix.transaction' doesn't exist
    EXPLAIN transaction
  282. 1146 Table 'quantix.ota' doesn't exist
    EXPLAIN ota
  283. 1146 Table 'quantix.ota_transaction' doesn't exist
    EXPLAIN ota_transaction
  284. 1146 Table 'quantix.pms_reserva' doesn't exist
    EXPLAIN pms_reserva
  285. 1146 Table 'quantix.pms' doesn't exist
    EXPLAIN pms
  286. 1146 Table 'quantix.reserva' doesn't exist
    EXPLAIN reserva
  287. 1146 Table 'quantix.reserva' doesn't exist
    EXPLAIN reserva
  288. 1146 Table 'quantix.pms' doesn't exist
    EXPLAIN pms
  289. 1146 Table 'quantix.pms_reserva' doesn't exist
    EXPLAIN pms_reserva
  290. 1146 Table 'quantix.cp_cliente_direccion' doesn't exist
    EXPLAIN cp_cliente_direccion
  291. 1146 Table 'quantix.cp' doesn't exist
    EXPLAIN cp
  292. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  293. 1146 Table 'quantix.direccion' doesn't exist
    EXPLAIN direccion
  294. 1146 Table 'quantix.cliente' doesn't exist
    EXPLAIN cliente
  295. 1146 Table 'quantix.cliente_direccion' doesn't exist
    EXPLAIN cliente_direccion
  296. 1146 Table 'quantix.cp' doesn't exist
    EXPLAIN cp
  297. 1146 Table 'quantix.cp_cliente' doesn't exist
    EXPLAIN cp_cliente
  298. 1146 Table 'quantix.cp_cliente_direccion' doesn't exist
    EXPLAIN cp_cliente_direccion
  299. 1146 Table 'quantix.analytics' doesn't exist
    EXPLAIN analytics
Menu
  1. table_info_linksTo; agoda_transaction.bookingidexternal_reference_id no linkTable
  2. table_info_linksTo; alumnos_becados.estudiante_id no linkTable
  3. table_info_linksTo; alumnos_becados_350.estudiante_id no linkTable
  4. table_info_linksTo; alumnos_becados_350.run_id no linkTable
  5. table_info_linksTo; alumnos_becados_350.portal_confirmed_id no linkTable
  6. table_info_linksTo; alumnos_becados_350.portal_receipt_id no linkTable
  7. table_info_linksTo; alumnos_becados_ags97.estudiante_id no linkTable
  8. table_info_linksTo; alumnos_becados_ags97.run_id no linkTable
  9. table_info_linksTo; alumnos_becados_ags97.portal_confirmed_id no linkTable
  10. table_info_linksTo; alumnos_becados_ags97.portal_receipt_id no linkTable
  11. table_info_linksTo; alumnos_becados_gdl.estudiante_id no linkTable
  12. table_info_linksTo; alumnos_becados_gdl.run_id no linkTable
  13. table_info_linksTo; alumnos_becados_gdl.portal_confirmed_id no linkTable
  14. table_info_linksTo; alumnos_becados_gdl.portal_receipt_id no linkTable
  15. table_info_linksTo; banco_cuenta_mov.mov_verificado_id no linkTable
  16. table_info_linksTo; banco_cuenta_mov.contpaq_cliente_id no linkTable
  17. table_info_linksTo; banco_cuenta_mov.categoria_gasto_id no linkTable
  18. table_info_linksTo; banco_cuenta_mov.mov_repetido_id no linkTable
  19. table_info_linksTo; banco_cuenta_mov_con_links.mov_verificado_id no linkTable
  20. table_info_linksTo; banco_cuenta_mov_con_links.categoria_gasto_id no linkTable
  21. table_info_linksTo; banco_cuenta_mov_plantilla.plantilla_id no linkTable
  22. table_info_linksTo; banco_cuenta_trans.origen_mov_id no linkTable
  23. table_info_linksTo; banco_cuenta_trans.contpaq_cliente_id no linkTable
  24. table_info_linksTo; banco_diccionario_dato.categoria_gasto_id no linkTable
  25. table_info_linksTo; booking_transaction.property_id no linkTable
  26. table_info_linksTo; booking_transaction.legal_id no linkTable
  27. table_info_linksTo; cfdi_matcher_failures.iteration_id no linkTable
  28. table_info_linksTo; cfdi_matcher_failures.invoice_id no linkTable
  29. table_info_linksTo; cfdi_matcher_failures.deposit_id no linkTable
  30. table_info_linksTo; cfdi_matcher_failures.closest_match_id no linkTable
  31. table_info_linksTo; cfdi_matcher_failures.resolved_match_id no linkTable
  32. table_info_linksTo; cfdi_matcher_failures.pattern_id no linkTable
  33. table_info_linksTo; cfdi_matcher_links.iteration_id no linkTable
  34. table_info_linksTo; cfdi_matcher_links.invoice_id no linkTable
  35. table_info_linksTo; cfdi_matcher_links.deposit_id no linkTable
  36. table_info_linksTo; cfdi_matcher_patterns.example_invoice_id no linkTable
  37. table_info_linksTo; cfdi_matcher_patterns.example_deposit_id no linkTable
  38. table_info_linksTo; cfdi_matcher_results.iteration_id no linkTable
  39. table_info_linksTo; cfdi_matcher_results.invoice_id no linkTable
  40. table_info_linksTo; cfdi_matcher_results.deposit_id no linkTable
  41. table_info_linksTo; cfdi_matcher_results.alternative_deposit_1_id no linkTable
  42. table_info_linksTo; cfdi_matcher_results.alternative_deposit_2_id no linkTable
  43. table_info_linksTo; cfdi_matcher_results.alternative_deposit_3_id no linkTable
  44. table_info_linksTo; cfdi_matcher_results.corrected_deposit_id no linkTable
  45. table_info_linksTo; cuentat_mov.origen_mov_id no linkTable
  46. table_info_linksTo; cuentat_mov.contra_mov_id no linkTable
  47. table_info_linksTo; empresa.cp_cliente_direccion_id no linkTable
  48. table_info_linksTo; iac_usr.plantilla_id no linkTable
  49. table_info_linksTo; iac_usr.plantillatienda_id no linkTable
  50. table_info_linksTo; import_schema_logs.import_log_id no linkTable
  51. table_info_linksTo; kv_record_log.collection_id no linkTable
  52. table_info_linksTo; kv_record_log.record_id no linkTable
  53. table_info_linksTo; login_log.session_id no linkTable
  54. table_info_linksTo; matcher_failures.iteration_id no linkTable
  55. table_info_linksTo; matcher_failures.reservation_id no linkTable
  56. table_info_linksTo; matcher_failures.auto_generated_pattern_id no linkTable
  57. table_info_linksTo; matcher_results.iteration_id no linkTable
  58. table_info_linksTo; matcher_results.reservation_id no linkTable
  59. table_info_linksTo; matcher_results.matched_property_id no linkTable
  60. table_info_linksTo; matcher_results.corrected_property_id no linkTable
  61. table_info_linksTo; ota_pms_match.ota_transaction_id no linkTable
  62. table_info_linksTo; ota_pms_match.pms_reserva_id no linkTable
  63. table_info_linksTo; tienda.cp_cliente_direccion_id no linkTable
  64. table_info_linksTo; v_propiedad_latest_analytics.analytics_id no linkTable
  65. combo_tabla banco_cuenta_mov no pk_singlefield
  66. combo_tabla banco_cuenta_mov_con_links no pk_singlefield
  67. combo_tabla iac_log no pk_singlefield
  68. combo_tabla iac_log_view no pk_singlefield
  69. combo_tabla propiedad_backup_20250102 no pk_singlefield
  70. combo_tabla v_analytics_iteration_summary no pk_singlefield
  71. combo_tabla v_propiedad_latest_analytics no pk_singlefield
//////////////////////////////////// // ROLLO /////////////////////////////////////
  • Tips
    • Nested set jquery plugin http://mjsarfatti.com/sandbox/nestedSortable/
    • colspan/rowspan get rectangle http://stackoverflow.com/questions/9109247/add-colspan-and-rowspan-on-table-on-the-fly