-#!/usr/bin/python2.6
+#!/usr/bin/python2.7
# -*- coding: iso-8859-15 -*-
# $Id$
# $HeadURL$
* version 1.2
* version 1.3 (no changes)
* version 1.4 (no changes)
+ * version 1.5 added time_report
:param metadata: metadata = sqlalchemy.MetaData()
"""
return Table("wrreport", metadata,
Column("page_id", types.Integer, schema.ForeignKey('wrsledruncache.page_id')),
Column("page_title", types.Unicode(255), nullable=False),
Column("date_report", types.Date),
+ Column("time_report", types.Time),
Column("date_entry", types.DateTime, nullable=False),
Column("date_invalid", types.DateTime),
Column("condition", types.Integer),
Column("position_latitude", types.Float),
Column("position_longitude", types.Float),
Column("position_elevation", types.Integer),
+ Column("operator", types.Unicode(255)),
Column("seats", types.Integer),
Column("overnight", types.Boolean),
Column("overnight_comment", types.Unicode(255)),