From d150f5b476d8e32f8df4015d8c3c9411ec798b57 Mon Sep 17 00:00:00 2001
From: paca70 <paca70>
Date: Thu, 28 Aug 2003 18:24:00 +0000
Subject: [PATCH] Quick (untested) fix to make table and index creation work.

---
 backup/db/postgres7.sql | 13 +++++--------
 1 file changed, 5 insertions(+), 8 deletions(-)

diff --git a/backup/db/postgres7.sql b/backup/db/postgres7.sql
index b104f6846d..1c1dd55b36 100644
--- a/backup/db/postgres7.sql
+++ b/backup/db/postgres7.sql
@@ -10,8 +10,7 @@ CREATE TABLE prefix_backup_files (
   file_type varchar(10) NOT NULL default '',
   path varchar(255) NOT NULL default '',
   old_id integer default NULL,
-  new_id integer default NULL,
-  PRIMARY KEY (backup_code, file_type, path)
+  new_id integer default NULL
 );
 
 # --------------------------------------------------------
@@ -23,13 +22,11 @@ CREATE INDEX prefix_backup_codetypepath_idx ON prefix_backup_files (backup_code,
 #
 
 CREATE TABLE prefix_backup_ids (
-  prefix_backup_codenameid_idx PRIMARY KEY,
-  backup_code int(12) unsigned NOT NULL default '0',
+  backup_code int8 NOT NULL default '0',
   table_name varchar(30) NOT NULL default '',
-  old_id int(10) unsigned NOT NULL default '0',
-  new_id int(10) unsigned default NULL,
-  info mediumtext,
-  PRIMARY KEY (backup_code, table_name, old_id)
+  old_id int8 NOT NULL default '0',
+  new_id int8 default NULL,
+  info text
 );
 
 CREATE INDEX prefix_backup_codenameid_idx ON prefix_backup_ids (backup_code,table_name,old_id);
-- 
2.39.5