    primary key (`parent`,`child`),
    foreign key (`parent`) references `AuthItem` (`name`) on delete cascade on update cascade,
    foreign key (`child`) references `AuthItem` (`name`) on delete cascade on update cascade
-);
+) engine InnoDB;
 
 create table `AuthAssignment`
 (

   `data`                 text,
   primary key (`itemname`,`userid`),
   foreign key (`itemname`) references `AuthItem` (`name`) on delete cascade on update cascade
);

   `bizrule`              text,
   `data`                 text,
   primary key (`name`)
) engine InnoDB;

create table `AuthItemChild`
(
