CREATE TABLE

CREATE TABLE [IF NOT EXISTS] table_name (
  column_name data_type [constraints],
  ...
  [INDEX | PRIMARY KEY | UNIQUE | FOREIGN KEY]
) [ENGINE=InnoDB] [DEFAULT CHARSET=utf8mb4];

CREATE TABLE IF NOT EXISTS users ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(50) NOT NULL UNIQUE COMMENT '', email VARCHAR(100) NOT NULL UNIQUE COMMENT '', password_hash VARCHAR(255) NOT NULL COMMENT '', status TINYINT DEFAULT 1 COMMENT '0: 1:', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_email (email), INDEX idx_status (status)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='';

CREATE TABLE orders ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, order_no VARCHAR(32) NOT NULL UNIQUE COMMENT '', user_id BIGINT UNSIGNED NOT NULL COMMENT 'ID', total_amount DECIMAL(10,2) NOT NULL DEFAULT 0.00, status TINYINT DEFAULT 0 COMMENT '0: 1: 2: 3:', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE RESTRICT, INDEX idx_user_id (user_id), INDEX idx_status_created (status, created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

DESC users;
SHOW CREATE TABLE users;

CREATE TEMPORARY TABLE tmp_active_users AS
  SELECT id, username FROM users WHERE status = 1;