Difference between revisions of "Talk:No user in rights window"

(added alternative)
 
Line 11: Line 11:
 
     ALTER intfield07 SET DEFAULT = null, \
 
     ALTER intfield07 SET DEFAULT = null, \
 
     ALTER intfield08 SET DEFAULT = null;
 
     ALTER intfield08 SET DEFAULT = null;
 +
 +
 +
-------
 +
 +
It's not a question of defaults, I'm afraid. The admin fills this table with incorrect values ('4', to be precise) when it inserts the contact corresponding to some user.
 +
 +
DerCisco -  23.03.2007

Revision as of 11:31, 23 March 2007

What about setting defaults for that instead of changing every occurence afterwards?

Without testing and some years past since I wrote mySQL, I'd recommend something like: 

 ALTER TABLE prg_contacts \
   ALTER intfield02 SET DEFAULT = null, \
   ALTER intfield03 SET DEFAULT = null, \
   ALTER intfield04 SET DEFAULT = null, \
   ALTER intfield05 SET DEFAULT = null, \
   ALTER intfield06 SET DEFAULT = null, \
   ALTER intfield07 SET DEFAULT = null, \
   ALTER intfield08 SET DEFAULT = null;


It's not a question of defaults, I'm afraid. The admin fills this table with incorrect values ('4', to be precise) when it inserts the contact corresponding to some user.

DerCisco - 23.03.2007

Retrieved from "https://oxpedia.org/wiki/index.php?title=Talk:No_user_in_rights_window&oldid=386"