/*==============================================================*//* DBMS name: MySQL 5.0 *//* Created on: 21/03/2006 18:11:39 *//*==============================================================*/drop table if exists junks;drop table if exists tagmaps;drop table if exists tags;create table junks( id int not null auto_increment, name varchar(255) not null, primary key (id))type = InnoDB;create table tagmaps( id int not null auto_increment, junk_id int not null, tag_id int not null, primary key (id))type = InnoDB;create table tags( id int not null auto_increment, name varchar(255) not null, primary key (id))type = InnoDB;alter table tagmaps add constraint fk_for_junk foreign key (junk_id) references junks(id) on delete restrict on update restrict;alter table tagmaps add constraint fk_tag foreign key (tag_id) references tags(id) on delete restrict on update restrict;