#!/usr/bin/perl
#    This file is part of fk, a method for using UNIX 'make' to help
#    create schema which have foreign key constraints.
#
#    Copyright (C) 2009 Toby Thain, toby@telegraphics.com.au
#
#    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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA

use strict;
use warnings;

my $f;
$f = 0;
while(<>) {
	if(m/^CREATE TABLE (IF NOT EXISTS )?`?(\w+)/i) {  # assumes CREATE TABLE is at beginning of the line
		print "$2\n";
		open(F, ">sql/$2.sql");
		$f = 1;
	}
	$f && print F $_;
	if(m/^\)?\s*ENGINE\b/i) {  # assumes last line of table def'n starts with word 'ENGINE'
		close(F);
		$f = 0;
	}
}