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 |
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}" ;; |
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 |