roles table design

HI, I'm developing a cms, I need some suggessions regarding database design. I'm creating role table in which role name will be unique, so my question is that should I create roleid(int, autoincreament, primary key )? Same question for users table. Note: I'll have user role mapping table. --

Need Help

Dear All, I am looking for help as I want to make a website like orkut. can u plz help me in designing the Data Table and Queries -- Thanks Regards, Tanveer Bhurani The Bend on the road is not the end of the Road..., Unless you forget to make the turn

Re: Need Help

what rate of pay are you offering? On Mon, Nov 24, 2008 at 5:13 AM, Tanveer Bhurani [EMAIL PROTECTED]wrote: Dear All, I am looking for help as I want to make a website like orkut. can u plz help me in designing the Data Table and Queries -- Thanks Regards, Tanveer Bhurani The Bend on

Update Problem when ORing w/ Long.MIN_VALUE

Hi everybody - I'm experiencing some really weird update behaviour (mysql 5.0) when or'ing results from subselects using Long.MIN_VALUE. But before I post a bug report I wanted to ask if I'm missing something. drop table if exists foo; drop table if exists bar; create table foo (fooid int,

RE: Displaying information from table graphically

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, November 23, 2008 6:12 AM To: Jujitsu Lizard Cc: mysql@lists.mysql.com Subject: Re: Displaying information from table graphically Does it support interaction in terms of allowing user to click on individual

RE: Special Characters

-Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: Sunday, November 23, 2008 4:59 PM To: MySQL List Subject: Special Characters Hello, we are in the process of setting up a database with members data and other info. We'll need to enter names with special characters,

Re: Special Characters

Thx's Jerry, appreciate the info, very helpful. ;) Mike(mickalo)Blezien === Thunder Rain Internet Publishing Providing Internet Solution that Work http://www.thunder-rain.com === - Original Message - From: Jerry Schwartz [EMAIL

TurnKey MySQL: new installable live CD optimized for ease of use

Hi guys, I am one of the developers for TurnKey Linux, an opensource project that aims to develop high-quality software appliances that are easy to use, easy to deploy, and free. Our motto is everything that can be easy, should be easy! We recently released TurnKey MySQL, an easy-to-use,

Re: Update Problem when ORing w/ Long.MIN_VALUE

Hi Daniel, I can see the problem without using update. However, I am a newbie at mysql, so can't say for certain if it's a bug: mysql drop table if exists foo; mysql create table foo (id int signed, val bigint signed); mysql insert into foo values (0x, 0x), (-1, -1);