148.sql (1109B)
1 -- +migrate Up 2 ALTER TABLE users ADD COLUMN poker_xmr_sub_address VARCHAR(255) NOT NULL DEFAULT ''; 3 CREATE INDEX users_poker_xmr_sub_address_idx ON users (poker_xmr_sub_address); 4 5 CREATE TABLE IF NOT EXISTS poker_xmr_transactions ( 6 id INTEGER NOT NULL PRIMARY KEY, 7 tx_id VARCHAR(255) NOT NULL, 8 user_id INTEGER NOT NULL, 9 address VARCHAR(255) NOT NULL, 10 amount INTEGER NOT NULL, 11 height INTEGER NOT NULL, 12 confirmations INTEGER NOT NULL, 13 is_in TINYINT(1) NOT NULL DEFAULT 0, 14 processed TINYINT(1) NOT NULL DEFAULT 0, 15 created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 16 updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, 17 CONSTRAINT poker_xmr_transactions_user_id_fk 18 FOREIGN KEY (user_id) 19 REFERENCES users (id) 20 ON DELETE NO ACTION 21 ON UPDATE CASCADE); 22 CREATE INDEX poker_xmr_transactions_user_id_idx ON poker_xmr_transactions (user_id); 23 CREATE INDEX poker_xmr_transactions_is_in_idx ON poker_xmr_transactions (is_in); 24 CREATE INDEX poker_xmr_transactions_tx_id_idx ON poker_xmr_transactions (tx_id); 25 26 -- +migrate Down