[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: edara
- To: core at arabeyes dot org
- Subject: Re: edara
- From: Isam Bayazidi <bayazidi at accessme dot com>
- Date: Wed, 9 Jan 2002 19:49:00 +0200
Salam
I had a look at the webcalender sql file here :
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/webcalendar/webcalendar/tables-mysql.sql
I would suggest this design, having the line ommited preseded by '<<<' and
line added by '>>>'
<<<CREATE TABLE edara_admin
<<<(
<<< admin_id smallint NOT NULL unsigned auto_increment,
<<< admin_name tinytext NOT NULL,
<<< admin_email tinytext NOT NULL,
<<< admin_passwd tinytext NOT_NULL,
<<< admin_priv tinyint NOT_NULL default '0',
<<< admin_options tinytext NULL,
<<< admin_login timestamp NULL,
<<< PRIMARY KEY (admin_id)
<<<);
# task_approved - valids (N, Y if self-entry)
# task_create_date - in the format YYYYMMDD
# task_due_date - in the format YYYYMMDD
# task_status - valids (OPEN, ANALYZED, REJECTED, CLOSED)
# task_email - notes a list of email addresses to mail info to (if any)
CREATE TABLE edara_task
(
task_id smallint NOT NULL unsigned auto_increment,
task_from_id smallint NOT NULL unsigned,
task_to_id smallint NOT NULL unsigned,
task_approved char (1) NOT NULL,
task_subject tinytext NOT_NULL,
task_create_date int NOT_NULL,
task_due_date int,
task_status tinytext NOT_NULL,
task_desc text,
task_email text,
PRIMARY KEY (task_id)
);
# user_apporved - valids (N, Y)
# user_create_date - in the format YYYYMMDD
# user_bday - birthdate in the format YYYYMMDD
# user_from - person from orignally, format "city, country"
# user_at - person living currenlty, format "city, country"
>>> # user_type - set's the user type ( 0- normal, 1- admin, 2-owner)
CREATE TABLE edara_user
(
user_id smallint NOT NULL unsigned auto_increment,
user_approved char (1) NOT NULL default 'N',
user_create_date int NOT_NULL,
user_name tinytext NOT NULL,
user_email tinytext NOT NULL,
user_bday tinytext NOT_NULL,
user_from tinytext NOT_NULL,
user_at tinytext NOT_NULL,
user_skill tinytext NOT_NULL,
user_desc text NOT_NULL,
>>> user_type smallint NOT_NULL,
PRIMARY KEY (user_id)
);
# cal_approved - valids (N, Y if self-entry)
# cal_create_date - in the format YYYYMMDD
# cal_day_alph - valid (MON, TUE, WED, THU, FRI, SAT, SUN)
# cal_private - valid (N, Y) w/ Y others see blocked time no what's in it
<<<# cal_duration - is in minutes
>>>#cal_duration - duration in the format ( HHMM)
# cal_repeated - valid (NO, DAILY, WEEKLY, BI-WEEKLY, MONTHLY)
>>> cal_end - date of ending repeatition ( YYYYMMDD )
>>> #cal_group - valid ( 0- core group, 1- Translators, 2- Projects, 3- All)
>>> #cal_task_id - if cal is task related, hod id, not make it 0
CREATE TABLE edara_calendar
(
cal_id smallint NOT NULL unsigned auto_increment,
cal_user_id smallint NOT NULL unsigned,
cal_approved char (1) NOT NULL,
cal_create_date int NOT_NULL,
cal_year int (4) NOT_NULL unsigned,
cal_month int (2) NOT_NULL unsigned,
cal_day_num int (2) NOT_NULL unsigned,
cal_day_alph char (3),
cal_subject tinytext, NOT_NULL,
cal_desc text,
cal_private char (1) NOT_NULL default 'N',
<<< cal_duration smallint,
>>> cal_duration int,
cal_repeated tinytext NOT_NULL default 'NO',
>>> cal_end int,
>>> cal_group smallint NOT_NULL default 3,
>>> cal_task_id smallint default 0,
PRIMARY KEY (user_id)
);
--
Yours,
Isam Bayazidi
Amman - Jordan
====================================================
Think Linux + Think Arabic = Think www.arabeyes.org
====================================================