Odp: Wodbo
Ja mam taki b?ad jak dodaje datbase.sql do bazy:
B??d
zapytanie SQL:
-- phpMyAdmin SQL Dump
-- version 2.11.7
--
--
-- Host: localhost
-- Czas wygenerowania: 30 Lip 2009, 09:51
-- Wersja serwera: 5.0.51
-- Wersja PHP: 5.2.6
--
-- Baza danych: `sparking`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`id` int( 11 ) unsigned NOT NULL default '0',
`password` varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
`premDays` int( 11 ) NOT NULL default '0',
`premEnd` int( 11 ) NOT NULL default '0',
`email` varchar( 50 ) COLLATE latin1_general_ci NOT NULL default '',
`rlname` varchar( 45 ) COLLATE latin1_general_ci NOT NULL default '',
`location` varchar( 45 ) COLLATE latin1_general_ci NOT NULL default '',
`recovery_key` varchar( 20 ) COLLATE latin1_general_ci NOT NULL ,
`hide` tinyint( 1 ) NOT NULL default '0',
`hidemail` tinyint( 1 ) NOT NULL default '0',
KEY `accno` ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci;
MySQL zwr?ci? komunikat:
#1064 - Something is wrong in your syntax obok 'collate latin1_general_ci NOT NULL default '',
`premDays` i' w linii 3
PROSZE o dobry databasa.sql