Location: PHPKode > projects > O - OpenSource GroupWare > osgw/calendar/config/db_install.php
<?php
/**************************************************************************
   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.

   @Authors:	Ryan Thompson(hide@address.com)
***************************************************************************/

$tables['o_calendar'] = array(
	'event_id'=> array("type"=>'INT', 'size'=>'15','null'=>'NO','key'=>'PRI','ex'=>'INC','default'=>''),
	'user_id'=> array("type"=>'INT', 'size'=>'6','null'=>'NO','key'=>'IND','ex'=>'','default'=>''),
	'date'=> array("type"=>'INT', 'size'=>'11','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'subject'=> array("type"=>'VARCHAR', 'size'=>'150','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'description'=> array("type"=>'TEXT', 'size'=>'','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'location'=> array("type"=>'VARCHAR', 'size'=>'255','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'evt_start'=> array("type"=>'INT', 'size'=>'11','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'evt_end'=> array("type"=>'INT', 'size'=>'11','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'recurring'=> array("type"=>'BOOL', 'size'=>'','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'notify'=> array("type"=>'BOOL', 'size'=>'','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'who'=> array("type"=>'TEXT', 'size'=>'','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'public'=> array("type"=>'BOOL', 'size'=>'','null'=>'YES','key'=>'','ex'=>'','default'=>''));

$tables['o_recurrence'] = array(
	'event_id'=> array("type"=>'INT', 'size'=>'15','null'=>'NO','key'=>'IND','ex'=>'','default'=>''),
	'type'=> array("type"=>'INT', 'size'=>'1','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'frequency'=> array("type"=>'INT', 'size'=>'11','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'times'=> array("type"=>'INT', 'size'=>'6','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'rstart'=> array("type"=>'INT', 'size'=>'11','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'rend'=> array("type"=>'INT', 'size'=>'11','null'=>'YES','key'=>'','ex'=>'','default'=>''),
	'data'=> array("type"=>'VARCHAR', 'size'=>'255','null'=>'YES','key'=>'','ex'=>'','default'=>''));

array_push($record['o_preferences'],
	array("service"=>"cl","user_id"=>"1","preference"=>"day_starts","value"=>"06:30"),
	array("service"=>"cl","user_id"=>"1","preference"=>"day_ends","value"=>"17:00"),
	array("service"=>"cl","user_id"=>"1","preference"=>"view","value"=>"month"),
	array("service"=>"cl","user_id"=>"1","preference"=>"show_birthdays","value"=>"TRUE"),
	array("service"=>"cl","user_id"=>"1","preference"=>"week_starts","value"=>"0"),
	array("service"=>"cl","user_id"=>"1","preference"=>"show_holidays_for","value"=>"23"),
	array("service"=>"cl","user_id"=>"1","preference"=>"mini_months","value"=>"TRUE"),
	array("service"=>"cl","user_id"=>"1","preference"=>"increments","value"=>"30"),
	array("service"=>"cl","user_id"=>"1","preference"=>"hours","value"=>"24"));



		
Return current item: O - OpenSource GroupWare