Symfony Profiler

SHOW FULL TABLES 
WHERE 
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_accounts_head' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_accounts_head' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_accounts_head' */
WHERE 
  k.table_name = 'acc_accounts_head' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_accounts_head' */ WHERE k.table_name = 'acc_accounts_head' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_accounts_head' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_accounts_head' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_accounts_head'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_accounts_head';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_actual_closing_balance' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_actual_closing_balance' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_actual_closing_balance' */
WHERE 
  k.table_name = 'acc_actual_closing_balance' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_actual_closing_balance' */ WHERE k.table_name = 'acc_actual_closing_balance' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_actual_closing_balance' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_actual_closing_balance' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_actual_closing_balance'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_actual_closing_balance';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_check' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_check' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_check' */
WHERE 
  k.table_name = 'acc_check' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_check' */ WHERE k.table_name = 'acc_check' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_check' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_check' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_check'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_check';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_clients' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_clients' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_clients' */
WHERE 
  k.table_name = 'acc_clients' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_clients' */ WHERE k.table_name = 'acc_clients' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_clients' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_clients' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_clients'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_clients';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_closing_balance' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_closing_balance' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_closing_balance' */
WHERE 
  k.table_name = 'acc_closing_balance' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_closing_balance' */ WHERE k.table_name = 'acc_closing_balance' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_closing_balance' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_closing_balance' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_closing_balance'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_closing_balance';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_cost_centre' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_cost_centre' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_cost_centre' */
WHERE 
  k.table_name = 'acc_cost_centre' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_cost_centre' */ WHERE k.table_name = 'acc_cost_centre' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_cost_centre' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_cost_centre' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_cost_centre'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_cost_centre';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_entity' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_entity' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_entity' */
WHERE 
  k.table_name = 'acc_entity' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_entity' */ WHERE k.table_name = 'acc_entity' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_entity' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_entity' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_entity'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_entity';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_loan' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_loan' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_loan' */
WHERE 
  k.table_name = 'acc_loan' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_loan' */ WHERE k.table_name = 'acc_loan' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_loan' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_loan' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_loan'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_loan';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_loan_payment_schedule' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_loan_payment_schedule' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_loan_payment_schedule' */
WHERE 
  k.table_name = 'acc_loan_payment_schedule' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_loan_payment_schedule' */ WHERE k.table_name = 'acc_loan_payment_schedule' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_loan_payment_schedule' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_loan_payment_schedule' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_loan_payment_schedule'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_loan_payment_schedule';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_prefix' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_prefix' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_prefix' */
WHERE 
  k.table_name = 'acc_prefix' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_prefix' */ WHERE k.table_name = 'acc_prefix' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_prefix' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_prefix' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_prefix'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_prefix';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_service' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_service' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_service' */
WHERE 
  k.table_name = 'acc_service' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_service' */ WHERE k.table_name = 'acc_service' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_service' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_service' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_service'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_service';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_setting' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_setting' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_setting' */
WHERE 
  k.table_name = 'acc_setting' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_setting' */ WHERE k.table_name = 'acc_setting' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_setting' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_setting' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_setting'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_setting';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_suppliers' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_suppliers' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_suppliers' */
WHERE 
  k.table_name = 'acc_suppliers' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_suppliers' */ WHERE k.table_name = 'acc_suppliers' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_suppliers' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_suppliers' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_suppliers'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_suppliers';

SELECT 
  COLUMN_NAME AS Field, 
  COLUMN_TYPE AS Type, 
  IS_NULLABLE AS `Null`, 
  COLUMN_KEY AS `Key`, 
  COLUMN_DEFAULT AS `Default`, 
  EXTRA AS Extra, 
  COLUMN_COMMENT AS Comment, 
  CHARACTER_SET_NAME AS CharacterSet, 
  COLLATION_NAME AS Collation 
FROM 
  information_schema.COLUMNS 
WHERE 
  TABLE_SCHEMA = 'cg_9122_SERA' 
  AND TABLE_NAME = 'acc_suppliers_details' 
ORDER BY 
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'cg_9122_SERA' AND TABLE_NAME = 'acc_suppliers_details' ORDER BY ORDINAL_POSITION ASC;

SELECT 
  DISTINCT k.`CONSTRAINT_NAME`, 
  k.`COLUMN_NAME`, 
  k.`REFERENCED_TABLE_NAME`, 
  k.`REFERENCED_COLUMN_NAME` 
  /*!50116 , c.update_rule, c.delete_rule */
FROM 
  information_schema.key_column_usage k 
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_suppliers_details' */
WHERE 
  k.table_name = 'acc_suppliers_details' 
  AND k.table_schema = 'cg_9122_SERA' 
  /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'acc_suppliers_details' */ WHERE k.table_name = 'acc_suppliers_details' AND k.table_schema = 'cg_9122_SERA' /*!50116 AND c.constraint_schema = 'cg_9122_SERA' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT 
  NON_UNIQUE AS Non_Unique, 
  INDEX_NAME AS Key_name, 
  COLUMN_NAME AS Column_Name, 
  SUB_PART AS Sub_Part, 
  INDEX_TYPE AS Index_Type 
FROM 
  information_schema.STATISTICS 
WHERE 
  TABLE_NAME = 'acc_suppliers_details' 
  AND TABLE_SCHEMA = 'cg_9122_SERA' 
ORDER BY 
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'acc_suppliers_details' AND TABLE_SCHEMA = 'cg_9122_SERA' ORDER BY SEQ_IN_INDEX ASC;

SELECT 
  ENGINE, 
  AUTO_INCREMENT, 
  TABLE_COLLATION, 
  TABLE_COMMENT, 
  CREATE_OPTIONS 
FROM 
  information_schema.TABLES 
WHERE 
  TABLE_TYPE = 'BASE TABLE' 
  AND TABLE_SCHEMA = DATABASE() 
  AND TABLE_NAME = 'acc_suppliers_details'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'acc_suppliers_details';