Advertisement
Guest User

Untitled

a guest
May 5th, 2015
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. CREATE TABLE edgemap (
  2. senderid int(10) unsigned default NULL,
  3. recipientid int(10) unsigned default NULL,
  4. messageid int(10) unsigned default NULL,
  5. messagedt timestamp(14) NOT NULL,
  6. reciptype enum('bcc','cc','to') default NULL,
  7. subject varchar(255) default NULL,
  8. KEY senderid (senderid,recipientid),
  9. KEY messageid (messageid),
  10. KEY messagedt (messagedt),
  11. KEY senderid_2 (senderid),
  12. KEY recipientid (recipientid)
  13. ) ENGINE=MyISAM;
  14.  
  15. ERROR 1064 (42000) at line 255752: 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 '(14) NOT NULL,
  16. reciptype enum('bcc','cc','to') default NULL,
  17. subject varchar' at line 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement