   `language` varchar(7) COLLATE utf8_bin NOT NULL DEFAULT '',
   `allowed_firms` int(11) NOT NULL DEFAULT '10',
   `email_notices` tinyint(1) NOT NULL DEFAULT '1',
-  PRIMARY KEY (`user_id`),
-  KEY `email_notices` (`email_notices`)
-) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=433 ;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `tbl_profiles_fields`
---
-
-CREATE TABLE IF NOT EXISTS `tbl_profiles_fields` (
-  `id` int(11) NOT NULL AUTO_INCREMENT,
+  `is_blogger` tinyint(1) NOT NULL DEFAULT '0'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
+
+-- --------------------------------------------------------
+
+--
+-- Struttura della tabella `tbl_profiles_fields`
+--
+
+CREATE TABLE `tbl_profiles_fields` (
+  `id` int(11) NOT NULL,
   `varname` varchar(50) NOT NULL DEFAULT '',
   `title` varchar(255) NOT NULL DEFAULT '',
   `field_type` varchar(50) NOT NULL DEFAULT '',

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

--
-- Table structure for table `tbl_account`
--

CREATE TABLE IF NOT EXISTS `tbl_account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_parent_id` int(11) DEFAULT NULL,
  `firm_id` int(11) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '0',

  `is_adjustment` tinyint(1) NOT NULL DEFAULT '0',
  `is_included` tinyint(1) NOT NULL DEFAULT '1',
  `rank` int(11) NOT NULL,
  `transaction_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Struttura della tabella `tbl_language`
--

CREATE TABLE `tbl_language` (
  `id` int(11) NOT NULL,
  `language_code` char(3) CHARACTER SET utf8 NOT NULL,
  `country_code` char(3) CHARACTER SET utf8 DEFAULT NULL,
  `english_name` varchar(64) CHARACTER SET utf8 NOT NULL,
  `native_name` varchar(64) CHARACTER SET utf8 NOT NULL,
  `is_default` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dump dei dati per la tabella `tbl_language`
--

INSERT INTO `tbl_language` (`id`, `language_code`, `country_code`, `english_name`, `native_name`, `is_default`) VALUES
(1, 'en', 'US', 'US English', '', 2),
(2, 'it', 'IT', 'Italian', 'Italiano', 1),
(3, 'fr', 'FR', 'French', 'Français', 0),
(4, 'de', 'DE', 'German', 'Deutsche', 0),
(5, 'en', 'GB', 'UK English', '', 0),
(6, 'en', 'CA', 'Canadian English', '', 0),
(7, 'es', 'ES', 'Spanish', 'Español', 0),
(8, 'pt', 'PT', 'Portuguese', 'Português', 0);

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

--
-- Struttura della tabella `tbl_migration`
--

CREATE TABLE `tbl_migration` (
  `version` varchar(255) NOT NULL,
  `apply_time` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Struttura della tabella `tbl_posting`
--

CREATE TABLE `tbl_posting` (
  `id` int(11) NOT NULL,
  `account_id` int(11) NOT NULL,
  `journalentry_id` int(11) NOT NULL,
  `amount` decimal(16,2) NOT NULL COMMENT 'positive if Debit, negative if Credit',
  `rank` int(11) NOT NULL,
  `comment` varchar(100) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--
-- Struttura della tabella `tbl_profiles`
--

CREATE TABLE `tbl_profiles` (
  `user_id` int(11) NOT NULL,
  `first_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `last_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `school` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
