Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Thu Mar 28, 2024 10:54 am
VoIP Billing solution


All times are UTC




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject:
PostPosted: Thu Mar 06, 2008 10:08 am 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
Change the SQL schema to make the field 'email' UNIQUE?


Top
 Profile  
 
 Post subject:
PostPosted: Thu Mar 06, 2008 10:23 am 
Offline

Joined: Sat Mar 01, 2008 4:09 am
Posts: 37
stavros wrote:
Change the SQL schema to make the field 'email' UNIQUE?


Change the code that it checks for the email first using a query ?

Actually yours is easier ;)


Top
 Profile  
 
 Post subject:
PostPosted: Thu Mar 06, 2008 2:44 pm 
Offline
Moderator
User avatar

Joined: Thu Jun 22, 2006 2:19 pm
Posts: 2890
Location: Devon, UK
On Postgres:
Code:
ALTER TABLE cc_card ADD CONSTRAINT uniqueemail UNIQUE (email);
The MySQL syntax looks similar.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 8 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group