[Mydm-cvs] MyDM/src/java/org/mydm/db/admin CreateDBStructure.java,1.8,1.9

[Vijay <vkd...@us...>]

Update of /cvsroot/mydm/MyDM/src/java/org/mydm/db/admin
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv29634/src/java/org/mydm/db/admin

Modified Files:
	CreateDBStructure.java 
Log Message:
Added mysearches table which will store the searches

Index: CreateDBStructure.java
===================================================================
RCS file: /cvsroot/mydm/MyDM/src/java/org/mydm/db/admin/CreateDBStructure.java,v
retrieving revision 1.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** CreateDBStructure.java	4 Mar 2004 21:47:50 -0000	1.8
--- CreateDBStructure.java	16 Mar 2004 13:27:05 -0000	1.9
***************
*** 103,106 ****
--- 103,117 ----
  		sqls.add("CREATE TABLE docs_fullmd (" +
			"doc_ref INTEGER," +
			"collection_ref INTEGER," +
			"md VARCHAR," +
			"ts TIMESTAMP" +
			")");
  		
+ 		// Table to hold the Saved Searches
+ 		sqls.add("DROP TABLE mysearches");
+ 		sqls.add("CREATE TABLE mysearches (" +
+ 			"id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1), " +
+ 			"name VARCHAR," +
+ 			"searchstring VARCHAR," +
+ 			"description VARCHAR," +
+ 			"datecreated TIMESTAMP," +
+ 			"ts TIMESTAMP" +
+ 			")");
+ 		
  		try {
  			stmt = con.createStatement();