klas19
2001-07-08, 14:57
Jag ska skapa tabeller i PhpMyAdmin men, det går inte. Någon som kan se vad det kan vara för fel:
# MySQL dump 8.10
#
# Host: localhost Database: phptop
#--------------------------------------------------------
# Server version 3.23.25-beta-debug
#
# Table structure for table 'top_cats'
#
CREATE TABLE top_cats (
cid int(11) NOT NULL auto_increment,
catname varchar(255),
PRIMARY KEY (cid),
UNIQUE catname (catname)
);
#
# Dumping data for table 'top_cats'
#
INSERT INTO top_cats VALUES (1,'Animals');
INSERT INTO top_cats VALUES (2,'Arts');
INSERT INTO top_cats VALUES (3,'Books');
INSERT INTO top_cats VALUES (4,'Business');
INSERT INTO top_cats VALUES (5,'Cars');
INSERT INTO top_cats VALUES (6,'Celebrities');
INSERT INTO top_cats VALUES (7,'Chat');
INSERT INTO top_cats VALUES (8,'Clipart');
INSERT INTO top_cats VALUES (9,'Collectibles');
INSERT INTO top_cats VALUES (10,'Communities');
INSERT INTO top_cats VALUES (11,'Computers');
INSERT INTO top_cats VALUES (12,'Contests');
INSERT INTO top_cats VALUES (13,'Cool sites');
INSERT INTO top_cats VALUES (14,'Crafts');
INSERT INTO top_cats VALUES (15,'Desktop Themes');
INSERT INTO top_cats VALUES (16,'Dogs');
INSERT INTO top_cats VALUES (17,'Education');
INSERT INTO top_cats VALUES (18,'Entertainment');
INSERT INTO top_cats VALUES (19,'Essays');
INSERT INTO top_cats VALUES (20,'Finance');
INSERT INTO top_cats VALUES (21,'Fonts');
INSERT INTO top_cats VALUES (22,'Free Cash');
INSERT INTO top_cats VALUES (23,'Free Mail');
INSERT INTO top_cats VALUES (24,'Freestuff');
INSERT INTO top_cats VALUES (25,'Freeware');
INSERT INTO top_cats VALUES (26,'Genealogy');
INSERT INTO top_cats VALUES (27,'Graphics');
INSERT INTO top_cats VALUES (28,'GSM');
INSERT INTO top_cats VALUES (29,'Greetingcards');
INSERT INTO top_cats VALUES (30,'Health');
INSERT INTO top_cats VALUES (31,'Hobbies');
INSERT INTO top_cats VALUES (32,'Horoscopes');
INSERT INTO top_cats VALUES (33,'Hotels');
INSERT INTO top_cats VALUES (34,'Internet');
INSERT INTO top_cats VALUES (35,'Jobs');
INSERT INTO top_cats VALUES (36,'Jokes');
INSERT INTO top_cats VALUES (37,'Lyrics');
INSERT INTO top_cats VALUES (38,'Magazines');
INSERT INTO top_cats VALUES (39,'Maps');
INSERT INTO top_cats VALUES (40,'Marketing');
INSERT INTO top_cats VALUES (41,'Midi');
INSERT INTO top_cats VALUES (42,'Movies');
INSERT INTO top_cats VALUES (43,'MP3');
INSERT INTO top_cats VALUES (44,'Music');
INSERT INTO top_cats VALUES (45,'News');
INSERT INTO top_cats VALUES (46,'Newsletters');
INSERT INTO top_cats VALUES (47,'Personal homepages');
INSERT INTO top_cats VALUES (48,'Pets');
INSERT INTO top_cats VALUES (49,'Pokemon');
INSERT INTO top_cats VALUES (50,'Portals');
INSERT INTO top_cats VALUES (51,'Radiostations');
INSERT INTO top_cats VALUES (52,'Real estate');
INSERT INTO top_cats VALUES (53,'Recipes');
INSERT INTO top_cats VALUES (54,'Reference');
INSERT INTO top_cats VALUES (55,'Religion');
INSERT INTO top_cats VALUES (56,'Romantic');
INSERT INTO top_cats VALUES (57,'Screensavers');
INSERT INTO top_cats VALUES (58,'Search engines');
INSERT INTO top_cats VALUES (59,'Shopping');
INSERT INTO top_cats VALUES (60,'Software');
INSERT INTO top_cats VALUES (61,'Sports');
INSERT INTO top_cats VALUES (62,'Star Trek');
INSERT INTO top_cats VALUES (63,'Star Wars');
INSERT INTO top_cats VALUES (64,'Sweepstakes');
INSERT INTO top_cats VALUES (65,'Telecom');
INSERT INTO top_cats VALUES (66,'Top Websites');
INSERT INTO top_cats VALUES (67,'Travel');
INSERT INTO top_cats VALUES (68,'Videogames');
INSERT INTO top_cats VALUES (69,'Wallpapers');
INSERT INTO top_cats VALUES (70,'Web Promotion');
INSERT INTO top_cats VALUES (71,'Webcams');
INSERT INTO top_cats VALUES (72,'Webdesign');
INSERT INTO top_cats VALUES (73,'Webdevelopment');
INSERT INTO top_cats VALUES (74,'Webhosting');
INSERT INTO top_cats VALUES (75,'Webmasters');
INSERT INTO top_cats VALUES (76,'Women');
#
# Table structure for table 'top_hits'
#
CREATE TABLE top_hits (
sid int(11),
ip varchar(20),
cdate timestamp(8)
);
#
# Dumping data for table 'top_hits'
#
#
# Table structure for table 'top_user'
#
CREATE TABLE top_user (
sid int(11) NOT NULL auto_increment,
banner varchar(255),
bannerw int(11),
bannerh int(11),
title varchar(255),
description varchar(255),
rank int(11) DEFAULT '0' NOT NULL,
votes int(11) DEFAULT '0' NOT NULL,
status enum('Y','N') DEFAULT 'N' NOT NULL,
name varchar(255),
email varchar(255),
password varchar(255),
url varchar(255),
hitin int(11) DEFAULT '0' NOT NULL,
hitout int(11) DEFAULT '0' NOT NULL,
category int(11),
stars enum('0','1','2','3','4','5') DEFAULT '0' NOT NULL,
PRIMARY KEY (sid)
);
#
# Dumping data for table 'top_user'
#
CREATE TABLE top_review (
rid int(11) NOT NULL auto_increment,
name varchar(20),
email varchar(40),
review text,
sid int DEFAULT 0 NOT NULL,
rating tinyint DEFAULT 0 NOT NULL,
PRIMARY KEY (rid)
);
ALTER TABLE top_review ADD COLUMN postdate timestamp(8);
Jag får felmeddelandet:
Error
SQL-query: och så kommer texten som är ovanför.
# MySQL dump 8.10
#
# Host: localhost Database: phptop
#--------------------------------------------------------
# Server version 3.23.25-beta-debug
#
# Table structure for table 'top_cats'
#
CREATE TABLE top_cats (
cid int(11) NOT NULL auto_increment,
catname varchar(255),
PRIMARY KEY (cid),
UNIQUE catname (catname)
);
#
# Dumping data for table 'top_cats'
#
INSERT INTO top_cats VALUES (1,'Animals');
INSERT INTO top_cats VALUES (2,'Arts');
INSERT INTO top_cats VALUES (3,'Books');
INSERT INTO top_cats VALUES (4,'Business');
INSERT INTO top_cats VALUES (5,'Cars');
INSERT INTO top_cats VALUES (6,'Celebrities');
INSERT INTO top_cats VALUES (7,'Chat');
INSERT INTO top_cats VALUES (8,'Clipart');
INSERT INTO top_cats VALUES (9,'Collectibles');
INSERT INTO top_cats VALUES (10,'Communities');
INSERT INTO top_cats VALUES (11,'Computers');
INSERT INTO top_cats VALUES (12,'Contests');
INSERT INTO top_cats VALUES (13,'Cool sites');
INSERT INTO top_cats VALUES (14,'Crafts');
INSERT INTO top_cats VALUES (15,'Desktop Themes');
INSERT INTO top_cats VALUES (16,'Dogs');
INSERT INTO top_cats VALUES (17,'Education');
INSERT INTO top_cats VALUES (18,'Entertainment');
INSERT INTO top_cats VALUES (19,'Essays');
INSERT INTO top_cats VALUES (20,'Finance');
INSERT INTO top_cats VALUES (21,'Fonts');
INSERT INTO top_cats VALUES (22,'Free Cash');
INSERT INTO top_cats VALUES (23,'Free Mail');
INSERT INTO top_cats VALUES (24,'Freestuff');
INSERT INTO top_cats VALUES (25,'Freeware');
INSERT INTO top_cats VALUES (26,'Genealogy');
INSERT INTO top_cats VALUES (27,'Graphics');
INSERT INTO top_cats VALUES (28,'GSM');
INSERT INTO top_cats VALUES (29,'Greetingcards');
INSERT INTO top_cats VALUES (30,'Health');
INSERT INTO top_cats VALUES (31,'Hobbies');
INSERT INTO top_cats VALUES (32,'Horoscopes');
INSERT INTO top_cats VALUES (33,'Hotels');
INSERT INTO top_cats VALUES (34,'Internet');
INSERT INTO top_cats VALUES (35,'Jobs');
INSERT INTO top_cats VALUES (36,'Jokes');
INSERT INTO top_cats VALUES (37,'Lyrics');
INSERT INTO top_cats VALUES (38,'Magazines');
INSERT INTO top_cats VALUES (39,'Maps');
INSERT INTO top_cats VALUES (40,'Marketing');
INSERT INTO top_cats VALUES (41,'Midi');
INSERT INTO top_cats VALUES (42,'Movies');
INSERT INTO top_cats VALUES (43,'MP3');
INSERT INTO top_cats VALUES (44,'Music');
INSERT INTO top_cats VALUES (45,'News');
INSERT INTO top_cats VALUES (46,'Newsletters');
INSERT INTO top_cats VALUES (47,'Personal homepages');
INSERT INTO top_cats VALUES (48,'Pets');
INSERT INTO top_cats VALUES (49,'Pokemon');
INSERT INTO top_cats VALUES (50,'Portals');
INSERT INTO top_cats VALUES (51,'Radiostations');
INSERT INTO top_cats VALUES (52,'Real estate');
INSERT INTO top_cats VALUES (53,'Recipes');
INSERT INTO top_cats VALUES (54,'Reference');
INSERT INTO top_cats VALUES (55,'Religion');
INSERT INTO top_cats VALUES (56,'Romantic');
INSERT INTO top_cats VALUES (57,'Screensavers');
INSERT INTO top_cats VALUES (58,'Search engines');
INSERT INTO top_cats VALUES (59,'Shopping');
INSERT INTO top_cats VALUES (60,'Software');
INSERT INTO top_cats VALUES (61,'Sports');
INSERT INTO top_cats VALUES (62,'Star Trek');
INSERT INTO top_cats VALUES (63,'Star Wars');
INSERT INTO top_cats VALUES (64,'Sweepstakes');
INSERT INTO top_cats VALUES (65,'Telecom');
INSERT INTO top_cats VALUES (66,'Top Websites');
INSERT INTO top_cats VALUES (67,'Travel');
INSERT INTO top_cats VALUES (68,'Videogames');
INSERT INTO top_cats VALUES (69,'Wallpapers');
INSERT INTO top_cats VALUES (70,'Web Promotion');
INSERT INTO top_cats VALUES (71,'Webcams');
INSERT INTO top_cats VALUES (72,'Webdesign');
INSERT INTO top_cats VALUES (73,'Webdevelopment');
INSERT INTO top_cats VALUES (74,'Webhosting');
INSERT INTO top_cats VALUES (75,'Webmasters');
INSERT INTO top_cats VALUES (76,'Women');
#
# Table structure for table 'top_hits'
#
CREATE TABLE top_hits (
sid int(11),
ip varchar(20),
cdate timestamp(8)
);
#
# Dumping data for table 'top_hits'
#
#
# Table structure for table 'top_user'
#
CREATE TABLE top_user (
sid int(11) NOT NULL auto_increment,
banner varchar(255),
bannerw int(11),
bannerh int(11),
title varchar(255),
description varchar(255),
rank int(11) DEFAULT '0' NOT NULL,
votes int(11) DEFAULT '0' NOT NULL,
status enum('Y','N') DEFAULT 'N' NOT NULL,
name varchar(255),
email varchar(255),
password varchar(255),
url varchar(255),
hitin int(11) DEFAULT '0' NOT NULL,
hitout int(11) DEFAULT '0' NOT NULL,
category int(11),
stars enum('0','1','2','3','4','5') DEFAULT '0' NOT NULL,
PRIMARY KEY (sid)
);
#
# Dumping data for table 'top_user'
#
CREATE TABLE top_review (
rid int(11) NOT NULL auto_increment,
name varchar(20),
email varchar(40),
review text,
sid int DEFAULT 0 NOT NULL,
rating tinyint DEFAULT 0 NOT NULL,
PRIMARY KEY (rid)
);
ALTER TABLE top_review ADD COLUMN postdate timestamp(8);
Jag får felmeddelandet:
Error
SQL-query: och så kommer texten som är ovanför.