Multitecno Online - Régimen Simplif.
¿Has olvidado la contraseña?


Tema basado en AdminLTE, licencia MIT.

Consultas SQL:

  1. SET foreign_key_checks = 0;
  2. SHOW TABLES;
  3. SHOW TABLE STATUS FROM `hostmult_facturacion` LIKE 'fs_users';
  4. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_users';
  5. SHOW COLUMNS FROM `fs_users`;
  6. SHOW TABLE STATUS FROM `hostmult_facturacion` LIKE 'fs_pages';
  7. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_pages';
  8. SHOW COLUMNS FROM `fs_pages`;
  9. SELECT * FROM fs_pages WHERE name = 'admin_home';
  10. SHOW TABLE STATUS FROM `hostmult_facturacion` LIKE 'empresa';
  11. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'empresa';
  12. SHOW COLUMNS FROM `empresa`;
  13. SELECT * FROM empresa;
  14. SHOW TABLE STATUS FROM `hostmult_facturacion` LIKE 'fs_vars';
  15. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_vars';
  16. SHOW COLUMNS FROM `fs_vars`;
  17. SELECT * FROM fs_vars;
  18. SHOW TABLE STATUS FROM `hostmult_facturacion` LIKE 'divisas';
  19. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'divisas';
  20. SHOW COLUMNS FROM `divisas`;
  21. SELECT * FROM divisas ORDER BY coddivisa ASC;
  22. SHOW TABLE STATUS FROM `hostmult_facturacion` LIKE 'fs_extensions2';
  23. SELECT CONSTRAINT_NAME as name, CONSTRAINT_TYPE as type FROM information_schema.table_constraints WHERE table_schema = schema() AND table_name = 'fs_extensions2';
  24. SHOW COLUMNS FROM `fs_extensions2`;
  25. SELECT * FROM fs_extensions2 ORDER BY name ASC;