Broblem beim Erstellen einer Tabelle

[joomlaboarder]

hallo zusammen! ich muss eine komponente für joomla manuell installieren. dazu habe ich die sql-befehle aus der installationsdatei extrahiert und wollte sie direkt im phpmyadmin über das sql-eingabefeld eingeben. die befehle lauten:

CREATE TABLE IF NOT EXISTS jos_pollsxt
(id int(11) unsigned NOT NULL auto_increment,
title varchar(100)  NOT NULL default '',
voters int(9) NOT NULL default '0',
checked_out int(11) NOT NULL default '0',
checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
published tinyint(1) NOT NULL default '0',
access int(11) NOT NULL default '0',
lag int(11) NOT NULL default '0',
multivote tinyint(1) default '0',
rdisp tinyint(1) NOT NULL default '0',
rdispb tinyint(1) NOT NULL default '0',
ordering int(11) NOT NULL default '0',
rdispd tinyint(1) NOT NULL default '0',
intro text  NOT NULL,
thanks text  NOT NULL,
logon tinyint(1) NOT NULL default '0',
img_url text ,
imgsize int(11) NOT NULL default '0',
imgor text  NOT NULL,
imglink tinyint(1) NOT NULL default '0',
css varchar(20)  NOT NULL default 'poll_bars',
datefrom date NOT NULL default '0000-00-00',
dateto date NOT NULL default '0000-00-00',
type tinyint(1) NOT NULL default '0',
maxwidth int(3) NOT NULL default '294',
sh_numvote tinyint(1) NOT NULL default '0',
sh_flvote tinyint(1) NOT NULL default '0',
sh_abs tinyint(1) NOT NULL default '0',
sh_perc tinyint(1) NOT NULL default '0',
email tinyint(1) NOT NULL default '0',
subject varchar(80)  NOT NULL default '',
emailtext text  NOT NULL,
goto tinyint(1) NOT NULL default '0',
goto_url varchar(100)  NOT NULL default '',
PRIMARY KEY  (id))

CREATE TABLE IF NOT EXISTS jos_pollsxt_options
(id int(11) NOT NULL auto_increment,
quid int(11) NOT NULL default '0',
qoption text  NOT NULL,
img_url text ,
imgsize int(11) NOT NULL default '0',
imgor text  NOT NULL,
imglink tinyint(1) NOT NULL default '0',
freetext tinyint(1) NOT NULL default '0',
newopt tinyint(1) NOT NULL default '0',
inact tinyint(1) NOT NULL default '0',
PRIMARY KEY  (id))

CREATE TABLE IF NOT EXISTS jos_pollsxt_questions
(id int(11) NOT NULL auto_increment,
pollid int(11) NOT NULL default '0',
title text  NOT NULL,
type tinyint(1) NOT NULL default '0',
img_url text ,
imgsize int(11) NOT NULL default '0',
imgor text  NOT NULL,
imglink tinyint(1) NOT NULL default '0',
obli tinyint(1) NOT NULL default '0',
multisize char(3)  NOT NULL default '',
inact tinyint(1) NOT NULL default '0',
PRIMARY KEY  (id))

CREATE TABLE IF NOT EXISTS jos_pollxt_config
(id tinyint(1) NOT NULL auto_increment,
version varchar(10)  NOT NULL default '',
xt_disp tinyint(1) NOT NULL default '0',
xt_hide tinyint(1) NOT NULL default '0',
xt_selpo tinyint(1) NOT NULL default '0',
xt_publ tinyint(1) NOT NULL default '0',
xt_order tinyint(1) NOT NULL default '0',
xt_imgvote varchar(80)  NOT NULL default '',
xt_imgresult varchar(80)  NOT NULL default '',
xt_maxcolors tinyint(1) NOT NULL default '0',
xt_height tinyint(2) NOT NULL default '0',
xt_orderby varchar(10)  NOT NULL default '',
xt_asc varchar(4)  NOT NULL default '',
xt_seccookie tinyint(1) NOT NULL default '0',
xt_secip tinyint(1) NOT NULL default '0',
xt_secuname tinyint(1) NOT NULL default '0',
PRIMARY KEY  (id))

