NAME

FabForce::DBDesigner4::SQL::Mysql

VERSION

version 0.31

SYNOPSIS

my $create_stmt = FabForce::DBDesigner4::SQL::Mysql->create_table( $fabforce_table_object );

DESCRIPTION

As each database system has its own syntax, it is important to provide functions for each system.

NAME

FabForce::DBDesigner4::SQL::Mysql - create sql with mysql specific syntax

METHODS

create_table

my $create_stmt = FabForce::DBDesigner4::SQL::Mysql->create_table( $fabforce_table_object );

Things it does:

  • Use AUTO_INCREMENT instead of AUTOINCREMENT

  • don't use foreign keys

drop_table

create a "drop table" statement for the given tablename

$class->drop_table( $fabforce_table_object );

returns

DROP TABLE IF EXISTS `tablename`

AUTHOR

Renee Baecker, <module@renee-baecker.de>

COPYRIGHT AND LICENSE

Copyright (C) 2005 - 2009 by Renee Baecker

This program is free software; you can redistribute it and/or modify it under the terms of the Artistic License version 2.0.

AUTHOR

Renee Baecker <module@renee-baecker.de>

COPYRIGHT AND LICENSE

This software is Copyright (c) 2010 by Renee Baecker.

This is free software, licensed under:

The Artistic License 2.0