Avatar billede nickyc Nybegynder
01. september 2005 - 11:11 Der er 13 kommentarer

Fejl i denne SQL?

Hey alle...
Kan ikke få lov til at importere dette ind?


CREATE DATABASE `meetme`

CREATE TABLE `tblusers` (
`UserID` int(10) unsigned NOT NULL auto_increment,
`UserEMail` varchar(45) NOT NULL default '',
`UserNickName` varchar(45) NOT NULL default '',
`UserName` varchar(45) NOT NULL default '',
`UserArticleID` int(10) unsigned NOT NULL default '0',
`UserTypeID` int(10) unsigned NOT NULL default '0',
`UserStatusID` int(10) unsigned NOT NULL default '0',
PRIMARY KEY  (`UserID`),
UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`)

CREATE TABLE `tbluserstatus` (
`StatusID` int(10) unsigned NOT NULL default '0',
`StatusName` varchar(45) NOT NULL default '',
PRIMARY KEY  (`StatusID`)

CREATE TABLE `tblusertypes` (
`UserTypeID` int(10) unsigned NOT NULL default '0',
`UserTypeName` varchar(45) NOT NULL default '',
PRIMARY KEY  (`UserTypeID`)

CREATE TABLE `tblmailbox` (
`MailID` int(10) unsigned NOT NULL auto_increment,
`MailToUserID` int(10) unsigned NOT NULL default '0',
`MailFromUserID` int(10) unsigned NOT NULL default '0',
`MailSentTime` datetime NOT NULL default '0000-00-00 00:00:00',
`MailReadTime` datetime default NULL,
`MailTitle` varchar(100) default NULL,
`MailBody` text,
PRIMARY KEY  (`MailID`)

CREATE TABLE `tblforums` (
`ForumID` int(10) unsigned NOT NULL auto_increment,
`ForumName` varchar(45) NOT NULL default '',
`ForumSortIndex` int(10) unsigned NOT NULL default '0',
`ForumVisibility` int(10) unsigned NOT NULL default '0',
PRIMARY KEY  (`ForumID`),
UNIQUE KEY `idxForumName` (`ForumName`)

CREATE TABLE `tblforumthreads` (
`ThreadID` int(10) unsigned NOT NULL auto_increment,
`ForumID` int(10) unsigned NOT NULL default '0',
`ThreadParentID` int(10) unsigned default '0',
`ThreadAuthorID` int(10) unsigned default '0',
`ThreadTime` datetime default NULL,
`ThreadTitle` varchar(100) default NULL,
`ThreadBody` text,
PRIMARY KEY  (`ThreadID`),
KEY `idxForumID` (`ForumID`),
KEY `idxThreadParent` (`ThreadParentID`)

CREATE TABLE `tblarticles` (
`ArticleID` int(10) unsigned NOT NULL auto_increment,
`AuthorID` int(10) unsigned NOT NULL default '0',
`ArticleStatusID` int(10) unsigned zerofill NOT NULL default '0000000001',
`ArticleModificationTime` datetime default '0000-00-00 00:00:00',
`ArticleActivationTime` datetime default '0000-00-00 00:00:00',
`ArticleExpirationTime` datetime default '0000-00-00 00:00:00',
`ArticleTemplateID` int(10) unsigned default '0',
PRIMARY KEY  (`ArticleID`)

CREATE TABLE `tblarticleparts` (
`ArticleID` int(10) unsigned NOT NULL default '0',
`PartID` varchar(45) NOT NULL default '',
`PartContent` text,
PRIMARY KEY  (`ArticleID`,`PartID`)

CREATE TABLE `tblarticlestatus` (
`StatusID` int(10) unsigned NOT NULL auto_increment,
`StatusName` varchar(45) NOT NULL default '',
PRIMARY KEY  (`StatusID`)


DATA

mysql> select * from tbluserstatus;
+----------+------------+
| StatusID | StatusName |
+----------+------------+
|        0 | Aktiv      |
|        1 | Inaktiv    |
+----------+------------+

mysql> select * from tblusers;
+--------+----------------------+--------------+-------------------+---------------+------------+--------------+
| UserID | UserEMail            | UserNickName | UserName          | UserArticleID | UserTypeID | UserStatusID |
+--------+----------------------+--------------+-------------------+---------------+------------+--------------+
|      1 | nicky@framemakers.dk | Admin        | Nicky Christensen |            0 |          2 |            0 |
+--------+----------------------+--------------+-------------------+---------------+------------+--------------+

mysql> select * from tblusertypes;
+------------+---------------+
| UserTypeID | UserTypeName  |
+------------+---------------+
|          0 | Bruger        |
|          1 | Moderator    |
|          2 | Administrator |
+------------+---------------+

mysql> select * from tblarticlestatus;
+----------+-----------------+
| StatusID | StatusName      |
+----------+-----------------+
|        1 | Ikke publiceret |
|        2 | Publiceret      |
+----------+-----------------+
Avatar billede donslund Nybegynder
01. september 2005 - 11:17 #1
Og det er ikke fordi din database allerede er oprettet? Så skal du slette øverste linie.
Avatar billede nickyc Nybegynder
01. september 2005 - 11:21 #2
Nej, databasen er nemlig ikke oprettet :(
Avatar billede nickyc Nybegynder
01. september 2005 - 11:22 #3
Jeg får denne fejl:
MySQL returnerede: 
#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 'CREATE TABLE `tblusers` (
`UserID` int(10) unsigned NOT NULL auto_increment,
`' at line 3
Avatar billede arne_v Ekspert
01. september 2005 - 11:52 #4
msngler der ikke ; efter sætningerne ?
Avatar billede arne_v Ekspert
01. september 2005 - 11:52 #5
mangler
Avatar billede nickyc Nybegynder
01. september 2005 - 11:57 #6
Jo, gør der nu, har nu sat dem på, men virker stadig ikke
Nu ser koden sådanne ud:

CREATE DATABASE `meetme`

CREATE TABLE `tblusers` (
`UserID` int(10) unsigned NOT NULL auto_increment,
`UserEMail` varchar(45) NOT NULL default '',
`UserNickName` varchar(45) NOT NULL default '',
`UserName` varchar(45) NOT NULL default '',
`UserArticleID` int(10) unsigned NOT NULL default '0',
`UserTypeID` int(10) unsigned NOT NULL default '0',
`UserStatusID` int(10) unsigned NOT NULL default '0',
PRIMARY KEY  (`UserID`),
UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`);

CREATE TABLE `tbluserstatus` (
`StatusID` int(10) unsigned NOT NULL default '0',
`StatusName` varchar(45) NOT NULL default '',
PRIMARY KEY  (`StatusID`);

CREATE TABLE `tblusertypes` (
`UserTypeID` int(10) unsigned NOT NULL default '0',
`UserTypeName` varchar(45) NOT NULL default '',
PRIMARY KEY  (`UserTypeID`);

CREATE TABLE `tblmailbox` (
`MailID` int(10) unsigned NOT NULL auto_increment,
`MailToUserID` int(10) unsigned NOT NULL default '0',
`MailFromUserID` int(10) unsigned NOT NULL default '0',
`MailSentTime` datetime NOT NULL default '0000-00-00 00:00:00',
`MailReadTime` datetime default NULL,
`MailTitle` varchar(100) default NULL,
`MailBody` text,
PRIMARY KEY  (`MailID`);

CREATE TABLE `tblforums` (
`ForumID` int(10) unsigned NOT NULL auto_increment,
`ForumName` varchar(45) NOT NULL default '',
`ForumSortIndex` int(10) unsigned NOT NULL default '0',
`ForumVisibility` int(10) unsigned NOT NULL default '0',
PRIMARY KEY  (`ForumID`),
UNIQUE KEY `idxForumName` (`ForumName`);

CREATE TABLE `tblforumthreads` (
`ThreadID` int(10) unsigned NOT NULL auto_increment,
`ForumID` int(10) unsigned NOT NULL default '0',
`ThreadParentID` int(10) unsigned default '0',
`ThreadAuthorID` int(10) unsigned default '0',
`ThreadTime` datetime default NULL,
`ThreadTitle` varchar(100) default NULL,
`ThreadBody` text,
PRIMARY KEY  (`ThreadID`),
KEY `idxForumID` (`ForumID`),
KEY `idxThreadParent` (`ThreadParentID`);

CREATE TABLE `tblarticles` (
`ArticleID` int(10) unsigned NOT NULL auto_increment,
`AuthorID` int(10) unsigned NOT NULL default '0',
`ArticleStatusID` int(10) unsigned zerofill NOT NULL default '0000000001',
`ArticleModificationTime` datetime default '0000-00-00 00:00:00',
`ArticleActivationTime` datetime default '0000-00-00 00:00:00',
`ArticleExpirationTime` datetime default '0000-00-00 00:00:00',
`ArticleTemplateID` int(10) unsigned default '0',
PRIMARY KEY  (`ArticleID`);

CREATE TABLE `tblarticleparts` (
`ArticleID` int(10) unsigned NOT NULL default '0',
`PartID` varchar(45) NOT NULL default '',
`PartContent` text,
PRIMARY KEY  (`ArticleID`,`PartID`);

CREATE TABLE `tblarticlestatus` (
`StatusID` int(10) unsigned NOT NULL auto_increment,
`StatusName` varchar(45) NOT NULL default '',
PRIMARY KEY  (`StatusID`);
Avatar billede arne_v Ekspert
01. september 2005 - 12:02 #7
der mangler stadig ; efter

CREATE DATABASE `meetme`
Avatar billede nickyc Nybegynder
01. september 2005 - 12:07 #8
Så opretter den databasen, men ingen tabeller, får så denne fejl når jeg prøver at oprette tabellerne :

MySQL returnerede: 

#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 10
Avatar billede inglenook Praktikant
01. september 2005 - 12:15 #9
du lukker ikke dine paranteser.....
UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`);

skal vaere:

UNIQUE KEY `idxUserNickName` USING HASH (`UserNickName`));

tror det skal aendres for alle tabeller.
Avatar billede nickyc Nybegynder
01. september 2005 - 12:26 #10
Det havde du sq ret i :) - kanon... ligger du et svar ? :)
Avatar billede inglenook Praktikant
01. september 2005 - 12:32 #11
Tror jeg skal dele med arne_v  ;-)
Avatar billede arne_v Ekspert
02. september 2005 - 21:05 #12
if so
Avatar billede inglenook Praktikant
09. marts 2008 - 10:08 #13
lukketid ... ?
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester