SHOW CREATE TABLEs

[Jaap Vermeer]

Wow thanks Rick, that is very informative.
I will work trough them one by one.

here are the create tables:

mysql> SHOW CREATE TABLE GroupStructure;
+----------------+---------------------------------------------------------------------------+
| Table          | Create Table                                                                                                                                                |
+----------------+---------------------------------------------------------------------------+
| GroupStructure | CREATE TABLE `GroupStructure` (
  `gc` smallint(6) DEFAULT NULL,
  `sgc` smallint(6) DEFAULT NULL,
  KEY `gsgc` (`gc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+----------------+---------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE Groups;
+--------+---------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                              |
+--------+---------------------------------------------------------------------------------------------------------+
| Groups | CREATE TABLE `Groups` (
  `gl` tinyint(4) DEFAULT NULL,
  `gc` smallint(6) DEFAULT NULL,
  `gd` varchar(255) DEFAULT NULL,
  KEY `ggcgl` (`gc`,`gl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+--------+---------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE VCG2LU;
+--------+-------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                                  |
+--------+-------------------------------------------------------------------------------------------------------------+
| VCG2LU | CREATE TABLE `VCG2LU` (
  `vcc` smallint(6) DEFAULT NULL,
  `gc` smallint(6) DEFAULT NULL,
  `luc` mediumint(9) DEFAULT NULL,
  KEY `vccgc` (`vcc`,`gc`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+--------+-------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE SegmentsVCG2LU;
+----------------+-------------------------------------------------------------------------------------------------+
| Table          | Create Table                                                                                                                                                                                                                                                        |
+----------------+-------------------------------------------------------------------------------------------------+
| SegmentsVCG2LU | CREATE TABLE `SegmentsVCG2LU` (
  `vcc` smallint(6) DEFAULT NULL,
  `smc` smallint(6) DEFAULT NULL,
  `myc` smallint(6) DEFAULT NULL,
  `vc` smallint(6) DEFAULT NULL,
  `vd` varchar(255) DEFAULT NULL,
  KEY `svd` (`vd`(8))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+----------------+-------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE Subjects;
+----------+-------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                        |
+----------+-------------------------------------------------------------------------------------------------------------------+
| Subjects | CREATE TABLE `Subjects` (
  `lul` tinyint(4) DEFAULT NULL,
  `luc` mediumint(9) DEFAULT NULL,
  `lus` varchar(255) DEFAULT NULL,
  KEY `sluclul` (`luc`,`lul`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+----------+-------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> SHOW CREATE TABLE VehicleContexts;
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| Table           | Create Table                                                                                                                                                                                                                |
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------+
| VehicleContexts | CREATE TABLE `VehicleContexts` (
  `vcc` smallint(6) DEFAULT NULL,
  `vc` smallint(6) DEFAULT NULL,
  `ec` tinyint(4) DEFAULT NULL,
  `tc` tinyint(4) DEFAULT NULL,
  KEY `ec1` (`ec`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-----------------+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)