DROP TABLE IF EXISTS `cad_materia`;
CREATE TABLE IF NOT EXISTS `cad_materia` (
  `php_id` int(11) NOT NULL AUTO_INCREMENT,
  `php_titulo` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `php_thumb` text CHARACTER SET latin1 NOT NULL,
  `php_texto` longtext NOT NULL,
  `php_categoria` text CHARACTER SET latin1 NOT NULL,
  `php_autor` text CHARACTER SET latin1 NOT NULL,
  `php_data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `php_chave` text CHARACTER SET latin1 NOT NULL,
  `url` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `cod_user` char(255) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`php_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;