<?php
require_once 'users/init.php';
require_once $abs_us_root.$us_url_root.'users/includes/header.php';
require_once $abs_us_root.$us_url_root.'users/includes/navigation.php';
if(isset($user) && $user->isLoggedIn()){
}

?>

<div id="page-wrapper">
<div class="container">
<div class="row">
	<div class="col-xs-12">
		Patching Database
		<?php
		echo "Creating timestamp in users table<br>";
		$db->query("ALTER TABLE users ADD COLUMN last_loc datetime DEFAULT NULL");
		echo "Creating sample location_logs<br>";
		$db->query("CREATE TABLE `location_logs` (
			`id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
			`user` int(11) NOT NULL,
			`location` varchar(255) NOT NULL,
 			`ci_time`  timestamp NOT NULL
			) ENGINE=InnoDB DEFAULT CHARSET=latin1 ");
		echo "Done. You can delete this file";
		?>
	</div><!-- /.col -->
</div><!-- /.row -->

</div> <!-- /container -->

</div> <!-- /#page-wrapper -->

<!-- footers -->
<?php require_once $abs_us_root.$us_url_root.'users/includes/page_footer.php'; // the final html footer copyright row + the external js calls ?>

<!-- Place any per-page javascript here -->


<?php require_once $abs_us_root.$us_url_root.'users/includes/html_footer.php'; // currently just the closing /body and /html ?>