CREATE TABLE IF NOT EXISTS `um_group_list` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE IF NOT EXISTS `um_moderate_list` (
  `ID` int(11) NOT NULL auto_increment,
  `UM_Object_List_ID` int(11) default NULL,
  `Item_ID` int(11) default NULL,
  `UM_Group_ID` int(11) default NULL,
  `Status` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `UM_Object_List_ID` (`UM_Object_List_ID`),
  KEY `Item_ID` (`Item_ID`),
  KEY `UM_Group_ID` (`UM_Group_ID`),
  KEY `Status` (`Status`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

CREATE TABLE IF NOT EXISTS `um_object_list` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` varchar(255) default NULL,
  `Object_Tag` varchar(255) default NULL,
  `Object_Field` varchar(255) default NULL,
  `Area_Tag` varchar(255) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

CREATE TABLE IF NOT EXISTS `um_user_to_group` (
  `ID` int(11) NOT NULL auto_increment,
  `Group_ID` int(11) default NULL,
  `User_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `Group_ID` (`Group_ID`),
  KEY `User_ID` (`User_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `user_moderation` (
  `ID` int(11) NOT NULL auto_increment,
  `Email` varchar(255) default NULL,
  `Username` varchar(255) default NULL,
  `Password` varchar(255) default NULL,
  `Additional_Items` text,
  `Login_Token` text,
  `Last_Login` datetime default NULL,
  `UM_Group_ID` int(11) default NULL,
  `Created` datetime default NULL,
  `Updated` datetime default NULL,
  PRIMARY KEY  (`ID`),
  KEY `UM_Group_ID` (`UM_Group_ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;