Ytpykawr

1-- phpMyAdmin SQL Dump
2-- version 4.1.7
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Apr 22, 2021 at 07:52 PM
7-- Server version: 8.0.21
8-- PHP Version: 5.6.40
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `my_bigempty`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `banned_users`
27--
28
29-- --------------------------------------------------------
30
31--
32-- Table structure for table `cities`
33--
34
35CREATE TABLE IF NOT EXISTS `Cities` (
36  `cityID` int NOT NULL AUTO_INCREMENT,
37  `cityName` varchar(100) NOT NULL,
38  `cityCountryID` int NOT NULL,
39  PRIMARY KEY (`cityID`),
40  KEY `cityCountryID` (`countryID`)
41) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `countries`
47--
48
49CREATE TABLE IF NOT EXISTS `Countries` (
50  `countryID` int NOT NULL AUTO_INCREMENT,
51  `countryName` varchar(100) NOT NULL,
52  PRIMARY KEY (`countryID`)
53) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
54
55-- --------------------------------------------------------
56
57--
58-- Table structure for table `reviews`
59--
60
61CREATE TABLE IF NOT EXISTS `Reviews` (
62  `reviewID` bigint NOT NULL AUTO_INCREMENT,
63  `reviewEnvironment` float NOT NULL,
64  `reviewEnvironmentDescription` text NOT NULL,
65  `reviewTaxes` float DEFAULT NULL,
66  `reviewTaxesDescription` text,
67  `reviewCOL` float NOT NULL COMMENT 'COL = Cost of Life',
68  `reviewCOLDescription` text,
69  `reviewSecurity` float NOT NULL COMMENT 'Is the city safe?',
70  `reviewSecurityDescription` text,
71  `reviewOverallEvaluation` text NOT NULL,
72  `reviewCreated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
73  `reviewUserID` bigint NOT NULL,
74  `reviewCityID` int NOT NULL,
75  PRIMARY KEY (`reviewID`),
76  KEY `reviewUserID` (`reviewUserID`),
77  KEY `reviewCityID` (`reviewCityID`)
78) ENGINE=InnoDB DEFAULT CHARSET=utf8;
79
80-- --------------------------------------------------------
81
82--
83-- Table structure for table `users`
84--
85
86CREATE TABLE IF NOT EXISTS `Users` (
87  `userID` bigint NOT NULL AUTO_INCREMENT,
88  `userUsername` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
89  `userMail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
90  `userPassword` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
91  `userDeleted_at` tinyint(1),
92  `userCreated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
93  PRIMARY KEY (`userID`)
94) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
95
96--
97-- Constraints for dumped tables
98--
99
100
101-- Constraints for table `cities`
102--
103ALTER TABLE `Cities`
104  ADD CONSTRAINT `cities_fk_1` FOREIGN KEY (`cityCountryID`) REFERENCES `Countries` (`countryID`);
105
106--
107-- Constraints for table `reviews`
108--
109ALTER TABLE `Reviews`
110  ADD CONSTRAINT `reviews_fk_1` FOREIGN KEY (`reviewUserID`) REFERENCES `Users` (`userID`),
111  ADD CONSTRAINT `reviews_fk_2` FOREIGN KEY (`reviewCityID`) REFERENCES `Cities` (`cityID`);
112
113/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
114/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
115/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;