Sie sind nicht angemeldet.
11.04.2009, 23:03
|
Quellcode |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
CREATE TABLE 'mailusers' ( 'id' INT( 11 ) NOT NULL AUTO_INCREMENT , 'account' VARCHAR( 240 ) NOT NULL , 'uid' VARCHAR( 6 ) DEFAULT '5001' NOT NULL , 'gid' VARCHAR( 6 ) DEFAULT '5001' NOT NULL , 'maildir' VARCHAR( 100 ) DEFAULT '/var/spool/maildirs' NOT NULL , 'home' VARCHAR( 100 ) NOT NULL , 'password' VARCHAR( 255 ) NOT NULL , 'angelegt_von' VARCHAR( 60 ) NOT NULL , 'angelegt_am' DATE NOT NULL , 'memo_txt' VARCHAR( 255 ) NOT NULL , 'memo_vorname' VARCHAR( 60 ) NOT NULL , 'memo_nachname' VARCHAR( 60 ) NOT NULL , PRIMARY KEY ( 'id' ) , UNIQUE ( 'account' ) ) TYPE = MYISAM ; |
|
|
Quellcode |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
mysql> CREATE TABLE 'mailusers' (
-> 'id' INT( 11 ) NOT NULL AUTO_INCREMENT ,
-> 'account' VARCHAR( 240 ) NOT NULL ,
-> 'uid' VARCHAR( 6 ) DEFAULT '5001' NOT NULL ,
-> 'gid' VARCHAR( 6 ) DEFAULT '5001' NOT NULL ,
-> 'maildir' VARCHAR( 100 ) DEFAULT '/var/spool/maildirs' NOT NULL ,
-> 'home' VARCHAR( 100 ) NOT NULL ,
-> 'password' VARCHAR( 255 ) NOT NULL ,
-> 'angelegt_von' VARCHAR( 60 ) NOT NULL ,
-> 'angelegt_am' DATE NOT NULL ,
-> 'memo_txt' VARCHAR( 255 ) NOT NULL ,
-> 'memo_vorname' VARCHAR( 60 ) NOT NULL ,
-> 'memo_nachname' VARCHAR( 60 ) NOT NULL ,
-> PRIMARY KEY ( 'id' ) ,
-> UNIQUE ( 'account' )
-> ) TYPE = MYISAM ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds toyour MySQL server version for the right syntax to use near ''mailusers' (
'id' INT( 11 ) NOT NULL AUTO_INCREMENT ,
'account' VARCHAR( 240 ) ' at line 1
|
|
|
Quellcode |
1 |
CREATE TABLE 'mailusers' ( 'id' INT( 11 ) NOT NULL AUTO_INCREMENT ); |
Dieser Beitrag wurde bereits 1 mal editiert, zuletzt von »tuner« (12.04.2009, 07:54)
12.04.2009, 07:53
|
|
Quellcode |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
CREATE TABLE mailusers( id INT(11) NOT NULL AUTO_INCREMENT, account VARCHAR(240) NOT NULL, uid VARCHAR(6) DEFAULT '5001' NOT NULL, gid VARCHAR(6) DEFAULT '5001' NOT NULL, maildir VARCHAR(100) DEFAULT '/var/spool/maildirs' NOT NULL, home VARCHAR(100) NOT NULL, password VARCHAR(255) NOT NULL, angelegt_von VARCHAR(60) NOT NULL, angelegt_am DATE NOT NULL, memo_txt VARCHAR(255) NOT NULL, memo_vorname VARCHAR(60) NOT NULL, memo_nachname VARCHAR(60) NOT NULL, PRIMARY KEY (id), UNIQUE (account) ) TYPE = MYISAM ; |
