Advertisement
Guest User

Foreign key constraint is incorrectly formed.

a guest
May 14th, 2017
236
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.35 KB | None | 0 0
  1. <?php
  2. $server = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $database = "cmsteste";
  6.  
  7. try{
  8. $conn = new PDO("mysql:host=$server", $username, $password);
  9. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  10. $sql = "CREATE DATABASE $database";
  11. $conn->exec($sql);
  12. try{
  13. $conn = new PDO("mysql:host=$server;dbname=$database", $username, $password);
  14. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15. $sql = "CREATE TABLE user(
  16. ID_User INT( 11 ) AUTO_INCREMENT PRIMARY KEY,
  17. Nome VARCHAR( 100 ) NOT NULL,
  18. Email VARCHAR( 250 ) NOT NULL,
  19. Senha VARCHAR( 150 ) NOT NULL);";
  20. $conn->exec($sql);
  21. echo "Table user created successfully";
  22. $sql = "CREATE TABLE header(
  23. ID_Header INT( 11 ) PRIMARY KEY,
  24. Cor_Background VARCHAR( 100 ) NOT NULL,
  25. Cor_Letra VARCHAR( 100 ) NOT NULL,
  26. Logo_Path VARCHAR( 255 ) NOT NULL,
  27. ID_User INT( 11 ),
  28. FOREIGN KEY (ID_User) REFERENCES user);";
  29. $conn->exec($sql);
  30. echo "Table header created successfully";
  31. $sql = "CREATE TABLE content(
  32. ID_Content INT( 11 ) PRIMARY KEY,
  33. Cor_Background VARCHAR( 100 ) NOT NULL,
  34. Cor_Letra VARCHAR( 100 ) NOT NULL,
  35. ID_User INT( 11 ),
  36. FOREIGN KEY (ID_User) REFERENCES user);";
  37. $conn->exec($sql);
  38. echo "Table content created successfully";
  39. $sql = "CREATE TABLE footer(
  40. ID_Footer INT( 11 ) PRIMARY KEY,
  41. Cor_Background VARCHAR( 100 ) NOT NULL,
  42. Cor_Letra VARCHAR( 100 ) NOT NULL,
  43. Copyright VARCHAR( 255 ) NOT NULL,
  44. ID_User INT( 11 ),
  45. FOREIGN KEY (ID_User) REFERENCES user);";
  46. $conn->exec($sql);
  47. echo "Table footer created successfully";
  48. }catch(PDOException $e){
  49. echo $sql . "<br>" . $e->getMessage();
  50. }
  51.  
  52. }catch(PDOException $e){
  53. echo $sql . "<br>" . $e->getMessage();
  54. }
  55.  
  56. $conn = null;
  57. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement