DROP TABLE IF EXISTS shareitem;
CREATE TABLE shareitem (
  id int(11) unsigned NOT NULL auto_increment,
  name varchar(200) NULL,
  state tinyint(4),
  PRIMARY KEY  (id)
);

INSERT INTO shareitem (id, name, state) VALUES 
  (1,'Plan 1', 1),
  (2,'Plan 2', 1),
  (3,'Plan 3', 2),
  (4,'Plan 4', 3);

DROP TABLE IF EXISTS plan;
CREATE TABLE plan (
  id int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (id)
);

INSERT INTO plan (id) VALUES 
  (1),
  (2),
  (3),
  (4);