Revize 795
Přidáno uživatelem Michal Kliment před více než 13 roky(ů)
freenetis/testing/application/upgrade_sql/upgrade_sql_791.php | ||
---|---|---|
<?php
|
||
|
||
// array of sql queries that upgrade database
|
||
$upgrade_sql[791] = array(
|
||
|
||
// GPS in address points is an point of GEOM
|
||
"ALTER TABLE `address_points` CHANGE `gps` `gps` POINT NULL DEFAULT NULL",
|
||
// added GPS GEOM polygon to tows
|
||
"ALTER TABLE `towns` ADD `gps` POLYGON NULL DEFAULT NULL",
|
||
// added GPS GEOM polygon to streets
|
||
"ALTER TABLE `streets` ADD `gps` POLYGON NULL DEFAULT NULL",
|
||
// added GPS GEOM line string to segments
|
||
"ALTER TABLE `segments` ADD `gps` LINESTRING NULL DEFAULT NULL"
|
||
|
||
);
|
||
?>
|
freenetis/testing/application/upgrade_sql/upgrade_sql_773.php | ||
---|---|---|
<?php
|
||
|
||
// array of sql queries that upgrade database
|
||
$upgrade_sql[773] = array(
|
||
|
||
// GPS in address points is an point of GEOM
|
||
"ALTER TABLE `address_points` CHANGE `gps` `gps` POINT NULL DEFAULT NULL",
|
||
// added GPS GEOM polygon to tows
|
||
"ALTER TABLE `towns` ADD `gps` POLYGON NULL DEFAULT NULL",
|
||
// added GPS GEOM polygon to streets
|
||
"ALTER TABLE `streets` ADD `gps` POLYGON NULL DEFAULT NULL",
|
||
// added GPS GEOM line string to segments
|
||
"ALTER TABLE `segments` ADD `gps` LINESTRING NULL DEFAULT NULL"
|
||
|
||
);
|
||
?>
|
Také k dispozici: Unified diff
Takze jeste je potreba prejmenovat jeden starsi SQL skript, aby to fungovalo spravne.