   `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
   `name_local` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
   `name_short` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
-  `name_ogone` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
+  `name_ogone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
   PRIMARY KEY (`id`),
   FULLTEXT KEY `name_short` (`name_short`)
 ) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


CREATE TABLE IF NOT EXISTS `file` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `unique_name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `mime_type` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
  `size` int(11) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)


CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lastname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `country_id` int(11) NOT NULL,
  `date_of_birth` date NOT NULL,
  `admin` tinyint(1) NOT NULL,
