Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `applications` (
- `appID` int(11) NOT NULL AUTO_INCREMENT,
- `appName` varchar(10000) NOT NULL,
- `appDB` varchar(10000) NOT NULL,
- `appPrefix` varchar(10000) NOT NULL,
- PRIMARY KEY (`appID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
- CREATE TABLE `login` (
- `userID` int(11) NOT NULL AUTO_INCREMENT,
- `username` varchar(1000) NOT NULL,
- `emailAddress` varchar(1000) NOT NULL,
- `password` varchar(10000) NOT NULL,
- `hash` varchar(10000) NOT NULL,
- `verified` tinyint(1) NOT NULL,
- PRIMARY KEY (`userID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
- CREATE TABLE `saltTable` (
- `userID` int(11) NOT NULL AUTO_INCREMENT,
- `salt` varchar(10000) NOT NULL,
- PRIMARY KEY (`userID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1
- function createInitialTables(){
- $serverURL = $_SESSION['server'];
- $username = $_SESSION['username'];
- $password = $_SESSION['password'];
- $database = $_SESSION['database'];
- $con = mysqli_connect($serverURL, $username, $password, $database);
- $sql = 'CREATE TABLE `applications` (
- `appID` int(11) NOT NULL AUTO_INCREMENT,
- `appName` varchar(10000) NOT NULL,
- `appDB` varchar(10000) NOT NULL,
- `appPrefix` varchar(10000) NOT NULL,
- PRIMARY KEY (`appID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
- CREATE TABLE `login` (
- `userID` int(11) NOT NULL AUTO_INCREMENT,
- `username` varchar(1000) NOT NULL,
- `emailAddress` varchar(1000) NOT NULL,
- `password` varchar(10000) NOT NULL,
- `hash` varchar(10000) NOT NULL,
- `verified` tinyint(1) NOT NULL,
- PRIMARY KEY (`userID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
- CREATE TABLE `saltTable` (
- `userID` int(11) NOT NULL AUTO_INCREMENT,
- `salt` varchar(10000) NOT NULL,
- PRIMARY KEY (`userID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
- ';
- $result = mysqli_query($con, $sql);
- $error = mysqli_error($con);
- print($error);
- }
- 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` (
- `userID` int(11) NOT NULL AUTO_INCREMENT,
- `username` ' at line 9CREATE TABLE `applications` (
- `appID` int(11) NOT NULL AUTO_INCREMENT,
- `appName` varchar(10000) NOT NULL,
- `appDB` varchar(10000) NOT NULL,
- `appPrefix` varchar(10000) NOT NULL,
- PRIMARY KEY (`appID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement