Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement