mysql> use prodCEMIC Database changed mysql> show create table Application\G *************************** 1. row *************************** Table: Application Create Table: CREATE TABLE `Application` ( `SystemId` int(11) NOT NULL AUTO_INCREMENT, `UpdateCount` int(11) NOT NULL DEFAULT '0', `UpdateUser` varchar(50) DEFAULT NULL, `UpdateTimestamp` datetime DEFAULT NULL, `XmlContent` longtext NOT NULL, `MiniXmlContent` longtext, UNIQUE KEY `SystemId` (`SystemId`) ) ENGINE=InnoDB AUTO_INCREMENT=2117 DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> mysql> show table status\G *************************** 1. row *************************** Name: Account Engine: InnoDB Version: 10 Row_format: Compact Rows: 7751 Avg_row_length: 7916 Data_length: 61358080 Max_data_length: 0 Index_length: 0 Data_free: 6291456 Auto_increment: 984 Create_time: 2010-07-09 13:20:35 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 2. row *************************** Name: AccountLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 13800 Avg_row_length: 115 Data_length: 1589248 Max_data_length: 0 Index_length: 1589248 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 3. row *************************** Name: AccountStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 1455 Avg_row_length: 1092 Data_length: 1589248 Max_data_length: 0 Index_length: 835584 Data_free: 4194304 Auto_increment: 1484 Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 4. row *************************** Name: AccountSummaryStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 2829 Avg_row_length: 1303 Data_length: 3686400 Max_data_length: 0 Index_length: 425984 Data_free: 4194304 Auto_increment: 3538 Create_time: 2010-07-09 13:20:33 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 5. row *************************** Name: AccountingStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 5114 Avg_row_length: 515 Data_length: 2637824 Max_data_length: 0 Index_length: 5636096 Data_free: 4194304 Auto_increment: 5054 Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 6. row *************************** Name: AccountingSummaryStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 12537 Avg_row_length: 1385 Data_length: 17367040 Max_data_length: 0 Index_length: 5193728 Data_free: 4194304 Auto_increment: 18853 Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 7. row *************************** Name: Application Engine: InnoDB Version: 10 Row_format: Compact Rows: 2086 Avg_row_length: 62590 Data_length: 130564096 Max_data_length: 0 Index_length: 0 Data_free: 7340032 Auto_increment: 2117 Create_time: 2010-07-09 13:21:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 8. row *************************** Name: ApplicationLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 34166 Avg_row_length: 77 Data_length: 2637824 Max_data_length: 0 Index_length: 2637824 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 9. row *************************** Name: BankAccount Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 2 Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 10. row *************************** Name: BankAccountLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 3 Avg_row_length: 5461 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:25 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 11. row *************************** Name: BatchPrint Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 12. row *************************** Name: BatchPrintDocument Engine: InnoDB Version: 10 Row_format: Compact Rows: 3998 Avg_row_length: 1184 Data_length: 4734976 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 3982 Create_time: 2010-07-09 13:20:36 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 13. row *************************** Name: BatchPrintDocumentLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 7873 Avg_row_length: 45 Data_length: 360448 Max_data_length: 0 Index_length: 245760 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:20:32 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 14. row *************************** Name: BatchPrintLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 15. row *************************** Name: BatchReceipt Engine: InnoDB Version: 10 Row_format: Compact Rows: 9 Avg_row_length: 1820 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 10 Create_time: 2010-07-09 13:20:36 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 16. row *************************** Name: BatchReceiptLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 27 Avg_row_length: 606 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 17. row *************************** Name: BatchReturn Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 18. row *************************** Name: BatchReturnLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 19. row *************************** Name: CPCLUEContrib Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 20. row *************************** Name: CPCLUEContribLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 21. row *************************** Name: CPCLUPContrib Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 22. row *************************** Name: CPCLUPContribLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 23. row *************************** Name: CPCarrierContrib Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 24. row *************************** Name: CPCarrierContribLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:20:33 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 25. row *************************** Name: CalendarException Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 26. row *************************** Name: CalendarExceptionLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:20:36 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 27. row *************************** Name: Catastrophe Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:20:33 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 28. row *************************** Name: CatastropheLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:20:35 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 29. row *************************** Name: Claim Engine: InnoDB Version: 10 Row_format: Compact Rows: 59 Avg_row_length: 95527 Data_length: 5636096 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 70 Create_time: 2010-07-09 13:21:25 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 30. row *************************** Name: ClaimLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 801 Avg_row_length: 102 Data_length: 81920 Max_data_length: 0 Index_length: 65536 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 31. row *************************** Name: ClaimReinsuranceStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 81920 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:22:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 32. row *************************** Name: ClaimReinsuranceSummaryStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 65536 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:25 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 33. row *************************** Name: ClaimStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 77 Avg_row_length: 1276 Data_length: 98304 Max_data_length: 0 Index_length: 98304 Data_free: 0 Auto_increment: 81 Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 34. row *************************** Name: ClaimSummaryStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 103 Avg_row_length: 1113 Data_length: 114688 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: 83 Create_time: 2010-07-09 13:21:09 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 35. row *************************** Name: CommissionDetail Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 196608 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:20:32 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 36. row *************************** Name: Counters Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 2 Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 37. row *************************** Name: CountersLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 38. row *************************** Name: Customer Engine: InnoDB Version: 10 Row_format: Compact Rows: 1234 Avg_row_length: 3837 Data_length: 4734976 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 1225 Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 39. row *************************** Name: CustomerLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 19438 Avg_row_length: 81 Data_length: 1589248 Max_data_length: 0 Index_length: 1589248 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:22:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 40. row *************************** Name: DataReport Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 41. row *************************** Name: DataReportLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 42. row *************************** Name: Distribution Engine: InnoDB Version: 10 Row_format: Compact Rows: 3993 Avg_row_length: 5658 Data_length: 22593536 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 3983 Create_time: 2010-07-09 13:21:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 43. row *************************** Name: DistributionLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 3949 Avg_row_length: 45 Data_length: 180224 Max_data_length: 0 Index_length: 114688 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 44. row *************************** Name: ElectronicPayment Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:20:33 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 45. row *************************** Name: ElectronicPaymentLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 46. row *************************** Name: Job Engine: InnoDB Version: 10 Row_format: Compact Rows: 203 Avg_row_length: 7828 Data_length: 1589248 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 156 Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 47. row *************************** Name: JobLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 574 Avg_row_length: 114 Data_length: 65536 Max_data_length: 0 Index_length: 49152 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 48. row *************************** Name: LogEntry Engine: InnoDB Version: 10 Row_format: Compact Rows: 20027 Avg_row_length: 2805 Data_length: 56180736 Max_data_length: 0 Index_length: 0 Data_free: 7340032 Auto_increment: 18755 Create_time: 2010-07-09 13:21:09 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 49. row *************************** Name: LogEntryLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 121691 Avg_row_length: 64 Data_length: 7880704 Max_data_length: 0 Index_length: 6832128 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:21:09 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 50. row *************************** Name: NewsBanner Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 51. row *************************** Name: NewsBannerLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 10 Avg_row_length: 1638 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 52. row *************************** Name: NotificationRequest Engine: InnoDB Version: 10 Row_format: Compact Rows: 7581 Avg_row_length: 1454 Data_length: 11026432 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 8176 Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 53. row *************************** Name: NotificationRequestLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 31921 Avg_row_length: 82 Data_length: 2637824 Max_data_length: 0 Index_length: 2637824 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 54. row *************************** Name: OpenAccount Engine: InnoDB Version: 10 Row_format: Compact Rows: 2019 Avg_row_length: 194 Data_length: 393216 Max_data_length: 0 Index_length: 278528 Data_free: 0 Auto_increment: 1951 Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 55. row *************************** Name: PayableBatchRequest Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 56. row *************************** Name: PayableBatchRequestLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 10 Avg_row_length: 1638 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:20:36 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 57. row *************************** Name: PayableRequest Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 58. row *************************** Name: PayableRequestLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 8 Avg_row_length: 2048 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 59. row *************************** Name: PayableStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 32768 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 60. row *************************** Name: Payment Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 61. row *************************** Name: PaymentExports Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 2 Create_time: 2010-07-09 13:20:40 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 62. row *************************** Name: PaymentExportsLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 1 Avg_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:23 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 63. row *************************** Name: PaymentImports Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 64. row *************************** Name: PaymentImportsLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 65. row *************************** Name: PaymentLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 17 Avg_row_length: 963 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 66. row *************************** Name: PerrKnightStat Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 114688 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 67. row *************************** Name: Policy Engine: InnoDB Version: 10 Row_format: Compact Rows: 1106 Avg_row_length: 72542 Data_length: 80232448 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 984 Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 68. row *************************** Name: PolicyArchive Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 69. row *************************** Name: PolicyArchiveLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 70. row *************************** Name: PolicyHistory Engine: InnoDB Version: 10 Row_format: Compact Rows: 1141 Avg_row_length: 16096 Data_length: 18366464 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 198 Create_time: 2010-07-09 13:21:50 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 71. row *************************** Name: PolicyHistoryLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 2884 Avg_row_length: 62 Data_length: 180224 Max_data_length: 0 Index_length: 147456 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 72. row *************************** Name: PolicyLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 20879 Avg_row_length: 76 Data_length: 1589248 Max_data_length: 0 Index_length: 1589248 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:20:36 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 73. row *************************** Name: PolicyReinsuranceStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 977 Avg_row_length: 536 Data_length: 524288 Max_data_length: 0 Index_length: 720896 Data_free: 4194304 Auto_increment: 1041 Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 74. row *************************** Name: PolicyReinsuranceSummaryStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 2067 Avg_row_length: 1783 Data_length: 3686400 Max_data_length: 0 Index_length: 851968 Data_free: 4194304 Auto_increment: 2491 Create_time: 2010-07-09 13:20:36 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 75. row *************************** Name: PolicyStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 5175 Avg_row_length: 712 Data_length: 3686400 Max_data_length: 0 Index_length: 5586944 Data_free: 3145728 Auto_increment: 5136 Create_time: 2010-07-09 13:20:40 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 76. row *************************** Name: PolicySummaryStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 12146 Avg_row_length: 1516 Data_length: 18415616 Max_data_length: 0 Index_length: 4685824 Data_free: 4194304 Auto_increment: 14332 Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 77. row *************************** Name: Processor Engine: InnoDB Version: 10 Row_format: Compact Rows: 351 Avg_row_length: 4527 Data_length: 1589248 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 686 Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 78. row *************************** Name: ProcessorLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 3625 Avg_row_length: 58 Data_length: 212992 Max_data_length: 0 Index_length: 229376 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 79. row *************************** Name: Provider Engine: InnoDB Version: 10 Row_format: Compact Rows: 62 Avg_row_length: 25633 Data_length: 1589248 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 33 Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 80. row *************************** Name: ProviderLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 313 Avg_row_length: 209 Data_length: 65536 Max_data_length: 0 Index_length: 49152 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 81. row *************************** Name: ProviderStatement Engine: InnoDB Version: 10 Row_format: Compact Rows: 9 Avg_row_length: 29127 Data_length: 262144 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 8 Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 82. row *************************** Name: ProviderStatementLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 15 Avg_row_length: 1092 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:20:33 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 83. row *************************** Name: ReportWizard Engine: InnoDB Version: 10 Row_format: Compact Rows: 29 Avg_row_length: 11299 Data_length: 327680 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 43 Create_time: 2010-07-09 13:22:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 84. row *************************** Name: ReportWizardLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 130 Avg_row_length: 126 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:20:32 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 85. row *************************** Name: StorageBin Engine: InnoDB Version: 10 Row_format: Compact Rows: 4 Avg_row_length: 4096 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 5 Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 86. row *************************** Name: StorageBinLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 8 Avg_row_length: 2048 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 87. row *************************** Name: StorageFile Engine: InnoDB Version: 10 Row_format: Compact Rows: 10556 Avg_row_length: 448 Data_length: 4734976 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 10495 Create_time: 2010-07-09 13:20:35 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 88. row *************************** Name: StorageFileLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 10986 Avg_row_length: 40 Data_length: 442368 Max_data_length: 0 Index_length: 262144 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:22 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 89. row *************************** Name: Subscriptions Engine: InnoDB Version: 10 Row_format: Compact Rows: 5 Avg_row_length: 3276 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 6 Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 90. row *************************** Name: SubscriptionsLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 15 Avg_row_length: 1092 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 91. row *************************** Name: Suspense Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 92. row *************************** Name: SuspenseLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 8 Avg_row_length: 2048 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:23 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 93. row *************************** Name: SuspenseStats Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 98304 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:21:23 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 94. row *************************** Name: SystemData Engine: InnoDB Version: 10 Row_format: Compact Rows: 2 Avg_row_length: 8192 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 3 Create_time: 2010-07-09 13:21:14 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 95. row *************************** Name: SystemDataLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 4 Avg_row_length: 4096 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 96. row *************************** Name: Task Engine: InnoDB Version: 10 Row_format: Compact Rows: 7576 Avg_row_length: 4461 Data_length: 33800192 Max_data_length: 0 Index_length: 0 Data_free: 4194304 Auto_increment: 4072 Create_time: 2010-07-09 13:20:33 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 97. row *************************** Name: TaskLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 70753 Avg_row_length: 66 Data_length: 4734976 Max_data_length: 0 Index_length: 4718592 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 98. row *************************** Name: TestPerson Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:20:33 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 99. row *************************** Name: TestPersonLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 100. row *************************** Name: Thing Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: 2010-07-09 13:21:09 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 101. row *************************** Name: ThingLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 102. row *************************** Name: UserInfo Engine: InnoDB Version: 10 Row_format: Compact Rows: 63 Avg_row_length: 5461 Data_length: 344064 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 58 Create_time: 2010-07-09 13:21:21 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 103. row *************************** Name: UserInfoLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 343 Avg_row_length: 143 Data_length: 49152 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:22:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 104. row *************************** Name: UserRecentActivity Engine: InnoDB Version: 10 Row_format: Compact Rows: 27 Avg_row_length: 3640 Data_length: 98304 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 29 Create_time: 2010-07-09 13:21:24 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 105. row *************************** Name: UserRecentActivityLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 56 Avg_row_length: 292 Data_length: 16384 Max_data_length: 0 Index_length: 16384 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:16 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 106. row *************************** Name: VehicleManufacturer Engine: InnoDB Version: 10 Row_format: Compact Rows: 49 Avg_row_length: 2340 Data_length: 114688 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: 53 Create_time: 2010-07-09 13:21:20 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 107. row *************************** Name: VehicleManufacturerLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 853 Avg_row_length: 76 Data_length: 65536 Max_data_length: 0 Index_length: 49152 Data_free: 0 Auto_increment: NULL Create_time: 2010-07-09 13:21:49 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 108. row *************************** Name: VehicleModel Engine: InnoDB Version: 10 Row_format: Compact Rows: 55513 Avg_row_length: 1125 Data_length: 62472192 Max_data_length: 0 Index_length: 0 Data_free: 5242880 Auto_increment: 54561 Create_time: 2010-07-09 13:22:19 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: *************************** 109. row *************************** Name: VehicleModelLookup Engine: InnoDB Version: 10 Row_format: Compact Rows: 273576 Avg_row_length: 44 Data_length: 12107776 Max_data_length: 0 Index_length: 13156352 Data_free: 4194304 Auto_increment: NULL Create_time: 2010-07-09 13:21:10 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 109 rows in set (1.06 sec) mysql>