Contents

----------------------------------------------------------------------
-- DDL for MySQL
--   generated by kwatable with template 'ddl-mysql.eruby'
--   at Sun Sep 17 21:18:57 JST 2006
----------------------------------------------------------------------

-- group master table
drop table if exists groups;
create table groups (
   id                   integer              auto_increment primary key,
   name                 varchar(63)          not null unique,
   `desc`               text                 
);

-- member master table
drop table if exists members;
create table members (
   id                   integer              auto_increment primary key,
   name                 varchar(63)          not null unique,
   `desc`               text                 ,
   email                varchar(63)          ,
   gender               enum('M', 'W', 'X')  ,
   birth                date                 ,
   group_id             integer              not null references groups(id),
   created_at           timestamp            not null,
   updated_at           timestamp            not null
);

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
kwartz-3.2.0	examples/rails2/db/create-tables.mysql.sql
kwartz-3.1.0	examples/rails2/db/create-tables.mysql.sql
kwartz-3.1.1	examples/rails2/db/create-tables.mysql.sql
kwartz-3.1.2	examples/rails2/db/create-tables.mysql.sql