[Perfparse-cvs] _perfparse/db_tools convert.h, 1.2, 1.3 convert.c, 1.8, 1.9

[Florian G. <re...@us...>]

Update of /cvsroot/perfparse/_perfparse/db_tools
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv861/db_tools

Modified Files:
	convert.h convert.c 
Log Message:
Made DropForeignKey working


Index: convert.c
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/db_tools/convert.c,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** convert.c	7 Dec 2006 00:14:03 -0000	1.8
--- convert.c	7 Dec 2006 23:47:13 -0000	1.9
***************
*** 40,174 ****
  #include <regex.h>
  
! /* Domain to use: */
  #define SERVICE "service"
  
! void addIdFields();
! void checkTables();
! void addTableHostGroup(void);
! void addTableDeletePolicy(void);
! void addTableRegistry(void);
[...1218 lines suppressed...]
! void
! addTableRawSummaryData ()
! {
  
! 	g_string_assign (s_SQL,
! 			 "CREATE TABLE IF NOT EXISTS perfdata_raw_summary_data ("
! 			 "service_id INT NOT NULL ," "epoch INT NOT NULL ,"
! 			 "epoch_start INT NOT NULL ,"
! 			 "last_ctime INT NOT NULL ,"
! 			 "last_nagios_status INT default NULL,"
! 			 "count INT NOT NULL ," "sum_uptime INT NOT NULL ,"
! 			 "sum_warntime INT NOT NULL ,"
! 			 "sum_criticaltime INT NOT NULL ,"
! 			 "sum_undeftime INT NOT NULL ,"
! 			 "PRIMARY KEY  (service_id,epoch,epoch_start),"
! 			 "FOREIGN KEY (service_id, epoch) REFERENCES perfdata_raw_summary (service_id, epoch)"
! 			 ") TYPE=InnoDB");
  
! 	query_no_return (s_SQL->str);
  }

Index: convert.h
===================================================================
RCS file: /cvsroot/perfparse/_perfparse/db_tools/convert.h,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** convert.h	30 Oct 2006 21:35:06 -0000	1.2
--- convert.h	7 Dec 2006 23:47:13 -0000	1.3
***************
*** 31,35 ****
  void autoConvert();
  void install_database(void);
! void DropForeignKey(char *TableName, char *ForeignTableName);
  
  #endif
--- 31,35 ----
  void autoConvert();
  void install_database(void);
! int DropForeignKey(char *TableName, char *ForeignTableName);
  
  #endif