I've used bigint with a default of a sequence in the past to good results. make sure to add the option to not recreate the tables so we don't mess up your fields when we change scheme and when upgrading review for schema changes and make them manually On Monday, November 3, 2014, Joel White <joelewhite@gmail.com> wrote:
Is there another datatype that would be more suitable. I plan to have massive amounts of traffic. Would the time datatype be more suitable?
On Mon, Oct 20, 2014 at 12:26 PM, Joel White <joelewhite@gmail.com <javascript:_e(%7B%7D,'cvml','joelewhite@gmail.com');>> wrote:
Thank you Chris
On Fri, Oct 17, 2014 at 2:08 PM, Chris Tunbridge <blasterjr@gmail.com <javascript:_e(%7B%7D,'cvml','blasterjr@gmail.com');>> wrote:
Serial is identical to mysql's Auto Increment, so i'm going to say yes.
On Fri, Oct 17, 2014 at 9:36 AM, Joel White <joelewhite@gmail.com <javascript:_e(%7B%7D,'cvml','joelewhite@gmail.com');>> wrote:
Chris and William,
Can those added PKs have a data type of SERIAL?
On Wed, Oct 15, 2014 at 11:33 PM, William King < william.king@quentustech.com <javascript:_e(%7B%7D,'cvml','william.king@quentustech.com');>> wrote:
Yes, you can add columns to those tables with no issues. Try it and see.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518william.king@quentustech.com <javascript:_e(%7B%7D,'cvml','william.king@quentustech.com');>
On 10/8/14 9:44 AM, Joel White wrote:
Is it feasible to add Primary Keys to all FreeSWITCH tables or would this break some functionality?
I am asking because I am working on a multi-master replication setup
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');>http://www.freeswitchsolutions.com
Official FreeSWITCH Siteshttp://www.freeswitch.orghttp://confluence.freeswitch.orghttp://www.cluecon....
FreeSWITCH-powered IP PBX: The CudaTel Communication Serverhttp://www.cudatel.com
FreeSWITCH-users mailing listFreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-usershttp://www.frees...
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');> http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');> http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <javascript:_e(%7B%7D,'cvml','consulting@freeswitch.org');> http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <javascript:_e(%7B%7D,'cvml','FreeSWITCH-users@lists.freeswitch.org');> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org