Купоны для Ферма Соседи 2015-12-28

--
-- Table structure for table `tb_kupon`
--

CREATE TABLE IF NOT EXISTS `tb_kupon` (
  `id` int(11) NOT NULL,
  `login` varchar(55) NOT NULL,
  `user_id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `summa` double(10,2) NOT NULL,
  `date_last_sbor` int(11) NOT NULL,
  `date_next_sbor` int(11) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `tb_kupon_price`
--

CREATE TABLE IF NOT EXISTS `tb_kupon_price` (
  `id` int(11) NOT NULL,
  `price` double(10,2) NOT NULL,
  `nominal` double(10,2) NOT NULL,
  `energy` int(11) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

-- --------------------------------------------------------
--
-- Table structure for table `tb_kupon_king`
--

CREATE TABLE IF NOT EXISTS `tb_kupon_king` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `login` varchar(55) NOT NULL,
  `summa_pok` double(10,2) NOT NULL,
  `summa_prod` double(10,2) NOT NULL,
  `koll_kupon` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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