view release on metacpan or  search on metacpan

schema.sql  view on Meta::CPAN

# $Id: schema.sql,v 1.3 2010/11/29 04:00:53 matisse Exp $
#
# Schema for creating the database tables for an authentication system.

CREATE TABLE users (
	user     CHAR(16) PRIMARY KEY,
	password CHAR(24),
    active   BOOLEAN
);

CREATE TABLE groups (
	group CHAR(16),
	user CHAR(16)
);