Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SHOW CREATE TABLE users; +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | TABLE | CREATE TABLE |
- +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | users | CREATE TABLE `users` (
- `uid` INT(10) NOT NULL AUTO_INCREMENT,
- `fname` VARCHAR(255) NOT NULL,
- `lname` VARCHAR(255) NOT NULL,
- PRIMARY KEY (`uid`)
- ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 |
- +-------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 1 ROW IN SET (0.00 sec)
- mysql> SHOW CREATE TABLE follows;
- +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | TABLE | CREATE TABLE |
- +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- | follows | CREATE TABLE `follows` (
- `user_id` INT(10) NOT NULL,
- `follow_id` INT(10) NOT NULL,
- KEY `user_id` (`user_id`,`follow_id`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
- +---------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+
- 1 ROW IN SET (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement