Skip to content

Instantly share code, notes, and snippets.

@kosarlukascz
Last active January 28, 2020 13:29
Show Gist options
  • Save kosarlukascz/11144a9f56c107cb0dafaebb4d022b0f to your computer and use it in GitHub Desktop.
Save kosarlukascz/11144a9f56c107cb0dafaebb4d022b0f to your computer and use it in GitHub Desktop.
Create DB tables
CREATE TABLE IF NOT EXISTS wp_upvay_rf_payments (
id mediumint(9) NOT NULL AUTO_INCREMENT,
time time DEFAULT '0000-00-00 00:00:00' NOT NULL,
order_id mediumint(255) NOT NULL,
var_symbol mediumint(255) NOT NULL,
cislo_ucet mediumint(255) NOT NULL,
price mediumint(255) NOT NULL,
status text NOT NULL,
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS wp_upvay_rf_payments (
id mediumint(9) NOT NULL AUTO_INCREMENT,
time time DEFAULT '0000-00-00 00:00:00' NOT NULL,
text text NOT NULL,
PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment