plugins/shop/share/db/sql/shop_manufacturers.sql.php
<?php
return '
`id` int(11) NOT NULL AUTO_INCREMENT,
`cat_ids` varchar(255) NOT NULL,
`name` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT \'\',
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`aliaces` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`meta_keywords` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`meta_desc` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`image` int(10) unsigned NOT NULL,
`sort_order` int(3) NOT NULL,
`active` int(3) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `url` (`url`)
';