Magellan Linux

  • Back to homepage
    • /[alx-svn]/alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh

    Diff of /alx-src/branches/alx-web-070/scripts/sql-schema/mcore-sql-schema.sh

    Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

    revision 8508 by niro, Fri Feb 5 15:16:07 2016 UTC revision 8509 by niro, Mon Feb 8 08:52:47 2016 UTC
    # Line 125  sql_create_table() Line 125  sql_create_table()
    125    
    126  # TABLE_DEFINITION=(  # TABLE_DEFINITION=(
    127  # "table_name"  # "table_name"
    128  # "column1_name after_column column1_argvs"  # "column1_name column1_argvs"
    129  # "column2_name after_column column2_argvs"  # "column2_name column2_argvs"
    130  # "columnN_name after_column columnN_argvs"  # "columnN_name columnN_argvs"
    131    #
    132    # eg.    "description varchar(255) DEFAULT NULL AFTER value"
    133  # )  # )
    134    #
    135  sql_add_column()  sql_add_column()
    136  {  {
    137   local table   local table
    # Line 150  sql_add_column() Line 153  sql_add_column()
    153   do   do
    154   line=( ${TABLE_DEFINITION[${i}]} )   line=( ${TABLE_DEFINITION[${i}]} )
    155   column="${line[0]}"   column="${line[0]}"
    156   after="${line[1]}"   opts="${line[*]:1}"
      opts="${line[*]:2}"  
    157    
    158   case ${opts} in   case ${opts} in
    159   *"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;   *"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
    # Line 163  sql_add_column() Line 165  sql_add_column()
    165   *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;   *auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
    166   esac   esac
    167    
    168   mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts} AFTER ${after_column};" || die "add column '${table}'"   mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts};" || die "add column '${table}'"
    169   done   done
    170    
    171   # delete an existing auto_increment first   # delete an existing auto_increment first
    Legend:
    Removed from v.8508  
    changed lines
      Added in v.8509