Hi! Just a note: removing the NOT NULL constraint is fine if the module is prepared to receive NULL values on queries. Otherwise the contraints should be there too.
Further I wonder if there is a policy in openser how missing objects will be stored - e.g. the Record-Route or event_id. If the message does not contain record-route or event_id - should the corresponding column be set to NULL or to an empty string "" ? regards klaus On Tue, February 13, 2007 16:48, Anca Vamanu said: > User: anca_vamanu > Date: 2007/02/13 07:48:09 PST > > OpenSER CVS - Commit Details > > Modified files: > modules/presence README > modules/presence/doc presence.sql > Commit Log: > - changed the sql script for presence tables according to the > suggestions > of Alex for adapting the tables to Oracle database and dbtext > closes 1652302 > > Revision Changes Path > 1.16 +10 -11 sip-server/modules/presence/README > [ > http://openser.cvs.sourceforge.net/openser/sip-server/modules/presence/README?r1=1.15&r2=1.16 > ] > 1.4 +10 -11 sip-server/modules/presence/doc/presence.sql > [ > http://openser.cvs.sourceforge.net/openser/sip-server/modules/presence/doc/presence.sql?r1=1.3&r2=1.4 > ] > > _______________________________________________ > Devel mailing list > [email protected] > http://openser.org/cgi-bin/mailman/listinfo/devel > _______________________________________________ Devel mailing list [email protected] http://openser.org/cgi-bin/mailman/listinfo/devel
