Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.7.4
- -- https://www.phpmyadmin.net/
- --
- -- Host: localhost
- -- Generation Time: Jan 24, 2018 at 03:04 AM
- -- Server version: 10.1.28-MariaDB
- -- PHP Version: 7.1.11
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET AUTOCOMMIT = 0;
- START TRANSACTION;
- SET time_zone = "+00:00";
- /*!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 utf8mb4 */;
- --
- -- Database: `dgsql10`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `fahrzeuge`
- --
- CREATE TABLE `fahrzeuge` (
- `id` int(6) NOT NULL,
- `hersteller` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
- `modell` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
- `baujahr` int(6) DEFAULT NULL,
- `motor` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `fahrzeugart` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `kraftstoff` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `getriebeart` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `farbe` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
- `einkaufspreis` int(20) DEFAULT NULL,
- `verkaufspreis` int(20) DEFAULT NULL,
- `kilometerstand` int(7) DEFAULT NULL,
- `leistung` int(4) DEFAULT NULL,
- `allrad` tinyint(1) DEFAULT NULL,
- `alufelgen` tinyint(1) DEFAULT NULL,
- `anhaengerkupplung` tinyint(1) DEFAULT NULL,
- `abs1` tinyint(1) DEFAULT NULL,
- `einparkhilfe` tinyint(1) DEFAULT NULL,
- `elektrischesitze` tinyint(1) DEFAULT NULL,
- `esp` tinyint(1) DEFAULT NULL,
- `wegfahrsperre` tinyint(1) DEFAULT NULL,
- `fensterheber` tinyint(1) DEFAULT NULL,
- `klimaanlage` tinyint(1) DEFAULT NULL,
- `lederausstattung` tinyint(1) DEFAULT NULL,
- `metallic` tinyint(1) DEFAULT NULL,
- `mittelsitzgruppe` tinyint(1) DEFAULT NULL,
- `mwst` tinyint(1) DEFAULT NULL,
- `navigation` tinyint(1) DEFAULT NULL,
- `partikelfilter` tinyint(1) DEFAULT NULL,
- `schiebedach` tinyint(1) DEFAULT NULL,
- `servolenkung` tinyint(1) DEFAULT NULL,
- `sitzheizung` tinyint(1) DEFAULT NULL,
- `standheizung` tinyint(1) DEFAULT NULL,
- `tempomat` tinyint(1) DEFAULT NULL,
- `xenon` tinyint(1) DEFAULT NULL,
- `zv` tinyint(1) DEFAULT NULL,
- `lieferant_ref` int(6) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- --
- -- Dumping data for table `fahrzeuge`
- --
- INSERT INTO `fahrzeuge` (`id`, `hersteller`, `modell`, `baujahr`, `motor`, `fahrzeugart`, `kraftstoff`, `getriebeart`, `farbe`, `einkaufspreis`, `verkaufspreis`, `kilometerstand`, `leistung`, `allrad`, `alufelgen`, `anhaengerkupplung`, `abs1`, `einparkhilfe`, `elektrischesitze`, `esp`, `wegfahrsperre`, `fensterheber`, `klimaanlage`, `lederausstattung`, `metallic`, `mittelsitzgruppe`, `mwst`, `navigation`, `partikelfilter`, `schiebedach`, `servolenkung`, `sitzheizung`, `standheizung`, `tempomat`, `xenon`, `zv`, `lieferant_ref`) VALUES
- (4, 'Volkswagen', 'T3', 1999, '1.9TDI', 'van', 'Diesel', 'Manuell', 'weiss', 20000, 22000, 129302, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
- (5, 'BMW', 'M3 E92', 2010, '4.2 V8', 'Coupé', 'Benzin', 'DKG', 'Silber', 70000, 75000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `fahrzeuge`
- --
- ALTER TABLE `fahrzeuge`
- ADD PRIMARY KEY (`id`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `fahrzeuge`
- --
- ALTER TABLE `fahrzeuge`
- MODIFY `id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
- COMMIT;
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement