Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.59 KB | None | 0 0
  1. DROP TABLE IF EXISTS `player_addons`;
  2. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  3. /*!40101 SET character_set_client = utf8 */;
  4. CREATE TABLE `player_addons` (
  5.   `player_id` int(11) NOT NULL DEFAULT '0',
  6.   `looktype` int(3) NOT NULL DEFAULT '0',
  7.   `addons` int(1) NOT NULL DEFAULT '0',
  8.   UNIQUE KEY `player_id_2` (`player_id`,`looktype`),
  9.   KEY `player_id` (`player_id`),
  10.   CONSTRAINT `player_addons_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
  11. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  12. /*!40101 SET character_set_client = @saved_cs_client */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement