mysql> show create table file; +-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------+ | Table | Create Table | +-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------+ | file | CREATE TABLE `file` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `dir` bigint(20) NOT NULL, `name` bigint(20) NOT NULL, `size` bigint(20) NOT NULL, `mod` datetime NOT NULL, `deleted` bit(1) NOT NULL, PRIMARY KEY (`id`), KEY `dir` (`dir`), KEY `name` (`name`), KEY `filesize` (`size`), CONSTRAINT `file_ibfk_1` FOREIGN KEY (`dir`) REFERENCES `directory` (`id`), CONSTRAINT `file_ibfk_2` FOREIGN KEY (`name`) REFERENCES `NameList` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=20801 DEFAULT CHARSET=utf8 | +-------+----------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------------------------------------------+ 1 row in set (0.00 sec) mysql>