NAME

FabForce::DBDesigner4::SQL::Sqlite

VERSION

version 0.31

SYNOPSIS

  my $create_stmt = FabForce::DBDesigner4::SQL::Sqlite->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::Sqlite - create sql with Sqlite specific syntax

METHODS

create_table

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

Things it does:

  • Use AUTO_INCREMENT instead of AUTOINCREMENT

  • does not 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