Sha256: 31f7f9b1b4c7a900c6db3c32f8b2af9a1ba2572b5f9872cfbc3e16ae31852ba4

Contents?: true

Size: 1.05 KB

Versions: 4

Compression:

Stored size: 1.05 KB

Contents

----------------------------------------------------------------------
-- DDL for PostgreSQL
--   generated by kwatable with template 'ddl-postgresql.eruby'
--   at Sun Sep 17 21:18:58 JST 2006
----------------------------------------------------------------------

-- group master table
drop table groups;
create table groups (
   id                   serial               primary key,
   name                 varchar(63)          not null unique,
   "desc"               text                 
);

-- member master table
drop table members;
create table members (
   id                   serial               primary key,
   name                 varchar(63)          not null unique,
   "desc"               text                 ,
   email                varchar(63)          ,
   gender               varchar(1)           ,  -- 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.pgsql.sql
kwartz-3.1.0 examples/rails2/db/create-tables.pgsql.sql
kwartz-3.1.1 examples/rails2/db/create-tables.pgsql.sql
kwartz-3.1.2 examples/rails2/db/create-tables.pgsql.sql