table: product
DROP TABLE IF EXISTS product;
CREATE TABLE product (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
categoryId int(10) unsigned NOT NULL,
name varchar(45) NOT NULL,
displayOrder int(10) unsigned NOT NULL,
cost varchar(45) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into product (categoryId,name,displayOrder,cost) values (1,'test product 1',1,'40');
insert into product (categoryId,name,displayOrder,cost) values (1,'test product 2',2,'35');
insert into product (categoryId,name,displayOrder,cost) values (1,'test product 3',3,'30');
table: service
DROP TABLE IF EXISTS service;
CREATE TABLE service (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
categoryId int(10) unsigned NOT NULL,
name varchar(45) NOT NULL,
displayOrder int(10) unsigned NOT NULL,
cost varchar(45) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into service (categoryId,name,displayOrder,cost) values (1,'test service 1',1,'140');
insert into service (categoryId,name,displayOrder,cost) values (1,'test service 2',2,'135');
insert into service (categoryId,name,displayOrder,cost) values (1,'test service 3',3,'130');
table: productCategory
DROP TABLE IF EXISTS productCategory;
CREATE TABLE productCategory (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
name varchar(45) NOT NULL,
displayOrder int(10) unsigned,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into productCategory (name,displayOrder) values ('productCategory',1);
table: serviceCategory
DROP TABLE IF EXISTS serviceCategory;
CREATE TABLE serviceCategory (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
name varchar(45) NOT NULL,
displayOrder int(10) unsigned,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
insert into serviceCategory (name,displayOrder) values ('serviceCategory',1);