[Sguil-cvs] sguil/server/sql_scripts update_sguildb_v11-v12.sql, 1.3, 1.4
Status: Beta
Brought to you by:
bamm
From: Bamm V. <ba...@us...> - 2007-06-04 17:41:20
|
Update of /cvsroot/sguil/sguil/server/sql_scripts In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv19349 Modified Files: update_sguildb_v11-v12.sql Log Message: Add index for the columns sid and cid to the table `history`. Index: update_sguildb_v11-v12.sql =================================================================== RCS file: /cvsroot/sguil/sguil/server/sql_scripts/update_sguildb_v11-v12.sql,v retrieving revision 1.3 retrieving revision 1.4 diff -C2 -d -r1.3 -r1.4 *** update_sguildb_v11-v12.sql 25 Mar 2007 15:34:33 -0000 1.3 --- update_sguildb_v11-v12.sql 4 Jun 2007 17:41:16 -0000 1.4 *************** *** 18,20 **** --- 18,25 ---- ); + ALTER TABLE history ADD INDEX ( + sid (sid), + cid (cid) + ); + UPDATE version SET version="0.12", installed = now(); |