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

Parent Directory | Revision Log | Patch

	revision 8492 by niro, Fri Feb 5 12:31:10 2016 UTC	revision 8493 by niro, Fri Feb 5 13:18:40 2016 UTC
#	Line 90  sql_create_table()	Line 90  sql_create_table()
90
91	for ((i=1; i<count; i++))	for ((i=1; i<count; i++))
92	do	do
93	line="${TABLE_DEFINITION[${i}]}"	line=( ${TABLE_DEFINITION[${i}]} )
94	column="${line%% *}"	column="${line[0]}"
95	opts="${line/${column} /}"	opts="${line[*]:1}"
96
97	case ${opts} in	case ${opts} in
98	*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;	*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
#	Line 115  sql_create_table()	Line 115  sql_create_table()
115
116	if [[ -n ${primary} ]]	if [[ -n ${primary} ]]
117	then	then
118		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
119		fi
120		if [[ -n ${autoincrement} ]]
121		then
122		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'"
123		fi
124		}
125
126		# TABLE_DEFINITION=(
127		# "table_name"
128		# "column1_name after_column column1_argvs"
129		# "column2_name after_column column2_argvs"
130		# "columnN_name after_column columnN_argvs"
131		# )
132		sql_add_column()
133		{
134		local table
135		local count
136		local i
137		local line
138		local opts
139		local column
140		local autoincrement
141		local primary
142
143		table="${TABLE_DEFINITION[0]}"
144		count="${#TABLE_DEFINITION[*]}"
145
146		for ((i=1; i<count; i++))
147		do
148		line=( ${TABLE_DEFINITION[${i}]} )
149		column="${line[0]}"
150		after="${line[1]}"
151		opts="${line[*]:2}"
152
153		case ${opts} in
154		*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
155		*"primary key"*) opts="${opts//primary key}"; primary="${column}" ;;
156		esac
157
158		case ${opts} in
159		*AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;;
160		*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
161		esac
162
163		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD ${column} ${opts}) AFTER ${after_column};" || die "add column '${table}'"
164		done
165
166		if [[ -n ${primary} ]]
167		then
168		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
169		fi
170		if [[ -n ${autoincrement} ]]
171		then
172		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${autoincrement} AUTO_INCREMENT;" || die "adding auto_increment to table '${table}'"
173		fi
174		}
175
176		# TABLE_DEFINITION=(
177		# "table_name"
178		# "column1_name column1_argvs"
179		# "column2_name column2_argvs"
180		# "columnN_name columnN_argvs"
181		# )
182		sql_modify_column()
183		{
184		local table
185		local count
186		local i
187		local line
188		local opts
189		local column
190		local autoincrement
191		local primary
192
193		table="${TABLE_DEFINITION[0]}"
194		count="${#TABLE_DEFINITION[*]}"
195
196		for ((i=1; i<count; i++))
197		do
198		line=( ${TABLE_DEFINITION[${i}]} )
199		column="${line[0]}"
200		opts="${line[*]:1}"
201
202		case ${opts} in
203		*"PRIMARY KEY"*) opts="${opts//PRIMARY KEY}"; primary="${column}" ;;
204		*"primary key"*) opts="${opts//primary key}"; primary="${column}" ;;
205		esac
206
207		case ${opts} in
208		*AUTO_INCREMENT*) opts="${opts//AUTO_INCREMENT}"; autoincrement="${column} ${opts}" ;;
209		*auto_increment*) opts="${opts//auto_increment}"; autoincrement="${column} ${opts}" ;;
210		esac
211
212		mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} MODIFY ${column} ${opts});" || die "modify table '${table}'"
213		done
214
215		if [[ -n ${primary} ]]
216		then
217	mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"	mysqldo "ALTER TABLE ${MCORE_SQL_DB}.${table} ADD PRIMARY KEY (${primary});" || die "adding primary key to table '${table}'"
218	fi	fi
219	if [[ -n ${autoincrement} ]]	if [[ -n ${autoincrement} ]]

---

Colored Diff Long Colored Diff Full Colored Diff Unidiff Context Diff Side by Side

Legend: Removed from v.8492   changed lines   Added in v.8493