I'm making a SAMP server, with all the info of bans and bought vehicles in a MySQL database to get easy acces to it and to change it easily.
But setting it up wast that easy :/
Here is the MySQL info, can some1 please help me here?
-- phpMyAdmin SQL Dump
-- version 3.3.8
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:7778
-- Erstellungszeit: 12. Februar 2012 um 04:02
-- Server Version: 5.1.49
-- PHP-Version: 5.3.3-7+squeeze3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- Datenbank: `samp43_cnr`
--
CREATE DATABASE `samp43_cnr` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `samp43_cnr`;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `autobahn`
--
DROP TABLE IF EXISTS `autobahn`;
CREATE TABLE IF NOT EXISTS `autobahn` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`vehicleid` int(11) NOT NULL,
`vehicleowner` varchar(24) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2232 ;
--
-- Daten für Tabelle `autobahn`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `bans`
--
DROP TABLE IF EXISTS `bans`;
CREATE TABLE IF NOT EXISTS `bans` (
`user_banned` varchar(24) NOT NULL,
`user_banned_ip` varchar(16) NOT NULL,
`user_banner` varchar(24) NOT NULL,
`ban_reason` varchar(60) NOT NULL,
`ban_date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Daten für Tabelle `bans`
--
INSERT INTO `bans` (`user_banned`, `user_banned_ip`, `user_banner`, `ban_reason`, `ban_date`) VALUES
If i press OK, it gives me error #1007 - Can't create database 'samp43_cnr'; database exists
Any help please...