Index: /branches/amp_3_7/src/webui/webui/htdocs/new/src/cm/upgrade/3_7_1/update_db_schema.py
===================================================================
--- /branches/amp_3_7/src/webui/webui/htdocs/new/src/cm/upgrade/3_7_1/update_db_schema.py	(revision 2445)
+++ /branches/amp_3_7/src/webui/webui/htdocs/new/src/cm/upgrade/3_7_1/update_db_schema.py	(working copy)
@@ -49,7 +49,7 @@
 def alter_table_log_host():
     db = DB.get_connected_db()
     update_log_host_query = '''ALTER TABLE log_host
-                                DROP CONSTRAINT IF EXISTS log_host_pkey;
+                                DROP CONSTRAINT IF EXISTS log_host_pkey CASCADE;
                                 ALTER TABLE log_host
                                 ADD COLUMN IF NOT EXISTS id SERIAL PRIMARY KEY;
                                 ALTER TABLE log_host
@@ -64,6 +64,42 @@
         db.close()
 
 
+def alter_table_proxy_cm():
+    db = DB.get_connected_db()
+    update_proxy_cm_query = '''ALTER TABLE proxy_cm
+                               DROP CONSTRAINT IF EXISTS proxy_cm_pkey CASCADE;
+                               ALTER TABLE proxy_cm
+                               ADD COLUMN IF NOT EXISTS id SERIAL PRIMARY KEY;
+                               ALTER TABLE proxy_cm
+                               ADD CONSTRAINT unique_name UNIQUE (name);'''
+
+    try:
+        db.execute_sql(update_proxy_cm_query)
+    except Exception as e:
+        # Unable to import oper_log. Using print for now
+        print('Exception while executing update queries:{}'.format(e.message))
+    finally:
+        db.close()
+
+
+def alter_table_schedule_backup():
+    db = DB.get_connected_db()
+    update_schedule_backup_query = '''ALTER TABLE schedule_backup_all
+                               DROP CONSTRAINT IF EXISTS schedule_backup_all_pkey;
+                               ALTER TABLE schedule_backup_all
+                               ADD COLUMN IF NOT EXISTS id SERIAL PRIMARY KEY;'''
+
+    try:
+        db.execute_sql(update_schedule_backup_query)
+    except Exception as e:
+        # Unable to import oper_log. Using print for now
+        print('Exception while executing update queries:{}'.format(e.message))
+    finally:
+        db.close()
+
+
 if __name__ == '__main__':
     alter_table_file_type_list()
-    alter_table_log_host()
\ No newline at end of file
+    alter_table_log_host()
+    alter_table_proxy_cm()
+    alter_table_schedule_backup()
\ No newline at end of file