Skip to content

Instantly share code, notes, and snippets.

@steegi
Created June 15, 2012 01:07
Show Gist options
  • Save steegi/2934001 to your computer and use it in GitHub Desktop.
Save steegi/2934001 to your computer and use it in GitHub Desktop.
Creating a SugarCRM DB2 developer database that works for all circumstances, but isn't suited for production
#!/bin/sh
# NOTE this creates a default 32k table space which is the maximum. Only a few tables in Sugar need 8k, others need only 4k
# However if you are using Studio the table needs enough extra space to add columns
# Also note that the specified collation is case insensitive US. By default DB2 is case sensitive.
db2 "CREATE DATABASE sugarult USING CODESET UTF-8 TERRITORY US COLLATE USING UCA500R1_LEN_S2 PAGESIZE 32 K"
# Sugar 6.4 and 6.5 need the Full Text Search engine up and running and operational.
# Currently only KBDocuments uses full text search by default in Sugar but other FTS indexes can be created.
db2ts "enable database for text connect to sugarult"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment