CREATE TABLE IF NOT EXISTS `clientsshared` (
  `id_client` int(11) NOT NULL AUTO_INCREMENT,
  `login` char(20) NOT NULL,
  `password` char(20) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `id_tariff` int(11) NOT NULL DEFAULT '0',
  `account_state` decimal(12,4) NOT NULL DEFAULT '0.0000',
  `tech_prefix` char(255) NOT NULL,
  `id_reseller` int(11) NOT NULL DEFAULT '-1',
  `type2` int(11) NOT NULL DEFAULT '0',
  `type3` int(11) NOT NULL DEFAULT '0',
  `id_intrastate_tariff` int(11) NOT NULL DEFAULT '-1',
  `id_currency` int(11) NOT NULL DEFAULT '1',
  `codecs` int(11) NOT NULL DEFAULT '0',
  `primary_codec` int(11) NOT NULL DEFAULT '0',
  `free_seconds` varchar(255) DEFAULT NULL,
  `id_tariff_vod` int(11) NOT NULL DEFAULT '0',
  `siokrhotjiiatr` varchar(20) DEFAULT NULL,
  `msiozraonjit` varchar(20) DEFAULT NULL,
  `web_password` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id_client`),
  UNIQUE KEY `IX_ClientsLoginsCS` (`login`),
  KEY `IX_ClientsSharedReseller` (`id_reseller`),
  KEY `IX_ClientsSharedTariffs` (`id_tariff`),
  KEY `IX_ClientsSharedCurrency` (`id_currency`),
  KEY `IX_ClientsSharedWebPassword` (`web_password`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=644 ;