Skip to content

Instantly share code, notes, and snippets.

@PhillipsHoward

PhillipsHoward/tihbault_g_wcs_toulouse.sql

Created November 5, 2018 11:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save PhillipsHoward/ff8018001c0f5c7f4105ef0ac3b35b33 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save PhillipsHoward/ff8018001c0f5c7f4105ef0ac3b35b33 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. PhillipsHoward created this gist Nov 5, 2018.
    61 changes: 61 additions & 0 deletions tihbault_g_wcs_toulouse.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,61 @@
    -- MySQL dump 10.13 Distrib 5.7.24, for Linux (x86_64)
    --
    -- Host: localhost Database: thibault_g_wcs_toulouse
    -- ------------------------------------------------------
    -- Server version 5.7.24-0ubuntu0.18.04.1

    /*!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 utf8 */;
    /*!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: `thibault_g_wcs_toulouse`
    --

    CREATE DATABASE /*!32312 IF NOT EXISTS*/ `thibault_g_wcs_toulouse` /*!40100 DEFAULT CHARACTER SET latin1 */;

    USE `thibault_g_wcs_toulouse`;

    --
    -- Table structure for table `promo_java`
    --

    DROP TABLE IF EXISTS `promo_java`;
    /*!40101 SET @saved_cs_client = @@character_set_client */;
    /*!40101 SET character_set_client = utf8 */;
    CREATE TABLE `promo_java` (
    `Id` int(11) NOT NULL AUTO_INCREMENT,
    `Name` varchar(30) DEFAULT NULL,
    `LastName` varchar(30) DEFAULT NULL,
    `Address` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`Id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
    /*!40101 SET character_set_client = @saved_cs_client */;

    --
    -- Dumping data for table `promo_java`
    --

    LOCK TABLES `promo_java` WRITE;
    /*!40000 ALTER TABLE `promo_java` DISABLE KEYS */;
    INSERT INTO `promo_java` VALUES (1,'Lorie','Ta meilleure amie','8 rue de la chanson de merde'),(2,'Google','IS WATCHING YOU','Station lunaire BX43'),(3,'Zobi','Le Zob','dsjkld'),(4,'Jean','Jean','Jeanville'),(5,'Jean-Baptiste','Emmanuel','Zorg'),(6,'Choupinou','Choupine','Choupinouville');
    /*!40000 ALTER TABLE `promo_java` 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 2018-11-05 12:11:45