from datetime import datetime
from sqlalchemy import (Table, Column, ForeignKey, ColumnDefault, UniqueConstraint, Index, and_, or_)
from sqlalchemy.types import *
from sqlalchemy.orm import relation, backref
from turbogears import database

from util import *
import plan

__all__ = ['flush']


##################################
# Planning schema
##################################

_mmfs_table = Table('Mmfs', database.metadata,
	Column('mmf_id', Integer, primary_key=True),
	Column('name', String(40), unique=True),
	Column('description', String(500)),
	Column('order', Integer, unique=True),
	Column('status',String(30) )) 


##################################
# Mappers
##################################

map_table(plan.Mmf, _mmfs_table)