# Path: nrcif/records.py

# 
# Path: nrcif/ztr_reader.py
# class ZTR(nrcif.mca_reader.MCA):
#     def __init__(self, cur):


from ..records import layouts as mca_layouts
from ..ztr_reader import reduced_hd, corrected_bx
# Copyright 2013 - 2016, James Humphry

#  This program is free software; you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation; either version 2 of the License, or
#  (at your option) any later version.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program; if not, write to the Free Software
#  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
#  MA 02110-1301, USA.
#

'''Generate SQL that will create a suitable schema for storing data
from ATOC .ZTR timetable files. This is done dynamically to ensure it
keeps in sync with the definitions in nrcif.py, ztr_reader.py and
nrcif_fields.py'''




def gen_sql(DDL, CONS):

    SCHEMA = "ztr"


# Path: nrcif/records.py

# 
# Path: nrcif/ztr_reader.py
# class ZTR(nrcif.mca_reader.MCA):
#     def __init__(self, cur):


# Path: nrcif/schema/schemagen_ztr.py
from ..records import layouts as mca_layouts
from ..ztr_reader import reduced_hd, corrected_bx

# Copyright 2013 - 2016, James Humphry

#  This program is free software; you can redistribute it and/or modify
#  it under the terms of the GNU General Public License as published by
#  the Free Software Foundation; either version 2 of the License, or
#  (at your option) any later version.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program; if not, write to the Free Software
#  Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
#  MA 02110-1301, USA.
#

'''Generate SQL that will create a suitable schema for storing data
from ATOC .ZTR timetable files. This is done dynamically to ensure it
keeps in sync with the definitions in nrcif.py, ztr_reader.py and
nrcif_fields.py'''




def gen_sql(DDL, CONS):

    SCHEMA = "ztr"


    layouts = mca_layouts.copy()