--
-- Table `plans_extra`
--

CREATE TABLE `plans_extra` (
    `id` int(11) UNSIGNED NOT NULL,
    `build_count_extra` int(11) NOT NULL,
    `price` decimal(10,2) NOT NULL,
    `status` int(11) NOT NULL,
    `deleted_at` int(11) NOT NULL,
    `api_id` text COLLATE utf8_unicode_ci NOT NULL,
    `save` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------
--
-- Table `subscribes_extra`
--

CREATE TABLE `subscribes_extra` (
  `id` int(11) UNSIGNED NOT NULL,
  `subscribe_extra_external_id` text COLLATE utf8_unicode_ci NOT NULL,
  `customer_extra_external_id` text COLLATE utf8_unicode_ci NOT NULL,
  `plan_extra_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `is_disable` int(11) NOT NULL,
  `app_id` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `uid` text COLLATE utf8_unicode_ci NOT NULL,
  `is_active` int(11) NOT NULL,
  `method_id` int(11) NOT NULL,
  `build_count_extra` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------
--
-- Table `transactions_extra`
--

CREATE TABLE `transactions_extra` (
  `id` int(11) UNSIGNED NOT NULL,
  `uid` text COLLATE utf8_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` int(11) NOT NULL,
  `updated_at` int(11) NOT NULL,
  `created_at` int(11) NOT NULL,
  `method_id` int(11) NOT NULL,
  `subscribe_extra_external_id` text COLLATE utf8_unicode_ci NOT NULL,
  `external_extra_uid` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------
--
-- Table index list
--

--
-- Index list `plans_extra`
--
ALTER TABLE `plans_extra`
  ADD PRIMARY KEY (`id`);

--
-- Index list `subscribes_extra`
--
ALTER TABLE `subscribes_extra`
  ADD PRIMARY KEY (`id`);

--
-- Index list `transactions_extra`
--
ALTER TABLE `transactions_extra`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT
--

--
-- AUTO_INCREMENT for table `plans_extra`
--
ALTER TABLE `plans`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `subscribes_extra`
--
ALTER TABLE `subscribes_extra`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions_extra`
--
ALTER TABLE `transactions_extra`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;