Enum TableConstraint 

pub enum TableConstraint {
    Unique(UniqueConstraint),
    PrimaryKey(PrimaryKeyConstraint),
    ForeignKey(ForeignKeyConstraint),
    Check(CheckConstraint),
    Index(IndexConstraint),
    FulltextOrSpatial(FullTextOrSpatialConstraint),
}

A table-level constraint, specified in a CREATE TABLE or an ALTER TABLE ADD <constraint> statement.

Variants

Unique(UniqueConstraint)

MySQL definition for UNIQUE constraints statements:\

• [CONSTRAINT [<name>]] UNIQUE <index_type_display> [<index_name>] [index_type] (<columns>) <index_options>

where:

• index_type is USING {BTREE | HASH}
• index_options is {index_type | COMMENT 'string' | ... %currently unsupported stmts% } ...
• index_type_display is [INDEX | KEY]

PrimaryKey(PrimaryKeyConstraint)

MySQL definition for PRIMARY KEY constraints statements:\

• [CONSTRAINT [<name>]] PRIMARY KEY [index_name] [index_type] (<columns>) <index_options>

Actually the specification have no [index_name] but the next query will complete successfully:

CREATE TABLE unspec_table (
  xid INT NOT NULL,
  CONSTRAINT p_name PRIMARY KEY index_name USING BTREE (xid)
);

where:

• index_type is USING {BTREE | HASH}
• index_options is {index_type | COMMENT 'string' | ... %currently unsupported stmts% } ...

ForeignKey(ForeignKeyConstraint)

A referential integrity constraint ([ CONSTRAINT <name> ] FOREIGN KEY (<columns>) REFERENCES <foreign_table> (<referred_columns>) { [ON DELETE <referential_action>] [ON UPDATE <referential_action>] | [ON UPDATE <referential_action>] [ON DELETE <referential_action>] }).

Check(CheckConstraint)

[ CONSTRAINT <name> ] CHECK (<expr>) [[NOT] ENFORCED]

Index(IndexConstraint)

MySQLs index definition for index creation. Not present on ANSI so, for now, the usage is restricted to MySQL, as no other dialects that support this syntax were found.

{INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option]...

FulltextOrSpatial(FullTextOrSpatialConstraint)

MySQLs fulltext definition. Since the SPATIAL definition is exactly the same, and MySQL displays both the same way, it is part of this definition as well.

Supported syntax:

{FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...)

key_part: col_name

Trait Implementations

impl Clone for TableConstraint

fn clone(&self) -> TableConstraint

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for TableConstraint

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl Display for TableConstraint

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl From<CheckConstraint> for TableConstraint

fn from(constraint: CheckConstraint) -> Self

Converts to this type from the input type.

impl From<ForeignKeyConstraint> for TableConstraint

fn from(constraint: ForeignKeyConstraint) -> Self

Converts to this type from the input type.

impl From<FullTextOrSpatialConstraint> for TableConstraint

fn from(constraint: FullTextOrSpatialConstraint) -> Self

Converts to this type from the input type.

impl From<IndexConstraint> for TableConstraint

fn from(constraint: IndexConstraint) -> Self

Converts to this type from the input type.

impl From<PrimaryKeyConstraint> for TableConstraint

fn from(constraint: PrimaryKeyConstraint) -> Self

Converts to this type from the input type.

impl From<UniqueConstraint> for TableConstraint

fn from(constraint: UniqueConstraint) -> Self

Converts to this type from the input type.

impl Hash for TableConstraint

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for TableConstraint

fn cmp(&self, other: &TableConstraint) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for TableConstraint

fn eq(&self, other: &TableConstraint) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for TableConstraint

fn partial_cmp(&self, other: &TableConstraint) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Spanned for TableConstraint

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl Visit for TableConstraint

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

Visit this node with the provided Visitor.

impl VisitMut for TableConstraint

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>

Mutably visit this node with the provided VisitorMut.

impl Eq for TableConstraint

impl StructuralPartialEq for TableConstraint