
CREATE TABLE `customer_payment_cards` (
  `id` int(11) UNSIGNED NOT NULL,
  `card_id` varchar(150) DEFAULT NULL,
  `shop_id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `property` text,
  `source` int(5) DEFAULT NULL COMMENT '1=bongloy, ...',
  `is_primary` tinyint(1) DEFAULT '0',
  `is_deleted` tinyint(4) DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


--
-- Indexes for dumped tables
--

--
-- Indexes for table `customer_payment_cards`
--
ALTER TABLE `customer_payment_cards`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `customer_payment_cards`
--
ALTER TABLE `customer_payment_cards`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;COMMIT;