hvad er der vejen med min mysql
jeg får fejlen FejlSQL-forespørgsel :
INSERT INTO `ad_groups`
VALUES (
"2", "Banner Ad (468x60)"
)
MySQL returnerede:
#1062 - Duplicate entry '2' for key 1
her er min sql tekst
#
# Table structure for table `wallpaper_ad_groups`
#
CREATE TABLE wallpaper_ad_groups (
groupid int(10) unsigned NOT NULL default '0',
groupname varchar(255) NOT NULL default '',
PRIMARY KEY (groupid),
UNIQUE KEY groupid (groupid),
KEY groupid_2 (groupid)
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_ad_groups`
#
INSERT INTO `ad_groups` VALUES("2","Banner Ad (468x60)");
INSERT INTO `ad_groups` VALUES("3","Skyscrapper Ad (120x400)");
INSERT INTO `ad_groups` VALUES("4","Box Ad (120x70)");
# --------------------------------------------------------
#
# Table structure for table `wallpaper_admin_control`
#
CREATE TABLE wallpaper_admin_control (
approve_content char(1) default 'Y',
wotwid int(3) unsigned default NULL
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_admin_control`
#
INSERT INTO wallpaper_admin_control VALUES ('Y',121);
# --------------------------------------------------------
#
# Table structure for table `wallpaper_admin_login`
#
CREATE TABLE wallpaper_admin_login (
login varchar(20) default NULL,
password varchar(20) default NULL,
sessionkey int(10) unsigned default NULL
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_admin_login`
#
INSERT INTO wallpaper_admin_login VALUES ('admin kode','admin kode','');
# --------------------------------------------------------
#
# Table structure for table `wallpaper_ads`
#
CREATE TABLE wallpaper_ads (
adid int(10) unsigned NOT NULL default '0',
image varchar(50) default NULL,
url varchar(255) default NULL,
code text,
impressions int(10) unsigned default '0',
clicks int(11) default '0',
groupid int(10) unsigned default NULL,
type char(1) default NULL,
name varchar(255) default NULL,
PRIMARY KEY (adid),
UNIQUE KEY adid (adid),
KEY adid_2 (adid)
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_ads`
#
INSERT INTO wallpaper_ads VALUES (8,NULL,NULL,'<script language="javascript1.2" type="text/javascript" src="http://www.funpageexchange.com/468x60.php?uid=399"></script>',1,'',2,'A','FPE Banner');
INSERT INTO wallpaper_ads VALUES (9,NULL,NULL,'<script language="javascript1.2" type="text/javascript" src="http://www.funpageexchange.com/120x600.php?uid=399"></script>',1,'',3,'A','FPE SkyScrapper');
# --------------------------------------------------------
#
# Table structure for table `wallpaper_categories`
#
CREATE TABLE wallpaper_categories (
categoryid int(10) unsigned NOT NULL default '0',
category varchar(100) default NULL,
PRIMARY KEY (categoryid),
UNIQUE KEY categoryid (categoryid),
KEY categoryid_2 (categoryid)
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_categories`
#
INSERT INTO wallpaper_categories VALUES ('','Misc');
INSERT INTO wallpaper_categories VALUES (2,'Movies');
INSERT INTO wallpaper_categories VALUES (9,'Celebrities');
INSERT INTO wallpaper_categories VALUES (11,'Video Games');
INSERT INTO wallpaper_categories VALUES (6,'Cars');
INSERT INTO wallpaper_categories VALUES (7,'Nature');
INSERT INTO wallpaper_categories VALUES (8,'TV');
# --------------------------------------------------------
#
# Table structure for table `wallpaper_emailed_wallpaper`
#
CREATE TABLE wallpaper_emailed_wallpaper (
sender_email varchar(255) default NULL,
friend_email varchar(255) default NULL,
recipeid int(10) unsigned default NULL
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_emailed_wallpaper`
#
# --------------------------------------------------------
#
# Table structure for table `wallpaper_messages`
#
CREATE TABLE wallpaper_messages (
messageid int(10) unsigned NOT NULL default '0',
wallpaperid int(3) unsigned NOT NULL default '0',
userid int(3) unsigned NOT NULL default '0',
message text,
messagedate varchar(40) default NULL,
PRIMARY KEY (messageid,wallpaperid,userid),
UNIQUE KEY messageid (messageid),
KEY messageid_2 (messageid,wallpaperid,userid)
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_messages`
#
# --------------------------------------------------------
#
# Table structure for table `wallpaper_meta_data`
#
CREATE TABLE wallpaper_meta_data (
wallpaperid int(10) unsigned default NULL,
keyword varchar(255) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_meta_data`
#
# --------------------------------------------------------
#
# Table structure for table `wallpaper_ratings`
#
CREATE TABLE wallpaper_ratings (
wallpaperid int(11) NOT NULL default '0',
rating float(10,2) NOT NULL default '0.00',
ip varchar(50) default NULL
) TYPE=MyISAM;
#
# Table structure for table `wallpaper_search_terms`
#
CREATE TABLE wallpaper_search_terms (
term varchar(255) default NULL,
count int(10) unsigned default '0'
) TYPE=MyISAM;
#
# Table structure for table `wallpaper_sizes_lookup`
#
CREATE TABLE wallpaper_sizes_lookup (
wallpaperid int(10) unsigned NOT NULL default '0',
sizeid int(3) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Table structure for table `wallpaper_subscribers`
#
CREATE TABLE wallpaper_subscribers (
emailaddress varchar(255) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_subscribers`
#
INSERT INTO wallpaper_subscribers VALUES ('pault@ratty.net');
# --------------------------------------------------------
#
# Table structure for table `wallpaper_users`
#
CREATE TABLE wallpaper_users (
userid int(10) unsigned NOT NULL default '0',
login varchar(50) NOT NULL default '',
password varchar(50) NOT NULL default '',
email varchar(255) default NULL,
newsletter int(1) unsigned default NULL,
PRIMARY KEY (userid),
UNIQUE KEY userid (userid,login),
KEY userid_2 (userid,login)
) TYPE=MyISAM;
#
# Table structure for table `wallpaper_wallpaper`
#
CREATE TABLE wallpaper_wallpaper (
wallpaperid int(10) unsigned NOT NULL default '0',
title varchar(255) default NULL,
userid int(10) unsigned default NULL,
rating int(10) unsigned default '0',
categoryid int(10) unsigned default NULL,
date varchar(20) NOT NULL default '',
hits int(10) unsigned default '0',
status char(1) default 'W',
downloads int(10) unsigned default '0',
PRIMARY KEY (wallpaperid),
UNIQUE KEY recipieid (wallpaperid),
KEY recipieid_2 (wallpaperid)
) TYPE=MyISAM;
#
# Table structure for table `wallpaper_wallpaper_sizes`
#
CREATE TABLE wallpaper_wallpaper_sizes (
sizeid int(10) unsigned NOT NULL default '0',
size varchar(255) default '0',
width int(10) unsigned NOT NULL default '0',
height int(10) unsigned NOT NULL default '0',
PRIMARY KEY (sizeid),
UNIQUE KEY sizeid (sizeid),
KEY sizeid_2 (sizeid)
) TYPE=MyISAM;
#
# Dumping data for table `wallpaper_wallpaper_sizes`
#
INSERT INTO wallpaper_wallpaper_sizes VALUES (2,'1280x1024',1280,1024);
INSERT INTO wallpaper_wallpaper_sizes VALUES (3,'1024x768',1024,768);
INSERT INTO wallpaper_wallpaper_sizes VALUES (4,'800x600',800,600);
INSERT INTO wallpaper_wallpaper_sizes VALUES (1,'1600x1200',1600,1200);
