-- MariaDB dump 10.18 Distrib 10.5.8-MariaDB, for osx10.15 (x86_64) -- -- Host: localhost Database: wb16261_terminology -- ------------------------------------------------------ -- Server version 10.3.12-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `wb16261_terminology` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `wb16261_terminology` /*!40100 DEFAULT CHARACTER SET utf8mb4 */; USE `wb16261_terminology`; -- -- Table structure for table `rarted` -- DROP TABLE IF EXISTS `rarted`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rarted` ( `title` varchar(33) DEFAULT NULL, `section_id` varchar(11) DEFAULT NULL, `words` varchar(437) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rarted` -- LOCK TABLES `rarted` WRITE; /*!40000 ALTER TABLE `rarted` DISABLE KEYS */; INSERT INTO `rarted` VALUES ('Authentic/Official figures','official','A figure that is produced and owned by Hasbro/Takara Tomy'),('Bayverse','bayverse','The series of live-action movies, directed by the famous auteur Michael Bay.'),('Counterfeit figures','counterfeit','Figures that are designed to look identical to the original. It\'s not uncommon for eBay sellers to try and pass counterfeit figures off as authentic ones'),('Hasbro','hasbro','The company that owns and manages the Transformers IP.'),('Hastak','hastak','A popular abbreviation of Hasbro/Takara Tomy.

'),('Knockoffs','knockoffs','Knockoffs are illegally produced figures that copy another figure\'s design. Knockoffs of mainline figures are generally poor quality substitutes, however companies like Wei Jiang and Black Mamba are known to create knockoffs which significantly improve on the original.'),('Mainline figures','mainline','Figures that can be found in most toy stores. The quality is consistent but average, and the prices usually range from $10 to $60 USD.'),('Masterpiece figures (\"MP\")','masterpiece','High end Transformers toys targeted at collectors, that usually sit around the $100-$200 price mark. Since Hastak have the rights to \"Masterpiece\" and \"MP\", knockoff companies like Wei Jiang identify their oversized masterpiece figures in a similar way, like \"MPP\".'),('Masterpiece Movie figures (\"MPM\")','mpm','A spinoff of the Masterpiece line, featuring figures from the Bayverse.'),('Masterpiece scale','mpscale','Masterpiece scale is a very broad term. Masterpiece figures are usually at the 1:30 scale mark, however mpm07 Bumblebee is way too big, at 1:22 scale, and mpm04 Optimus Prime is too small, at 1:34 scale. It\'s common for knockoff Masterpiece figures to be oversized, to make the scale more-or-less accurate.'),('Oversized (\"OS\")','oversized','When a company makes a knockoff, it\'s common for them to change the size of a figure so that it matches a specific scale. It\'s very unorthodox for Hastak to make an oversized figure'),('Takara Tomy','takaratomy','The company that Hasbro contracts to design Transformers figures. Hasbro and Takara both produce the figures, and the Takara version normally has far better paint applications.'),('Third Party figures (\"3P\")','thirdparty','A figure that uses the Transformers IP, but has original engineering. Third Party figures are normally designed to fit in with official Masterpiece figures.'); /*!40000 ALTER TABLE `rarted` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-02-11 10:58:18