CREATE TABLE `tn_operators` (
  `oper_id` bigint(20) unsigned NOT NULL auto_increment,

  `nazwa` varchar(100) NOT NULL,

  `adres` char(100) default NULL,
  `postcode` char(10) default NULL,
  `city` varchar(20) default NULL,

  `phone` varchar(20) default NULL,
  `cellphone` char(9) default NULL,
  `fax` varchar(20) default NULL,
  `email` varchar(30) default NULL,

  `regon` char(9) default NULL,
  `nip` char(10) default NULL,
  `account_nb` char(28) default NULL,
  `bank_name` varchar(100) default NULL,

  `uwagi` longtext,

  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

CREATE TABLE `tn_operator2agency` (
 `id` bigint(20) unsigned NOT NULL auto_increment,

 `oper_id` bigint(20) unsigned NOT NULL,
 `agency_id` bigint(20) unsigned NOT NULL ,

 `procent` char(3) default NULL,
 `showoffers` enum('t','f') default 'f',
 `contract` enum('t','f') default 'f',

  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;

CREATE TABLE `tn_files` (
 `file_id` bigint(20) unsigned NOT NULL auto_increment,
 `oper_id` bigint(20) DEFAULT NULL,
 `agency_id` bigint(20) DEFAULT NULL,

 `doc_name` VARCHAR(50) DEFAULT NULL,
 `doc_path` VARCHAR(200) DEFAULT NULL,
 `stan` int(6) DEFAULT '0',
 `reminder` int(6) DEFAULT '0',

  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;