· 6 years ago · Dec 04, 2019, 04:56 PM
1-- MariaDB dump 10.17 Distrib 10.4.10-MariaDB, for Linux (x86_64)
2--
3-- Host: irkm0xtlo2pcmvvz.chr7pe7iynqr.eu-west-1.rds.amazonaws.com Database:
4-- ------------------------------------------------------
5-- Server version 5.7.26-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `prrj6w44gg1bany0`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `prrj6w44gg1bany0` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
23
24USE `prrj6w44gg1bany0`;
25
26--
27-- Table structure for table `beaches`
28--
29
30DROP TABLE IF EXISTS `beaches`;
31/*!40101 SET @saved_cs_client = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `beaches` (
34 `id` int(11) NOT NULL AUTO_INCREMENT,
35 `name` varchar(100) NOT NULL,
36 `city` varchar(40) NOT NULL,
37 `latitude` float NOT NULL,
38 `longitude` float NOT NULL,
39 `orientation` varchar(5) NOT NULL,
40 `park` tinyint(1) NOT NULL DEFAULT '0',
41 `lifeguard` tinyint(1) NOT NULL,
42 `dogs_allowed` tinyint(1) NOT NULL,
43 `summer_crowding` char(12) NOT NULL,
44 `photo` varchar(255) NOT NULL,
45 `province` char(2) NOT NULL,
46 `food_service` tinyint(1) NOT NULL,
47 PRIMARY KEY (`id`)
48) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
49/*!40101 SET character_set_client = @saved_cs_client */;
50
51--
52-- Dumping data for table `beaches`
53--
54
55LOCK TABLES `beaches` WRITE;
56/*!40000 ALTER TABLE `beaches` DISABLE KEYS */;
57INSERT INTO `beaches` (`id`, `name`, `city`, `latitude`, `longitude`, `orientation`, `park`, `lifeguard`, `dogs_allowed`, `summer_crowding`, `photo`, `province`, `food_service`) VALUES (2,'Cala Banana','Olbia',40.9605,9.58081,'Est',1,0,1,'Deserta','https://media-cdn.tripadvisor.com/media/photo-s/10/b7/d1/19/cala-banana.jpg','SS',0),(3,'Santa Maria Navarrese','Santa Maria Navarrese',39.9844,9.6808,'Est',0,1,0,'Affollata','https://www.traccedisardegna.it/sites/default/files/styles/copertina/public/logo/thumbnail_3_0.jpg?itok=lJpfRlaQ','NU',1),(4,'Funtanazza','Arbus',39.6136,8.46675,'Ovest',1,1,0,'Frequentata','http://www.manifestosardo.org/wp-content/uploads/2015/09/colonia-marina-francesco-sartori-funtanazza-prov-medio-campidano.jpg','SU',0),(5,'La Sciumara','Palau',41.181,9.37897,'Nord',1,1,0,'Affollata','https://gallura.r.worldssl.net/wp-content/uploads/2018/05/palau_-sciumara-777x437.jpg','SS',1),(6,'Poetto','Cagliari',39.206,9.16437,'Sud',1,1,1,'Affollata','http://www.cagliariturismo.it/public/biz_editor/Image/places/0000255/img_2121.jpg','CA',1),(7,'Su Giudeu','Pula',38.9024,8.85067,'Nord',1,1,0,'Affollata','https://siviaggia.files.wordpress.com/2019/02/spiaggia-di-su-giudeu.jpg','CA',0),(8,'Masua','Masua',39.3319,8.42377,'Ovest',0,1,0,'Affollata','https://siviaggia.files.wordpress.com/2018/03/spiaggia-di-masua-iglesias.jpg','SU',0),(9,'Scivu','Arbus',39.4967,8.41322,'Ovest',1,1,0,'Frequentata','https://www.sardegnaturismo.it/sites/default/files/galleria/ssk_202710607_scivu_elisa_locci_rsz.jpg','SU',0),(10,'Is Arutas','Cabras',39.94,8.39273,'Ovest',1,1,0,'Affollata','https://www.sardegnaturismo.it/sites/default/files/galleria/ssk_339430253_sinis_is_arutas_juris_saulkalns_rsz.jpg','OR',1),(11,'nome della spiaggia','cagliari',12,12,'Nord',1,0,0,'0','https://siviaggia.files.wordpress.com/2019/02/spiaggia-di-su-giudeu.jpg?w=786&strip=all&quality=90&zoom=2','ca',0);
58/*!40000 ALTER TABLE `beaches` ENABLE KEYS */;
59UNLOCK TABLES;
60
61--
62-- Table structure for table `student`
63--
64
65DROP TABLE IF EXISTS `student`;
66/*!40101 SET @saved_cs_client = @@character_set_client */;
67/*!40101 SET character_set_client = utf8 */;
68CREATE TABLE `student` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
71 `phone` int(10) NOT NULL,
72 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
73 PRIMARY KEY (`id`)
74) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
75/*!40101 SET character_set_client = @saved_cs_client */;
76
77--
78-- Dumping data for table `student`
79--
80
81LOCK TABLES `student` WRITE;
82/*!40000 ALTER TABLE `student` DISABLE KEYS */;
83INSERT INTO `student` (`id`, `name`, `phone`, `email`) VALUES (1,'Fabio',12345,'fabio@email.com'),(2,'Salvatore ',4859723,'salvatore@email.com'),(3,'Val Mercenaro',2147483647,'mercenaro.valentina@gmail.com');
84/*!40000 ALTER TABLE `student` ENABLE KEYS */;
85UNLOCK TABLES;
86/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
87
88/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
89/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
90/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
91/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
92/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
93/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
94/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
95
96-- Dump completed on 2019-12-04 17:50:46