# $Id: postgres7.sql,v 1.2 2006/04/16 20:50:04 dlnsk Exp $

# This file contains a complete database schema for all the
# tables used by the book module, written in SQL

# It may also contain INSERT statements for particular data
# that may be used, especially new entries in the table log_display

CREATE TABLE prefix_autoattendmod (
  id 			SERIAL PRIMARY KEY,
  course 		integer NOT NULL default '0',
  timemodified	integer NOT NULL default '0';
  name 			varchar(255) NOT NULL default ''
);

CREATE INDEX prefix_autoattendmod_course_idx ON prefix_autoattendmod (course);