· 6 years ago · Jun 18, 2019, 02:20 AM
1CREATE TABLE `cm_depMethods` (
2 `id` int(10) NOT NULL,
3 `methods` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
4 `processor` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
5 `account` varchar(300) CHARACTER SET utf8 DEFAULT NULL,
6 `address` varchar(200) NOT NULL,
7 `publick_key` varchar(300) CHARACTER SET utf8 DEFAULT NULL,
8 `secret_key` varchar(300) CHARACTER SET utf8 DEFAULT NULL,
9 `info` varchar(100) CHARACTER SET utf8 DEFAULT NULL,
10 `ipn` varchar(300) CHARACTER SET utf8 DEFAULT NULL,
11 `status` varchar(10) CHARACTER SET utf8 DEFAULT NULL COMMENT '1=active, 2=inactive',
12 `created` varchar(20) CHARACTER SET utf8 DEFAULT NULL
13) ENGINE=MyISAM DEFAULT CHARSET=latin1;
14
15--
16-- Déchargement des données de la table `cm_depMethods`
17--
18
19INSERT INTO `cm_depMethods` (`id`, `methods`, `processor`, `account`, `address`, `publick_key`, `secret_key`, `info`, `ipn`, `status`, `created`) VALUES
20(1, 'Bitcoin', 'coinpayments', '', '', '', '', 'BTC', '', '1', ''),
21(2, 'PayPal', 'express_checkout', '', '', '', '', '', '', '1', ''),
22(3, 'pagseguro', 'pagseguro', 'email_pagseguro', '', 'token_pagseguro', '', '', '', '1', '');