CREATE TABLE jos_pollxt_data
(id int(11) NOT NULL auto_increment,
optid int(11) NOT NULL default '0',
ip text  NOT NULL,
user text  NOT NULL,
datu datetime NOT NULL default '0000-00-00 00:00:00',
value varchar(100)  NOT NULL default '',
mailkey varchar(100)  NOT NULL default '',
block tinyint(1) NOT NULL default '0',
PRIMARY KEY  (id))

CREATE TABLE jos_pollxt_menu
(pollid int(11) NOT NULL default '0',
menuid int(11) NOT NULL default '0',
PRIMARY KEY  (pollid,menuid))

INSERT INTO `jos_pollsxt` VALUES
(1, 'Sample Poll', 2, 0, '0000-00-00 00:00:00',
1, 0, 86400, 0, 3, 1, 1, 1,
'This is a sample poll', '', 0, '/asterisk.png',
100, 'width', 0, '', '0000-00-00', '0000-00-00',
0, 300, 1, 0, 0, 1, 0, '', '', 0, '')

INSERT INTO `jos_pollsxt_options` VALUES (1,
1, 'yes', '', 100, 'width', 0, 0, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (2,
2, 'Cherries', '/fruit/cherry.jpg', 30, 'width', 1, 0, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (3,
1, 'no', '', 0, 'width', 0, 0, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (4,
2, 'Strawberrys', '/fruit/strawberry.jpg', 30, 'width', 0, 0, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (5,
2, 'Something else', '', 0, 'width', 0, 1, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (6,
3, 'PollXT is cool', '', 0, 'width', 0, 0, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (7,
3, 'I like MamboXT', '', 0, 'width', 0, 0, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (8,
3, 'The standard poll is crap', '', 0, 'width', 0, 0, 0, 0)
INSERT INTO `jos_pollsxt_options` VALUES (9,
3, 'I''ll try StaticXT, too', '', 0, 'width', 0, 0, 0, 0)
INSERT INTO `jos_pollsxt_questions` VALUES (1,
1, 'A question with radio buttons... like it?', 1, '', 100, 'width', 0, 0, '', 0)
INSERT INTO `jos_pollsxt_questions` VALUES (2,
1, 'Now some checkboxes with pictures, do you like...', 2, '', 100, 'width', 0, 0, '', 0)
INSERT INTO `jos_pollsxt_questions` VALUES (3,
1, 'Select as much as you''d like to...', 4, '/clock.jpg', 30, 'width', 0, 1, '3', 0)
INSERT INTO `jos_pollxt_menu` VALUES (1, 0)
INSERT INTO `jos_pollxt_config` VALUES (1,
'1.20b3', 1, 0, 0, 0, 1, '', '', 5, 5, 'hits', 'ASC', 0, 1, 1 ) 

phpmyadmin sagt aber:

Fehler

SQL-Befehl:

CREATE TABLE IF NOT EXISTS jos_pollsxt(
id int( 11 ) unsigned NOT NULL AUTO_INCREMENT ,

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

die phpmyadmin version ist 2.9.2
kann sich jemand mal die sql-befehle ansehen, bzw. hat jemand einen tipp, wie das klappen könnte?

vielen herzlichen dank schonmal!

[asp2php]

Lesen http://www.php-resource.de/forum/sho...threadid=47906

[joomlaboarder]

sorry, ich vermute mal, die horizontalen scrollbalken haben gestört. da mein bildschirm eine relativ hohe auflösung hat, ist mir das nicht aufgefallen. ich habe jetzt einfach die zeilen getrennt.

also - vielleicht kann jetzt mal jemand durchschauen ... ich würde mich riesig über einen tipp freuen! vielen dank!