-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `mt_edit`
--

CREATE TABLE `mt_edit` (
  `number` int(50) NOT NULL,
  `user` varchar(100) NOT NULL,
  `group_code` varchar(20) NOT NULL,
  `mt_id` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mt_money`
--

CREATE TABLE `mt_money` (
  `utc_time_for_chart` varchar(20) NOT NULL,
  `money_code` varchar(50) NOT NULL,
  `date` varchar(11) NOT NULL,
  `month_code` varchar(50) NOT NULL,
  `month` varchar(8) NOT NULL,
  `tickets` varchar(50) NOT NULL,
  `money` varchar(50) NOT NULL,
  `mt_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mt_money_month`
--

CREATE TABLE `mt_money_month` (
  `month_code` varchar(20) NOT NULL,
  `day_01` varchar(20) NOT NULL,
  `day_02` varchar(20) NOT NULL,
  `day_03` varchar(20) NOT NULL,
  `day_04` varchar(20) NOT NULL,
  `day_05` varchar(20) NOT NULL,
  `day_06` varchar(20) NOT NULL,
  `day_07` varchar(20) NOT NULL,
  `day_08` varchar(20) NOT NULL,
  `day_09` varchar(20) NOT NULL,
  `day_10` varchar(20) NOT NULL,
  `day_11` varchar(20) NOT NULL,
  `day_12` varchar(20) NOT NULL,
  `day_13` varchar(20) NOT NULL,
  `day_14` varchar(20) NOT NULL,
  `day_15` varchar(20) NOT NULL,
  `day_16` varchar(20) NOT NULL,
  `day_17` varchar(20) NOT NULL,
  `day_18` varchar(20) NOT NULL,
  `day_19` varchar(20) NOT NULL,
  `day_20` varchar(20) NOT NULL,
  `day_21` varchar(20) NOT NULL,
  `day_22` varchar(20) NOT NULL,
  `day_23` varchar(20) NOT NULL,
  `day_24` varchar(20) NOT NULL,
  `day_25` varchar(20) NOT NULL,
  `day_26` varchar(20) NOT NULL,
  `day_27` varchar(20) NOT NULL,
  `day_28` varchar(20) NOT NULL,
  `day_29` varchar(20) NOT NULL,
  `day_30` varchar(20) NOT NULL,
  `day_31` varchar(20) NOT NULL,
  `mt_id` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mt_money_year`
--

CREATE TABLE `mt_money_year` (
  `year` varchar(20) NOT NULL,
  `jan` varchar(20) NOT NULL,
  `feb` varchar(20) NOT NULL,
  `mar` varchar(20) NOT NULL,
  `apr` varchar(20) NOT NULL,
  `may` varchar(20) NOT NULL,
  `jun` varchar(20) NOT NULL,
  `jul` varchar(20) NOT NULL,
  `aug` varchar(20) NOT NULL,
  `sep` varchar(20) NOT NULL,
  `oct` varchar(20) NOT NULL,
  `nov` varchar(20) NOT NULL,
  `december` varchar(20) NOT NULL,
  `mt_id` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mt_profile`
--

CREATE TABLE `mt_profile` (
  `pro_name` varchar(50) NOT NULL,
  `pro_session` varchar(20) NOT NULL,
  `pro_idle` varchar(20) NOT NULL,
  `pro_keepalive` varchar(20) NOT NULL,
  `pro_autorefresh` varchar(20) NOT NULL,
  `pro_expire` varchar(20) NOT NULL,
  `pro_users` varchar(5) NOT NULL,
  `pro_limit` varchar(20) NOT NULL,
  `pro_price` int(6) NOT NULL,
  `vat` int(4) NOT NULL,
  `package_name` varchar(50) NOT NULL,
  `card_name` varchar(30) NOT NULL,
  `home_page` varchar(30) NOT NULL,
  `time_limit` varchar(30) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `server_ip` varchar(30) NOT NULL,
  `color` varchar(30) NOT NULL,
  `mt_id` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `mt_topup`
--

CREATE TABLE `mt_topup` (
  `num` int(11) NOT NULL,
  `topup_to` varchar(50) NOT NULL,
  `topup_from` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `mt_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pppoe_money`
--

CREATE TABLE `pppoe_money` (
  `utc_time_for_chart` varchar(20) NOT NULL,
  `money_code` varchar(50) NOT NULL,
  `date` varchar(11) NOT NULL,
  `month_code` varchar(50) NOT NULL,
  `month` varchar(8) NOT NULL,
  `tickets` varchar(50) NOT NULL,
  `money` varchar(50) NOT NULL,
  `mt_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pppoe_money_month`
--

CREATE TABLE `pppoe_money_month` (
  `month_code` varchar(20) NOT NULL,
  `day_01` varchar(20) NOT NULL,
  `day_02` varchar(20) NOT NULL,
  `day_03` varchar(20) NOT NULL,
  `day_04` varchar(20) NOT NULL,
  `day_05` varchar(20) NOT NULL,
  `day_06` varchar(20) NOT NULL,
  `day_07` varchar(20) NOT NULL,
  `day_08` varchar(20) NOT NULL,
  `day_09` varchar(20) NOT NULL,
  `day_10` varchar(20) NOT NULL,
  `day_11` varchar(20) NOT NULL,
  `day_12` varchar(20) NOT NULL,
  `day_13` varchar(20) NOT NULL,
  `day_14` varchar(20) NOT NULL,
  `day_15` varchar(20) NOT NULL,
  `day_16` varchar(20) NOT NULL,
  `day_17` varchar(20) NOT NULL,
  `day_18` varchar(20) NOT NULL,
  `day_19` varchar(20) NOT NULL,
  `day_20` varchar(20) NOT NULL,
  `day_21` varchar(20) NOT NULL,
  `day_22` varchar(20) NOT NULL,
  `day_23` varchar(20) NOT NULL,
  `day_24` varchar(20) NOT NULL,
  `day_25` varchar(20) NOT NULL,
  `day_26` varchar(20) NOT NULL,
  `day_27` varchar(20) NOT NULL,
  `day_28` varchar(20) NOT NULL,
  `day_29` varchar(20) NOT NULL,
  `day_30` varchar(20) NOT NULL,
  `day_31` varchar(20) NOT NULL,
  `mt_id` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pppoe_money_year`
--

CREATE TABLE `pppoe_money_year` (
  `year` varchar(11) NOT NULL,
  `jan` varchar(11) NOT NULL,
  `feb` varchar(11) NOT NULL,
  `mar` varchar(11) NOT NULL,
  `apr` varchar(11) NOT NULL,
  `may` varchar(11) NOT NULL,
  `jun` varchar(11) NOT NULL,
  `jul` varchar(11) NOT NULL,
  `aug` varchar(11) NOT NULL,
  `sep` varchar(11) NOT NULL,
  `oct` varchar(11) NOT NULL,
  `nov` varchar(11) NOT NULL,
  `december` varchar(11) NOT NULL,
  `mt_id` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pppoe_pro`
--

CREATE TABLE `pppoe_pro` (
  `pro_name` varchar(50) NOT NULL,
  `pro_local` varchar(50) NOT NULL,
  `pro_remote` varchar(50) NOT NULL,
  `pro_session` varchar(50) NOT NULL,
  `pro_limit` varchar(50) NOT NULL,
  `pro_expire` varchar(50) NOT NULL,
  `pro_price` int(6) NOT NULL,
  `vat` int(4) NOT NULL,
  `package_name` varchar(50) NOT NULL,
  `card_name` varchar(30) NOT NULL,
  `data_limit` varchar(30) NOT NULL,
  `time_limit` varchar(30) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `server_ip` varchar(30) NOT NULL,
  `color` varchar(30) NOT NULL,
  `mt_id` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `social_user`
--

CREATE TABLE `social_user` (
  `num` int(100) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `link` varchar(200) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `birthday` varchar(50) NOT NULL,
  `picture` varchar(200) NOT NULL,
  `last_login` varchar(50) NOT NULL,
  `date_login` varchar(50) NOT NULL,
  `social_type` varchar(50) NOT NULL,
  `mt_id` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for table `mt_edit`
--
ALTER TABLE `mt_edit`
  ADD PRIMARY KEY (`number`);

--
-- Indexes for table `mt_money`
--
ALTER TABLE `mt_money`
  ADD PRIMARY KEY (`utc_time_for_chart`);

--
-- Indexes for table `mt_money_month`
--
ALTER TABLE `mt_money_month`
  ADD PRIMARY KEY (`month_code`);

--
-- Indexes for table `mt_money_year`
--
ALTER TABLE `mt_money_year`
  ADD PRIMARY KEY (`year`);

--
-- Indexes for table `mt_profile`
--
ALTER TABLE `mt_profile`
  ADD PRIMARY KEY (`pro_name`);

--
-- Indexes for table `mt_topup`
--
ALTER TABLE `mt_topup`
  ADD PRIMARY KEY (`num`);

--
-- Indexes for table `pppoe_money`
--
ALTER TABLE `pppoe_money`
  ADD PRIMARY KEY (`utc_time_for_chart`);

--
-- Indexes for table `pppoe_money_month`
--
ALTER TABLE `pppoe_money_month`
  ADD PRIMARY KEY (`month_code`);

--
-- Indexes for table `pppoe_money_year`
--
ALTER TABLE `pppoe_money_year`
  ADD PRIMARY KEY (`year`);

--
-- Indexes for table `pppoe_pro`
--
ALTER TABLE `pppoe_pro`
  ADD PRIMARY KEY (`pro_name`);

--
-- Indexes for table `social_user`
--
ALTER TABLE `social_user`
  ADD PRIMARY KEY (`num`);

--
-- AUTO_INCREMENT for table `mt_edit`
--
ALTER TABLE `mt_edit`
  MODIFY `number` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `mt_topup`
--
ALTER TABLE `mt_topup`
  MODIFY `num` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `social_user`
--
ALTER TABLE `social_user`
  MODIFY `num` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

