[Wplug-web] db schema draft

James O'Kane jo2y at midnightlinux.com
Sat Mar 24 01:26:32 EST 2001


>From looking over the current db schema, here is what I propose we
consider. I think we should brainstorm what other things we want to offer
in the long run, possibly starting with rob's mail from March 7th.


users table:
	user_id,
	user_name,
	fname,
	lname,
	email,
	is_admin,
	confirm_hash,


session table:
	session_id,
	session_hash,
	ip_address,
	user_id,
	expire_time,


news table:
	news_id,
	user_id,
	post_time,
	expire_time,
	text


announcement table:    (Couldn't this just be a special case of news?)
	announce_id,
	user_id,
	text





More information about the Wplug-web mailing list