mt-site Commit - 71b3ae5f1390

Clean up SQL table definitions.

darkmorford -

71b3ae5f1390

Not Reviewed

Context file:

Add another comment

Collapse all files

0 unresolved 0 Resolved

0 General 0 Inline

sql/000-baseline-20170612.sql ¶ +11 -11

                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                `name` tinytext,
                PRIMARY KEY (`id`)
-             ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                `default_link` tinytext,
                PRIMARY KEY (`id`),
                UNIQUE KEY `name` (`name`)
-             ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                `description` tinytext,
                PRIMARY KEY (`id`),
                UNIQUE KEY `extension` (`extension`)
-             ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                `name` tinytext,
                PRIMARY KEY (`id`)
-             ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                KEY `halp` (`author`,`imagetype`,`published`),
                CONSTRAINT `rant_ibfk_1` FOREIGN KEY (`author`) REFERENCES `contributor` (`id`) ON UPDATE CASCADE,
                CONSTRAINT `rant_ibfk_2` FOREIGN KEY (`imagetype`) REFERENCES `media_t` (`id`) ON UPDATE CASCADE
-             ) ENGINE=InnoDB AUTO_INCREMENT=1099 DEFAULT CHARSET=utf8;
+             ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                KEY `media` (`media`),
                CONSTRAINT `rant_attachment_ibfk_1` FOREIGN KEY (`rant`) REFERENCES `rant` (`id`) ON UPDATE CASCADE,
                CONSTRAINT `rant_attachment_ibfk_2` FOREIGN KEY (`media`) REFERENCES `media_t` (`id`) ON UPDATE CASCADE
-             ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                `name` tinytext NOT NULL,
                PRIMARY KEY (`id`)
-             ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                UNIQUE KEY `name` (`name`),
                KEY `meta` (`meta`),
                CONSTRAINT `strip_t_ibfk_1` FOREIGN KEY (`meta`) REFERENCES `meta_t` (`id`) ON UPDATE CASCADE
-             ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                KEY `banner` (`banner`),
                CONSTRAINT `support_ibfk_1` FOREIGN KEY (`sponsor`) REFERENCES `sponsor` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
                CONSTRAINT `support_ibfk_2` FOREIGN KEY (`banner`) REFERENCES `banner` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
-             ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                `position` int(10) unsigned NOT NULL,
                `message` varchar(140) DEFAULT NULL,
                PRIMARY KEY (`id`)
-             ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              --
                `oauth_access_token` tinytext,
                PRIMARY KEY (`id`),
                UNIQUE KEY `username` (`username`(100))
-             ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
+             ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
              /*!40101 SET character_set_client = @saved_cs_client */;
              /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

Comments 0

Write
Preview

You need to be logged in to leave comments. Login now

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings