mysql> show create table server_messages \G *************************** 1. row *************************** Table: server_messages Create Table: CREATE TABLE `server_messages` ( `id` bigint(20) NOT NULL auto_increment, `reference` bigint(20) NOT NULL, `source` int(11) NOT NULL, `key_` int(11) NOT NULL, `value` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> show create table messages_and_servers \G *************************** 1. row *************************** Table: messages_and_servers Create Table: CREATE TABLE `messages_and_servers` ( `message` bigint(20) NOT NULL, `server` int(11) NOT NULL, KEY `message` (`message`), KEY `server` (`server`), CONSTRAINT `messages_and_servers_ibfk_1` FOREIGN KEY (`message`) REFERENCES `server_messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `messages_and_servers_ibfk_2` FOREIGN KEY (`server`) REFERENCES `servers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> show create table servers \G *************************** 1. row *************************** Table: servers Create Table: CREATE TABLE `servers` ( `id` int(11) NOT NULL auto_increment, `name` varchar(64) NOT NULL, `ip_address` varchar(15) NOT NULL, `port` smallint(6) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> show table status; +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------------------------------+ | accounts | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`id`) REFER `readytalk/entities`(`id`) ON UPDATE CASCADE; | | allowed_talkers | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | archive_filegroup | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | 1 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`archive_id`) REFER `readytalk/archives`(`id`) ON DELETE | | archives | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | audio_sessions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | blacklist | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`listed`) REFER `readytalk/servers`(`id`) ON UPDATE CASCA | | brand_filegroups | InnoDB | 10 | Compact | 91 | 180 | 16384 | 0 | 16384 | 0 | 92 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | brand_names | InnoDB | 10 | Compact | 27 | 606 | 16384 | 0 | 32768 | 0 | 28 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`brand_id`) REFER `readytalk/brands`(`id`) ON UPDATE CASC | | brands | InnoDB | 10 | Compact | 107 | 918 | 98304 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`id`) REFER `readytalk/entities`(`id`) ON UPDATE CASCADE | | chat_archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | chat_log | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | conference_archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | conferences | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | contacts | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 16384 | 0 | 2 | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | conversion_servers | InnoDB | 10 | Compact | 2 | 8192 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`group_`) REFER `readytalk/groups`(`server`) ON UPDATE CA | | entities | InnoDB | 10 | Compact | 139 | 117 | 16384 | 0 | 0 | 0 | 140 | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | filegroups | InnoDB | 10 | Compact | 22 | 744 | 16384 | 0 | 0 | 0 | 23 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | filegroups_files | InnoDB | 10 | Compact | 395 | 124 | 49152 | 0 | 32768 | 0 | 397 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`filegroup_id`) REFER `readytalk/filegroups`(`id`) ON DEL | | files | InnoDB | 10 | Compact | 427 | 191 | 81920 | 0 | 16384 | 0 | 398 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`mimetype_id`) REFER `readytalk/mimetypes`(`id`) | | groups | InnoDB | 10 | Compact | 3 | 5461 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`server`) REFER `readytalk/servers`(`id`) ON UPDATE CASCA | | guest_archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | guests | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`user`) REFER `readytalk/users`(`id`) ON UPDATE CASCADE | | machines | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`server`) REFER `readytalk/servers`(`id`) ON UPDATE CASCA | | machines_and_groups | InnoDB | 10 | Compact | 12 | 1365 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`machine`) REFER `readytalk/machines`(`server`) ON UPDATE | | messages | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | messages_and_servers | InnoDB | 10 | Compact | 80 | 204 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`message`) REFER `readytalk/server_messages`(`id`) ON UPD | | messages_and_users | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`message`) REFER `readytalk/messages`(`id`) ON UPDATE CAS | | mimetypes | InnoDB | 10 | Compact | 8 | 2048 | 16384 | 0 | 0 | 0 | 9 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | organizations | InnoDB | 10 | Compact | 1 | 16384 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`id`) REFER `readytalk/entities`(`id`) ON UPDATE CASCADE; | | owner_archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | owners | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`user`) REFER `readytalk/users`(`id`) ON UPDATE CASCADE | | preferences | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | recording_archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | recording_registration | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`recording_id`) REFER `readytalk/recording_archive`(`id`) | | recordings | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | server_messages | InnoDB | 10 | Compact | 14 | 1170 | 16384 | 0 | 0 | 0 | 15 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | server_properties | InnoDB | 10 | Compact | 5 | 3276 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`server`) REFER `readytalk/servers`(`id`) ON UPDATE CASCA | | servers | InnoDB | 10 | Compact | 10 | 1638 | 16384 | 0 | 16384 | 0 | 11 | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | services | InnoDB | 10 | Compact | 7 | 2340 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | services_available | InnoDB | 10 | Compact | 9 | 1820 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`server`) REFER `readytalk/servers`(`id`) ON UPDATE CASCA | | services_provided | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 49152 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`provider`) REFER `readytalk/servers`(`id`) ON UPDATE CAS | | services_required | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 32768 | 0 | NULL | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`dependency`) REFER `readytalk/servers`(`id`) ON UPDATE C | | sessions | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | slide_conversion_states | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | slide_locks | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | | slideset_filegroup | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 65536 | 0 | 5 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`slideset_id`) REFER `readytalk/slidesets`(`id`) ON DELET | | slideset_individual | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 0 | 5 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | slidesets | InnoDB | 10 | Compact | 4 | 4096 | 16384 | 0 | 0 | 0 | 5 | 2006-02-02 17:59:53 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | user_archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | user_conference_archive | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB | | users | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2006-02-02 17:59:52 | NULL | NULL | latin1_swedish_ci | NULL | | InnoDB free: 9216 kB; (`account`) REFER `readytalk/accounts`(`id`) ON UPDATE CAS | +-------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+----------------------------------------------------------------------------------+ 51 rows in set (0.01 sec)