-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: 06/07/2012 às 01h58min
-- Versão do Servidor: 5.5.16
-- Versão do PHP: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Banco de Dados: `app_guiacariri`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `artigos`
--

CREATE TABLE IF NOT EXISTS `artigos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fonte` varchar(255) NOT NULL,
  `linkfonte` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `data` varchar(50) NOT NULL,
  `linksite` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `registro` datetime NOT NULL,
  `validar` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Extraindo dados da tabela `artigos`
--

INSERT INTO `artigos` (`id`, `fonte`, `linkfonte`, `title`, `data`, `linksite`, `description`, `registro`, `validar`) VALUES
(1, 'crato - Google Not', 'http://news.google.com.br/news?pz=1&ned=pt-BR_br&hl=pt-BR&q=crato', 'Crato-CE: Nova sinaliza', '03/07/2012 11:39:04', 'http://news.google.com/news/url?sa=t&fd=R&usg=AFQjCNGWuoIc_N1VuNmapxtQgv4vv1dmRg&url=http://www.caririnoticia.com.br/2012/07/crato-ce-nova-sinalizacao-sera-implantada-ate-a-expocrato.html', '<table border="0" cellpadding="2" cellspacing="7" style="vertical-align:top;"><tr><td width="80" align="center" valign="top"><font style="font-size:85%;font-family:arial,sans-serif"><a href="http://news.google.com/news/url?sa=t&amp;fd=R&amp;usg=AFQjCNGWuo', '2012-07-04 21:50:07', '14fd041e06cfa97d4731fe2581b51e13'),
(2, 'Juazeiro do Norte - Google Not', 'http://news.google.com.br/news?pz=1&ned=pt-BR_br&hl=pt-BR&q=Juazeiro+do+Norte', 'Justi', '04/07/2012 20:59:51', 'http://news.google.com/news/url?sa=t&fd=R&usg=AFQjCNGzApNqc-dw1iL1hVc06r87wCoGaw&url=http://ne10.uol.com.br/canal/cotidiano/nordeste/noticia/2012/07/04/justica-suspende-divulgacao-de-resultado-de-vestibular-do-interior-no-ceara-352616.php', '<table border="0" cellpadding="2" cellspacing="7" style="vertical-align:top;"><tr><td width="80" align="center" valign="top"><font style="font-size:85%;font-family:arial,sans-serif"></font></td><td valign="top" class="j"><font style="font-size:85%;font-fa', '2012-07-04 21:50:07', 'bb392398a840d470604fcb60e732445b'),
(3, 'Barbalha - Google Not', 'http://news.google.com.br/news?pz=1&ned=pt-BR_br&hl=pt-BR&q=Barbalha', 'Barbalha-CE: Grande p', '03/07/2012 12:09:46', 'http://news.google.com/news/url?sa=t&fd=R&usg=AFQjCNHJfgYlCKSMgP6uf4gpRcWtAeAAUA&url=http://www.caririnoticia.com.br/2012/07/barbalha-ce-grande-publico-do-cariri-prestigia-lancamento-de-cordeis.html', '<table border="0" cellpadding="2" cellspacing="7" style="vertical-align:top;"><tr><td width="80" align="center" valign="top"><font style="font-size:85%;font-family:arial,sans-serif"><a href="http://news.google.com/news/url?sa=t&amp;fd=R&amp;usg=AFQjCNHJfg', '2012-07-04 21:50:07', '1f83f2125e36a758dfef0814aad4c203'),
(4, 'Cariri Not', 'http://www.caririnoticia.com.br', 'Designers criam despertador de borracha que pode ser ?espancado? pela manh', '03/07/2012 20:36:44', 'http://www.caririnoticia.com.br/2012/07/designers-criam-despertador-de-borracha-que-pode-ser-%e2%80%98espancado%e2%80%99-pela-manha.html', 'Bons tempos aqueles que existiam despertadores de ferro, super robustos, que podiam ser arremessados e espancados pela manh', '2012-07-04 21:50:07', 'b02b243858ee915538093a1173000b1c'),
(5, 'cariri - Google Not', 'http://news.google.com.br/news?pz=1&ned=pt-BR_br&hl=pt-BR&q=cariri', 'Cariri-CE: Confec', '03/07/2012 11:45:18', 'http://news.google.com/news/url?sa=t&fd=R&usg=AFQjCNFS9ZRnSdKCB8Q8gP0Mj4DcU_7a2A&url=http://www.caririnoticia.com.br/2012/07/cariri-ce-confeccoes-tem-opcoes-variadas.html', '<table border="0" cellpadding="2" cellspacing="7" style="vertical-align:top;"><tr><td width="80" align="center" valign="top"><font style="font-size:85%;font-family:arial,sans-serif"><a href="http://news.google.com/news/url?sa=t&amp;fd=R&amp;usg=AFQjCNFS9Z', '2012-07-04 21:50:07', 'c5e18be5530e6a021447b811af26fef3'),
(6, 'Veja Juazeiro - Veja Juazeiro - O Seu Portal de Not', 'http://www.vejajuazeiro.com.br', 'Alcymar Monteiro desiste da disputa pela prefeitura de Juazeiro do Norte', '04/07/2012 21:31:10', 'http://www.vejajuazeiro.com.br/v2/index.php/component/k2/item/3251-alcymar-monteiro-desiste-da-disputa-pela-prefeitura-de-juazeiro-do-norte.html', '<div class="K2FeedImage"><img src="http://www.vejajuazeiro.com.br/v2//media/k2/items/cache/f6eb4e07ae4e91398796ac5a7ad27b55_S.jpg" alt="Alcymar Monteiro desiste da disputa pela prefeitura de Juazeiro do Norte" /></div><div class="K2FeedIntroText"><div sty', '2012-07-04 21:50:07', 'f110bc63a82d83c371e0e3178130ce37'),
(7, 'ceara - Google Not', 'http://news.google.com.br/news?pz=1&ned=pt-BR_br&hl=pt-BR&q=ceara', 'Refor', '04/07/2012 19:46:27', 'http://news.google.com/news/url?sa=t&fd=R&usg=AFQjCNEjMjS39IGDxVxafpNa_YEsh0FmFA&url=http://esportes.terra.com.br/cruzeiro/noticias/0,,OI5876585-EI19374,00-Reforco%2Bdo%2BCruzeiro%2Blateral%2BCeara%2Bchega%2Ba%2BBelo%2BHorizonte.html', '<table border="0" cellpadding="2" cellspacing="7" style="vertical-align:top;"><tr><td width="80" align="center" valign="top"><font style="font-size:85%;font-family:arial,sans-serif"><a href="http://news.google.com/news/url?sa=t&amp;fd=R&amp;usg=AFQjCNEjMj', '2012-07-04 21:50:07', 'd529dc2fde4df052e952f30246e9ee3f');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;