Advertisement
dashed-slug

Tables for Bitcoin and Altcoin Wallets 2.8.2 (prefix:wp_)

Nov 10th, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE wp_wallets_txs (
  2.                                id int(10) UNSIGNED NOT NULL,
  3.                                blog_id bigint(20) NOT NULL DEFAULT '1' COMMENT 'blog_id for multisite installs',
  4.                                category enum('deposit','move','withdraw') NOT NULL COMMENT 'type of transaction',
  5.                                tags varchar(255) NOT NULL DEFAULT '' COMMENT 'space separated list of tags, slugs, etc that further describe the type of transaction',
  6.                                account bigint(20) UNSIGNED NOT NULL COMMENT 'wp_users.ID',
  7.                                other_account bigint(20) UNSIGNED DEFAULT NULL COMMENT 'wp_users.ID when category==move',
  8.                                address varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '' COMMENT 'blockchain address when category==deposit or category==withdraw',
  9.                                txid varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL COMMENT 'blockchain transaction id',
  10.                                symbol varchar(5) NOT NULL COMMENT 'coin symbol (e.g. BTC for Bitcoin)',
  11.                                amount decimal(20,10) NOT NULL COMMENT 'amount plus any fees deducted from account',
  12.                                fee decimal(20,10) NOT NULL DEFAULT '0.0000000000' COMMENT 'fees deducted from account',
  13.                                comment text COMMENT 'transaction comment',
  14.                                created_time datetime NOT NULL COMMENT 'when transaction was entered into the system in GMT',
  15.                                updated_time datetime NOT NULL COMMENT 'when transaction was last updated in GMT (e.g. for update to confirmations count)',
  16.                                confirmations mediumint(8) UNSIGNED DEFAULT '0' COMMENT 'amount of confirmations received from blockchain, or null for category==move',
  17.                                status enum('unconfirmed','pending','done','failed','cancelled') NOT NULL DEFAULT 'unconfirmed' COMMENT 'state of transaction',
  18.                                retries tinyint(3) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'retries left before a pending transaction status becomes failed',
  19.                                admin_confirm tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 if an admin has confirmed this transaction',
  20.                                user_confirm tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 if the user has confirmed this transaction over email',
  21.                                nonce char(32) DEFAULT NULL COMMENT 'nonce for user to confirm via emailed link',
  22.                                extra varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL COMMENT 'extra info required by some coins such as XMR'
  23.                                ) ENGINE=InnoDB;
  24.  
  25. ALTER TABLE wp_wallets_txs
  26. ADD PRIMARY KEY (id),
  27. ADD UNIQUE KEY uq_tx_idx (txid,symbol),
  28. ADD KEY account_idx (account),
  29. ADD KEY blogid_idx (blog_id);
  30.  
  31. CREATE TABLE wp_wallets_adds (
  32.                                 id int(10) UNSIGNED NOT NULL,
  33.                                 blog_id bigint(20) NOT NULL DEFAULT '1' COMMENT 'blog_id for multisite installs',
  34.                                 account bigint(20) UNSIGNED NOT NULL COMMENT 'wp_users.ID',
  35.                                 symbol varchar(5) COLLATE latin1_bin NOT NULL COMMENT 'coin symbol (e.g. BTC for Bitcoin)',
  36.                                 address varchar(255) COLLATE latin1_bin NOT NULL,
  37.                                 created_time datetime NOT NULL COMMENT 'when address was requested in GMT',
  38.                                 extra varchar(255) COLLATE latin1_bin NOT NULL DEFAULT '' COMMENT 'extra info required by some coins such as XMR'
  39.                                 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;
  40.  
  41. ALTER TABLE wp_wallets_adds
  42. ADD PRIMARY KEY (id),
  43. ADD UNIQUE KEY uq_ad_idx (address,symbol,extra),
  44. ADD KEY retrieve_idx (account,symbol),
  45. ADD KEY lookup_idx (address);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement