Of course. This is the output:
Local Databases/
http://localhost/phpmyadmin/server_sql. ... 59e25817c9
Su consulta se ejecutó con éxito.
SHOW CREATE TABLE myshop.users
users CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`superuser` smallint(6) NOT NULL DEFAULT '0',
`siteid` int(11) DEFAULT NULL,
`label` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`salutation` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`company` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`vatid` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`title` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`firstname` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`lastname` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`address1` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`address2` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`address3` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`postal` varchar(16) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`city` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`state` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`langid` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`countryid` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`telephone` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`telefax` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`website` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`longitude` decimal(8,6) DEFAULT NULL,
`latitude` decimal(8,6) DEFAULT NULL,
`birthday` date DEFAULT NULL,
`vdate` date DEFAULT NULL,
`status` smallint(6) NOT NULL DEFAULT '1',
`editor` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`),
KEY `idx_lvusr_langid` (`langid`),
KEY `idx_lvusr_last_first` (`lastname`,`firstname`),
KEY `idx_lvusr_post_addr1` (`postal`,`address1`),
KEY `idx_lvusr_post_city` (`postal`,`city`),
KEY `idx_lvusr_lastname` (`lastname`),
KEY `idx_lvusr_address1` (`address1`),
KEY `idx_lvusr_city` (`city`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
________
Local Databases/
http://localhost/phpmyadmin/server_sql. ... 59e25817c9
Su consulta se ejecutó con éxito.
SHOW CREATE TABLE myshop.users_address
users_address CREATE TABLE `users_address` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parentid` int(11) NOT NULL,
`siteid` int(11) NOT NULL,
`company` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`vatid` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`salutation` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`firstname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`lastname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`address1` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`address2` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`address3` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`postal` varchar(16) COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`state` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`langid` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
`countryid` char(2) COLLATE utf8_unicode_ci DEFAULT NULL,
`telephone` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`telefax` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`website` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`longitude` decimal(8,6) DEFAULT NULL,
`latitude` decimal(8,6) DEFAULT NULL,
`flag` int(11) NOT NULL,
`pos` smallint(6) NOT NULL,
`mtime` datetime NOT NULL,
`ctime` datetime NOT NULL,
`editor` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_lvuad_pid` (`parentid`),
KEY `idx_lvuad_last_first` (`lastname`,`firstname`),
KEY `idx_lvuad_post_addr1` (`postal`,`address1`),
KEY `idx_lvuad_post_city` (`postal`,`city`),
KEY `idx_lvuad_address1` (`address1`),
KEY `idx_lvuad_city` (`city`),
KEY `idx_lvuad_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Hope it´s helpful.