CREATE TABLE IF NOT EXISTS `product` (
`product_id` int(5) NOT NULL auto_increment,
`brand_id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`group_id` int(2) NOT NULL,
`short_model` varchar(100) NOT NULL,
`full_model` varchar(100) NOT NULL,
PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
table product_group Code
CREATE TABLE IF NOT EXISTS `product_group` (
`group_id` int(2) NOT NULL auto_increment,
`group_name` varchar(100) NOT NULL,
`group_order` tinyint(2) NOT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Load balance : Server 02
Quote:
