Root/
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | -- ---------------------------------------------------------- Host: 127.0.0.1-- Server version: 5.5.40-0+wheezy1-log - (Debian)-- Server OS: debian-linux-gnu-- HeidiSQL Version: 8.0.0.4396-- --------------------------------------------------------/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET NAMES utf8 */;/*!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' */;-- Dumping database structure for test2CREATE DATABASE IF NOT EXISTS `test2` /*!40100 DEFAULT CHARACTER SET latin1 */;USE `test2`;-- Dumping structure for table test2.colorsCREATE TABLE IF NOT EXISTS `colors` ( `id` int(10) NOT NULL AUTO_INCREMENT, `color` varchar(50) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- Data exporting was unselected.-- Dumping structure for table test2.flavorsCREATE TABLE IF NOT EXISTS `flavors` ( `id` int(10) NOT NULL AUTO_INCREMENT, `flavor` varchar(50) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- Data exporting was unselected.-- Dumping structure for table test2.usersCREATE TABLE IF NOT EXISTS `users` ( `id` int(10) NOT NULL AUTO_INCREMENT, `username` varchar(50) DEFAULT '0', `admin` varchar(50) DEFAULT '0', `color_id` int(11) DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- Data exporting was unselected.-- Dumping structure for table test2.user_flavorsCREATE TABLE IF NOT EXISTS `user_flavors` ( `id` int(10) NOT NULL AUTO_INCREMENT, `flavor_id` int(10) NOT NULL DEFAULT '0', `user_id` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;-- Data exporting was unselected./*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
