 -- Estructura de tabla para la tabla `profile_comments`
 --
 
-CREATE TABLE `profile_comments` (
-  `post_date` datetime NOT NULL default '0000-00-00 00:00:00',
-  `post_publisher` int(11) NOT NULL default '0',
+CREATE TABLE IF NOT EXISTS `profile_comments` (
+  `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `post_publisher` int(11) NOT NULL DEFAULT '0',
   `comment_date` datetime NOT NULL,
-  `comment_publisher` int(11) NOT NULL default '0',
-  `comment_text` text collate utf8_unicode_ci NOT NULL,
-  `edition_date` datetime default NULL,
-  PRIMARY KEY  (`post_date`,`post_publisher`,`comment_date`,`comment_publisher`),
-  KEY `post_publisher` (`post_publisher`),
-  KEY `comment_publisher` (`comment_publisher`)
+  `comment_publisher` int(11) NOT NULL DEFAULT '0',
+  `comment_text` text COLLATE utf8_unicode_ci NOT NULL,
+  `edition_date` datetime DEFAULT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 
 -- --------------------------------------------------------

-- Estructura de tabla para la tabla `trackings`
--

CREATE TABLE `trackings` (
  `tracking_user` int(11) NOT NULL default '0',
  `proposal` int(11) NOT NULL default '0',
  `init_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`tracking_user`,`proposal`),
  KEY `proposal` (`proposal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

-- Estructura de tabla para la tabla `responsibilities`
--

CREATE TABLE IF NOT EXISTS `responsibilities` (
  `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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