<ul>
<li>Adds event.geopoint field (point)</li>
<li>Populates event.geopoint for all event entities</li>
<li>Adds a spatial index on event.geopoint</li>
<li>Creates databse triggers on insert / update to keep geopoint updated</li>
</ul>
<form method="post">
<input type="submit" name="go" value="test" />
<input type="submit" name="go" value="run" />
</form>
<?php
if (!empty($_POST['go']) && ($_POST['go'] == 'run' || $_POST['go'] == 'test')) {
if ($_POST['go'] == 'run') {
echo '<p>Running updater...</p>' . "\n";
$mode = 'run';
} else {
echo '<p>Testing updates...</p>' . "\n";
$mode = 'test';
}
if ($mode) {
$update = new updateTypes($mode, $reason_user_id);
$update->add_event_binary_data($mode, $reason_user_id);
}
}
?>
<p><a href="index.php">Return to Index</a></p>
</body>
</html>
<p>What will this update do?</p>
<ul>
<li>Add the feature type to Reason</li>
<li>Fix the content sorter for the policy type</li>
</ul>
<form method="post">
<input type="submit" name="go" value="test" />
<input type="submit" name="go" value="run" />
</form>
<?php
if (!empty($_POST['go']) && ($_POST['go'] == 'run' || $_POST['go'] == 'test')) {
if ($_POST['go'] == 'run') {
echo '<p>Running updater...</p>' . "\n";
$mode = 'run';
} else {
echo '<p>Testing updates...</p>' . "\n";
$mode = 'test';
}
if ($mode) {
$update = new updateTypes($mode, $reason_user_id);
$update->create_feature_type($mode, $reason_user_id);
$update->fix_policy_content_sorter($mode, $reason_user_id);
}
}
?>
<p><a href="index.php">Return to Index</a></p>
</body>
</html>
<input type="submit" name="go" value="test" />
<input type="submit" name="go" value="run" />
</form>
<?php
if (!empty($_POST['go']) && ($_POST['go'] == 'run' || $_POST['go'] == 'test')) {
if ($_POST['go'] == 'run') {
echo '<p>Running updater...</p>' . "\n";
$mode = 'run';
} else {
echo '<p>Testing updates...</p>' . "\n";
$mode = 'test';
}
// Update css table
if ($mode == 'run') {
$update = new updateTypes($mode, $reason_user_id);
$update->add_field_to_entity_table('external_css', 'css_media', 'tinytext');
} else {
echo '<p>Would have made sure the external_css table had the field css_media</p>';
}
// Add locks table
if ($mode == 'run') {
reason_include_once('classes/locks.php');
$e = new entity(id_of('type'));
$locks = new ReasonEntityLocks($e);
if ($locks->enable_locks()) {
echo '<p>entity_lock table now exists.</p>';
} else {
echo '<p>entity_lock table not created.</p>';
}
} else {
<li>Adds the event.address field (tinytext)</li>
<li>Adds the event.latitute field (double)</li>
<li>Adds the event.longitude field (double)</li>
<li>Create or prompts you to create the geocodes data directory</li>
</ul>
<form method="post">
<input type="submit" name="go" value="test" />
<input type="submit" name="go" value="run" />
</form>
<?php
if (!empty($_POST['go']) && ($_POST['go'] == 'run' || $_POST['go'] == 'test')) {
if ($_POST['go'] == 'run') {
echo '<p>Running updater...</p>' . "\n";
$mode = 'run';
} else {
echo '<p>Testing updates...</p>' . "\n";
$mode = 'test';
}
if ($mode) {
$update = new updateTypes($mode, $reason_user_id);
$update->upgrade_event_type($mode, $reason_user_id);
$update->create_geocode_data_directory($mode, $reason_user_id);
}
}
?>
<p><a href="index.php">Return to Index</a></p>
</body>
</html>
<li>Add the field "caption_url" to the media file type.</li>
<li>Add the field "audio_description_url" to the media file type.</li>
<?php
//<li>Create/update the address type</li>*/
?>
</ul>
<form method="post">
<input type="submit" name="go" value="test" />
<input type="submit" name="go" value="run" />
</form>
<?php
if (!empty($_POST['go']) && ($_POST['go'] == 'run' || $_POST['go'] == 'test')) {
if ($_POST['go'] == 'run') {
echo '<p>Running updater...</p>' . "\n";
$mode = 'run';
} else {
echo '<p>Testing updates...</p>' . "\n";
$mode = 'test';
}
if ($mode) {
$update = new updateTypes($mode, $reason_user_id);
$update->do_updates($mode, $reason_user_id);
}
}
?>
<p><a href="index.php">Return to Index</a></p>
</body>
</html>
