Wednesday, March 23, 2005

Build a new table for database

I have created a new table in database which is called "terminate".
It contains two attributes , int(4) t_id and int(4) u_id.
t_id is auto increment and is primary key.
u_id is used instead of username, since u_is is more easy to handle and the size is in the fixed range which is better then using username.

The table is used to idenitfy the user if they withdraw the account before. If their u_id exists in table that means they withdraw the account. This table is mainly used in login page.
1st check if they are user first from "UserInfo" table.
If yes, 2nd check if they withdraw the account from "terminate" table.

0 Comments:

Post a Comment

<< Home