Sha256: eb3ffef649f624cfce7175691727022a0afba522d13df62bc6b0491028cb399e

Contents?: true

Size: 1.08 KB

Versions: 4

Compression:

Stored size: 1.08 KB

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