Contents

CREATE TABLE `fun_users` (
  `id` int(11) NOT NULL auto_increment,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `login` varchar(50) NOT NULL,
  `email` varchar(50) NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

CREATE TABLE `groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `description` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

CREATE TABLE `group_memberships` (
  `id` int(11) NOT NULL auto_increment,
  `fun_user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

CREATE TABLE `group_tag` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=InnoDB;

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
dr_nic_magic_models-0.7.0	test/fixtures/db_definitions/mysql.sql
dr_nic_magic_models-0.7.1	test/fixtures/db_definitions/mysql.sql