DROP TABLE IF EXISTS item;
CREATE TABLE item (
  id int(11) unsigned NOT NULL auto_increment,
  name varchar(200) NULL,
  prop int(11) unsigned default NULL,
  PRIMARY KEY  (id)
);

INSERT INTO item (id, name, prop) VALUES 
  (1,'Item 1',1),
  (2,'Item 2',2),
  (3,'Item 3',3),
  (4,'Item 4',4);

DROP TABLE IF EXISTS prop;
CREATE TABLE prop (
  id int(11) unsigned NOT NULL auto_increment,
  item int(11) unsigned default NULL,
  value varchar(200) NULL,
  PRIMARY KEY  (id)
);

INSERT INTO prop (id, item, value) VALUES 
  (1,1,'Value 1'),
  (2,2,'Value 2'),
  (3,3,'Value 3'),
  (4,4,'Value 4');