Advertisement
Guest User

Untitled

a guest
May 23rd, 2016
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. I made database pug
  2.  
  3. Then i tried to import sql files
  4. Error:
  5. [code]
  6.  
  7. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DELIMITER' at line 1
  8. [/code]
  9. Error 2:
  10. [code]
  11. SQL query:
  12.  
  13. CREATE TABLE IF NOT EXISTS pug_match
  14. (
  15. id INT NOT NULL AUTO_INCREMENT,
  16. server VARCHAR(32) NOT NULL DEFAULT '',
  17. ip VARCHAR(32) NOT NULL DEFAULT '',
  18. map VARCHAR(32) NOT NULL DEFAULT '',
  19. score1 SMALLINT NOT NULL DEFAULT 0,
  20. score2 SMALLINT NOT NULL DEFAULT 0,
  21. rounds SMALLINT NOT NULL DEFAULT 0,
  22. date DATETIME NOT NULL DEFAULT NOW(),
  23. seconds FLOAT NOT NULL DEFAULT 0.0,
  24. duration VARCHAR(32) NOT NULL DEFAULT '',
  25. PRIMARY KEY (id)
  26. );
  27.  
  28. MySQL said: Documentation
  29. #1067 - Invalid default value for 'date'
  30. [/code]
  31.  
  32. Smiley, can you help?
  33.  
  34. p.s. sql files are original. i didn't change anything.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement