Created
November 25, 2013 17:26
-
-
Save kaiohken1982/7645060 to your computer and use it in GitHub Desktop.
cdcol db xampp
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- phpMyAdmin SQL Dump | |
-- version 3.5.2.2 | |
-- http://www.phpmyadmin.net | |
-- | |
-- Host: 127.0.0.1 | |
-- Generato il: Nov 25, 2013 alle 18:23 | |
-- Versione del server: 5.5.27 | |
-- Versione PHP: 5.4.7 | |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; | |
SET time_zone = "+00:00"; | |
-- | |
-- Database: `cdcol` | |
-- | |
-- -------------------------------------------------------- | |
-- | |
-- Struttura della tabella `cds` | |
-- | |
CREATE TABLE IF NOT EXISTS `cds` ( | |
`titel` varchar(200) COLLATE latin1_general_ci DEFAULT NULL, | |
`interpret` varchar(200) COLLATE latin1_general_ci DEFAULT NULL, | |
`jahr` int(11) DEFAULT NULL, | |
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, | |
PRIMARY KEY (`id`) | |
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ; | |
-- | |
-- Dump dei dati per la tabella `cds` | |
-- | |
INSERT INTO `cds` (`titel`, `interpret`, `jahr`, `id`) VALUES | |
('Beauty', 'Ryuichi Sakamoto', 1990, 1), | |
('Goodbye Country (Hello Nightclub)', 'Groove Armada', 2001, 4), | |
('Glee', 'Bran Van 3000', 1997, 5); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment