--
-- Host: localhost    Database: amanriam_site
-- ------------------------------------------------------


--
-- Table structure for table `noticias`
--

CREATE TABLE `noticias` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `criador` varchar(500) NOT NULL,
  `titulo` varchar(500) NOT NULL,
  `categoria` varchar(500) NOT NULL,
  `data` varchar(20) NOT NULL DEFAULT 'Publicado',
  `estado` varchar(500) NOT NULL,
  `conteudo` varchar(9999) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `noticias`
--

INSERT INTO `noticias` VALUES (1,'luciana','teste testando','categoria teste','01/11/2016','n','<p>teste de noticias SELECT * FROM noticias com nosqlinjection</p>');

--
-- Table structure for table `projetos`
--

CREATE TABLE `projetos` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `titulo` varchar(500) NOT NULL,
  `criador` varchar(500) NOT NULL,
  `estado` varchar(50) NOT NULL,
  `local` varchar(200) NOT NULL,
  `data` varchar(250) NOT NULL,
  `conteudo` varchar(9999) NOT NULL,
  `keywords` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `projetos`
--


--
-- Table structure for table `projetos_imagens`
--

CREATE TABLE `projetos_imagens` (
  `id_imagem` int(255) NOT NULL AUTO_INCREMENT,
  `id_projeto` int(255) NOT NULL,
  `link` varchar(500) NOT NULL,
  `nome` varchar(500) NOT NULL,
  `extensao` varchar(500) NOT NULL,
  `tamanho` varchar(200) NOT NULL,
  PRIMARY KEY (`id_imagem`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `projetos_imagens`
--


--
-- Table structure for table `temp`
--

CREATE TABLE `temp` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `link` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `temp`
--



