Devart Forum

Код: Выделить всё

CREATE TABLE tg_users_perks(
  id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  fk_player_id BIGINT(20) UNSIGNED DEFAULT NULL,
  fk_perk_id BIGINT(20) UNSIGNED DEFAULT NULL,
  perk_level INT(11) UNSIGNED DEFAULT 1,
  added_timestamp TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  INDEX IX_tg_users_perks_fk_player_id (fk_player_id),
  UNIQUE INDEX UK_tg_users_perks_id (id)
)
ENGINE = INNODB
AUTO_INCREMENT = 40
AVG_ROW_LENGTH = 1638
CHARACTER SET utf8
COLLATE utf8_general_ci;

Код: Выделить всё

mysql> select version();
+------------------+
| version()        |
+------------------+
| 5.1.52-community |
+------------------+
1 row in set (0.00 sec)

mysql> show VARIABLES like '%sql_mode%';
+---------------+----------------------------------------------------------------+
| Variable_name | Value                                                          |
+---------------+----------------------------------------------------------------+
| sql_mode      | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+---------------+----------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> show VARIABLES like '%auto_increment%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| auto_increment_increment | 1     |
| auto_increment_offset    | 1     |
+--------------------------+-------+
2 rows in set (0.00 sec)