Revize 381
Přidáno uživatelem Jiří Sviták před asi 15 roky(ů)
freenetis/trunk/kohana/application/upgrade_sql/upgrade_sql.php | ||
---|---|---|
|
||
$upgrade_sql[get_SVN_rev()] = array(
|
||
"ALTER TABLE `wireless_settings` ADD `frequence` INT NULL DEFAULT NULL AFTER `norm` ",
|
||
"ALTER TABLE `wireless_settings` CHANGE `channel` `channel` INT( 11 ) NULL DEFAULT NULL ",
|
||
"SET @@foreign_key_checks = 0;",
|
||
"ALTER TABLE ip_addresses ADD FOREIGN KEY ( iface_id ) REFERENCES ifaces( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE ip_addresses ADD FOREIGN KEY ( vlan_iface_id ) REFERENCES vlan_ifaces( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE ip_addresses ADD FOREIGN KEY ( subnet_id ) REFERENCES subnets( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE ifaces ADD FOREIGN KEY ( segment_id ) REFERENCES segments( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE ifaces ADD FOREIGN KEY ( device_id ) REFERENCES devices( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE ports ADD FOREIGN KEY ( segment_id ) REFERENCES segments( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE ports ADD FOREIGN KEY ( device_id ) REFERENCES devices( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE vlan_ifaces ADD FOREIGN KEY ( iface_id ) REFERENCES ifaces( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"ALTER TABLE vlan_ifaces ADD FOREIGN KEY ( vlan_id ) REFERENCES vlans( id ) ON UPDATE CASCADE ON DELETE RESTRICT ;",
|
||
"SET @@foreign_key_checks = 1;"
|
||
|
||
"ALTER TABLE `wireless_settings` CHANGE `channel` `channel` INT( 11 ) NULL DEFAULT NULL "
|
||
);
|
||
|
||
?>
|
Také k dispozici: Unified diff
Zmena, zavislosti se nebudou resit databazove, ale v kohane pomoci ORM. V mysql nefunguje spravne referencni integrita.