Структура таблицы b_option:
1 2 3 4 5 6 7 8 9 10 11 |
mysql> describe b_option; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | MODULE_ID | varchar(50) | YES | MUL | NULL | | | NAME | varchar(50) | NO | MUL | NULL | | | VALUE | text | YES | | NULL | | | DESCRIPTION | varchar(255) | YES | | NULL | | | SITE_ID | char(2) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ 5 rows in set (0.01 sec) |
Получить SQL-инструкцию для создания таблицы:
1 2 3 4 5 6 7 8 9 10 |
mysql> show create table b_option; CREATE TABLE `b_option` ( `MODULE_ID` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `NAME` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `VALUE` text COLLATE utf8_unicode_ci, `DESCRIPTION` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `SITE_ID` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, UNIQUE KEY `ix_option` (`MODULE_ID`,`NAME`,`SITE_ID`), KEY `ix_option_name` (`NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
Получить SQL-инструкцию для создания БД:
1 2 3 4 5 6 7 |
mysql> SHOW CREATE DATABASE testdb; +------------+---------------------------------------------------------------------------------------------+ | Database | Create Database | +------------+---------------------------------------------------------------------------------------------+ | testdb | CREATE DATABASE `testdb` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */ | +------------+---------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) |