foreignkey.vm

来自「一个数据访问层Torque3.1的生成器的源代码」· VM 代码 · 共 17 行

-----------------------------------------------------------------------------
-- $table.Name: FOREIGN KEYS
-----------------------------------------------------------------------------
#foreach ($fk in $table.ForeignKeys)
ALTER TABLE $table.Name
    ADD CONSTRAINT $fk.Name FOREIGN KEY ($fk.LocalColumnNames)
    REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
#if ($fk.hasOnUpdate())
    ON UPDATE $fk.OnUpdate
#end
#if ($fk.hasOnDelete())
    ON DELETE $fk.OnDelete 
#end    
;
#end