


CREATE TABLE `afr_profils` (
  `id` int(11) NOT NULL,
  `users_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `country_id` int(11) DEFAULT NULL,
  `activate_date` timestamp NULL DEFAULT NULL,
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
ALTER TABLE `afr_profils` ADD PRIMARY KEY (`id`);

ALTER TABLE `afr_profils` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;


TABLES BLOG ___________________________________
CREATE TABLE `ben4_blogs` (
  `id` int(11) NOT NULL,
  `title` varchar(75) DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `city_id` int(11) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `content` longtext,
  `slug` varchar(255) DEFAULT NULL,
  `state` int(11) NOT NULL DEFAULT '1',
  `featuring` int(11) NOT NULL DEFAULT '0',
  `see` int(11) NOT NULL DEFAULT '0',
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `ben4_blogs` ADD PRIMARY KEY (`id`);

ALTER TABLE `ben4_blogs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;


TABLE CATEGORIES BLOG __________________________
CREATE TABLE `ben4_blogcategories` (
  `id` int(11) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `add_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `ben4_blogcategories` ADD PRIMARY KEY (`id`);
--
ALTER TABLE `ben4_blogcategories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
