MD9LHtLL

1importing mysql workbench 'create tables' to phpmyadmin
2SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
3SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
4SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
5
6CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;
7
8USE `mydb` ;
9
10-- -----------------------------------------------------
11-- Table `mydb`.`User`
12-- -----------------------------------------------------
13
14DROP TABLE IF EXISTS `mydb`.`User` ;
15
16CREATE  TABLE IF NOT EXISTS `mydb`.`User` (
17  `idUser` INT NOT NULL AUTO_INCREMENT ,
18  `Username` VARCHAR(25) NOT NULL ,
19  `Password` VARCHAR(25) NOT NULL ,
20  `Email` VARCHAR(45) NOT NULL ,
21  `DateJoined` DATETIME NOT NULL ,
22  PRIMARY KEY (`idUser`) )
23ENGINE = InnoDB;
24
25
26SET SQL_MODE=@OLD_SQL_MODE;
27SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
28SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
29	
30#1044 - Access denied for user 'myusername'@'localhost' to database 'mydb'
31	
32CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;**