Advertisement
Guest User

Untitled

a guest
Dec 23rd, 2016
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.39 KB | None | 0 0
  1. CREATE TABLE `applications` (
  2. `appID` int(11) NOT NULL AUTO_INCREMENT,
  3. `appName` varchar(10000) NOT NULL,
  4. `appDB` varchar(10000) NOT NULL,
  5. `appPrefix` varchar(10000) NOT NULL,
  6. PRIMARY KEY (`appID`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  8.  
  9. CREATE TABLE `login` (
  10. `userID` int(11) NOT NULL AUTO_INCREMENT,
  11. `username` varchar(1000) NOT NULL,
  12. `emailAddress` varchar(1000) NOT NULL,
  13. `password` varchar(10000) NOT NULL,
  14. `hash` varchar(10000) NOT NULL,
  15. `verified` tinyint(1) NOT NULL,
  16. PRIMARY KEY (`userID`)
  17. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  18.  
  19. CREATE TABLE `saltTable` (
  20. `userID` int(11) NOT NULL AUTO_INCREMENT,
  21. `salt` varchar(10000) NOT NULL,
  22. PRIMARY KEY (`userID`)
  23. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
  24.  
  25. function createInitialTables(){
  26.  
  27. $serverURL = $_SESSION['server'];
  28. $username = $_SESSION['username'];
  29. $password = $_SESSION['password'];
  30. $database = $_SESSION['database'];
  31.  
  32. $con = mysqli_connect($serverURL, $username, $password, $database);
  33.  
  34. $sql = 'CREATE TABLE `applications` (
  35. `appID` int(11) NOT NULL AUTO_INCREMENT,
  36. `appName` varchar(10000) NOT NULL,
  37. `appDB` varchar(10000) NOT NULL,
  38. `appPrefix` varchar(10000) NOT NULL,
  39. PRIMARY KEY (`appID`)
  40. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  41.  
  42. CREATE TABLE `login` (
  43. `userID` int(11) NOT NULL AUTO_INCREMENT,
  44. `username` varchar(1000) NOT NULL,
  45. `emailAddress` varchar(1000) NOT NULL,
  46. `password` varchar(10000) NOT NULL,
  47. `hash` varchar(10000) NOT NULL,
  48. `verified` tinyint(1) NOT NULL,
  49. PRIMARY KEY (`userID`)
  50. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  51.  
  52. CREATE TABLE `saltTable` (
  53. `userID` int(11) NOT NULL AUTO_INCREMENT,
  54. `salt` varchar(10000) NOT NULL,
  55. PRIMARY KEY (`userID`)
  56. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
  57. ';
  58.  
  59. $result = mysqli_query($con, $sql);
  60. $error = mysqli_error($con);
  61.  
  62. print($error);
  63.  
  64. }
  65.  
  66. 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 `login` (
  67. `userID` int(11) NOT NULL AUTO_INCREMENT,
  68. `username` ' at line 9CREATE TABLE `applications` (
  69. `appID` int(11) NOT NULL AUTO_INCREMENT,
  70. `appName` varchar(10000) NOT NULL,
  71. `appDB` varchar(10000) NOT NULL,
  72. `appPrefix` varchar(10000) NOT NULL,
  73. PRIMARY KEY (`appID`)
  74. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement