The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

MKDoc::SQL::Type::ALL - ALL MKDoc column types

SUMMARY

There are many data types which can be used for SQL columns. Each datatype object can be constructed as follows:

    my $datatype = $class->new (%args).
    

The list of datatypes and arguments which can be passed to the constructor is defined below.

DATA TYPES

MKDoc::SQL::Type::BigInt

unsigned => [ 1 | 0 ] (default: 0)
not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Blob

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Char

size => 1 to 255. (default: 255)
not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Date

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::DateTime

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Double

zerofill => [ 1 | 0]
digits => number of digits
decimals => number of decimals
not_null => [ 1 | 0 ]

MKDoc::SQL::Type::Float

zerofill => [ 1 | 0]
digits => number of digits
decimals => number of decimals
not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Int

unsigned => [ 1 | 0 ] (default: 0)
zerofill => [ 1 | 0]
not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::LongBlob

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::LongText

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::MediumBlob

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::MediumText

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Numeric

unsigned => [ 1 | 0 ] (default: 0)
zerofill => [ 1 | 0]
not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::SmallInt

unsigned => [ 1 | 0 ] (default: 0)
zerofill => [ 1 | 0]
not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Text

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::Time

not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::TinyInt

unsigned => [ 1 | 0 ] (default: 0)
zerofill => [ 1 | 0]
not_null => [ 1 | 0 ] (default: 0)

MKDoc::SQL::Type::VarChar

size => 1 to 255. (default: 255)
not_null => [ 1 | 0 ] (default: 0)