<?php
  /**************************************************************************\
  * phpGroupWare - Setup                                                     *
  * http://www.phpgroupware.org                                              *
  * --------------------------------------------                             *
  *  This program is free software; you can redistribute it and/or modify it *
  *  under the terms of the GNU General Public License as published by the   *
  *  Free Software Foundation; either version 2 of the License, or (at your  *
  *  option) any later version.                                              *
  \**************************************************************************/

  /* $Id: tables_update.inc.php,v 1.3 2001/05/19 19:16:58 milosch Exp $ */

	$test[] = '0.9.4pre1';
	function notes_upgrade0_9_4pre1()
	{
		global $phpgw_info, $oProc;

			$oProc->CreateTable('notes', array(
				'fd' => array(
					'note_id' => array('type' => 'auto', 'nullable' => false),
					'note_owner' => array('type' => 'int', 'precision' => 4),
					'note_date' => array('type' => 'int', 'precision' => 4),
					'note_content' => array('type' => 'text')
				),
				'pk' => array('note_id'),
				'ix' => array(),
				'fk' => array(),
				'uc' => array()
			));

		$oProc->m_odb->query("insert into applications (app_name, app_title, app_enabled, app_order, app_tables, app_version) values ('notes', 'Notes', 1, 14, NULL, '".$phpgw_info["server"]["version"]."')");

		$phpgw_info['setup']['currentver']['notes'] = '0.9.4pre2';
	}
?>
