## criar tabelas no bd de várias formas

## direto no mysql 1

CREATE TABLE `forastey_downloads`.`files` (`file_id` INT NOT NULL AUTO_INCREMENT ,
`user_id` INT(255) NULL ,
`filename` VARCHAR(255) NULL ,
`filepath` VARCHAR(255) NULL ,
PRIMARY KEY (`file_id`)) ENGINE = InnoDB;


CREATE TABLE `forastey_downloads`.`group_memberships` (`group_id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR(255) NULL ,
`group_key` VARCHAR(255) NULL ,
PRIMARY KEY (`group_id`)) ENGINE = InnoDB;



CREATE TABLE `forastey_downloads`.`users` (`user_id` INT NOT NULL ,
`user_type` TEXT(255) NOT NULL ,
`username` VARCHAR(255) NULL ,
`email` VARCHAR(255) NULL ,
`password` VARCHAR(255) NULL ,
`group_id` INT NOT NULL ,
`creator` TEXT(255) NOT NULL ,
PRIMARY KEY (`user_id`)) ENGINE = InnoDB;



CREATE TABLE `forastey_downloads`.`file_share_recipients` (`share_id` INT NULL , `recipient_id` INT NULL ) ENGINE = InnoDB;






## direto no mysql  2

CREATE TABLE supernews(
                   ID int(5) unsigned NOT NULL AUTO_INCREMENT,
                   diretorio TEXT,
                   largura TEXT,
                   altura TEXT,
                   titulo TEXT NOT NULL,
                   conteudo TEXT NOT NULL,
                   data DATETIME NOT NULL,
                   PRIMARY KEY (ID)
                   );
                   
                   
                  
## via página php

$sql2 = mysqli_query($conexaot, "CREATE TABLE {$usuario_id}cb (
id INT(5) UNSIGNED AUTO_INCREMENT PRIMARY KEY, data VARCHAR(100) NULL, ip VARCHAR(200) NULL, geral VARCHAR(200) NULL
)");