QS8BM6PF

1<?php
2$installer = $this;
3
4$installer->startSetup();
5$installer->run("
6DROP TABLE IF EXISTS `{$this->getTable('set')}`;
7CREATE TABLE `{$this->getTable('set')}` (
8  `set_id` int(11) unsigned NOT NULL auto_increment,
9  `title` varchar(255) NOT NULL default '',
10  `description` text NOT NULL default '',
11  `listing_description` text NOT NULL default '',
12  `category` varchar(255) NOT NULL default '',
13  `url_key` varchar(255) NOT NULL default '',
14  `status` smallint(6) NOT NULL default '0',
15  PRIMARY KEY (`set_id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17");
18
19$installer->run("
20DROP TABLE IF EXISTS `{$this->getTable('set_item')}`;
21CREATE TABLE `{$this->getTable('set_item')}` (
22  `set_item_id` int(11) unsigned NOT NULL auto_increment,
23  `set_id` int(11) NOT NULL default '0',
24  `item_id` int(11) NOT NULL default '0',
25  `sort_order` int(11) NOT NULL default '0',
26  PRIMARY KEY  (`set_item_id`),
27  INDEX (`set_id`),
28  INDEX (`item_id`)
29) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;
30  ");
31
32$installer->endSetup();