Skip to content

Instantly share code, notes, and snippets.

@uhlhosting

uhlhosting/SHOW CREATE TABLE

Created March 22, 2016 20:43
Show Gist options
  • Save uhlhosting/d9ad3448287aa3beb074 to your computer and use it in GitHub Desktop.
Save uhlhosting/d9ad3448287aa3beb074 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SHOW CREATE TABLE
MariaDB [(none)]> use wp_highpassion;
Database changed
MariaDB [wp_highpassion]> show create table wp_icl_strings;
+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| wp_icl_strings | CREATE TABLE `wp_icl_strings` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`language` varchar(10) NOT NULL,
`context` varchar(160) NOT NULL,
`name` varchar(160) NOT NULL,
`value` text NOT NULL,
`string_package_id` bigint(20) unsigned DEFAULT NULL,
`type` varchar(40) NOT NULL DEFAULT 'LINE',
`title` varchar(160) DEFAULT NULL,
`status` tinyint(4) NOT NULL,
`gettext_context` text NOT NULL,
`domain_name_context_md5` varchar(32) CHARACTER SET latin1 NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `uc_domain_name_context_md5` (`domain_name_context_md5`) USING BTREE,
KEY `string_package_id` (`string_package_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3643 DEFAULT CHARSET=utf8 |
+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
MariaDB [wp_highpassion]>
MariaDB [wp_highpassion]> show create table wp_icl_string_translations;
+----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| wp_icl_string_translations | CREATE TABLE `wp_icl_string_translations` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`string_id` bigint(20) unsigned NOT NULL,
`language` varchar(10) NOT NULL,
`status` tinyint(4) NOT NULL,
`value` text,
`translator_id` bigint(20) unsigned DEFAULT NULL,
`translation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`batch_id` int(11) NOT NULL DEFAULT '0',
`translation_service` varchar(16) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `string_language` (`string_id`,`language`)
) ENGINE=InnoDB AUTO_INCREMENT=2699 DEFAULT CHARSET=utf8 |
+----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
MariaDB [wp_highpassion]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment