[BackupPC] Log of /trunk/sql

Revision 371 - Directory Listing
Modified Mon May 7 08:48:47 2007 UTC (16 years, 11 months ago) by iklaric

- notices removed from sql
- burnArchiveCLI now tries to recreate missing tars using tarIncCreate

Revision 370 - Directory Listing
Modified Mon May 7 07:33:49 2007 UTC (16 years, 11 months ago) by iklaric

fixed problem with invalid trigger when deleting entries from backup_parts

Revision 367 - Directory Listing
Modified Thu Jan 25 09:27:20 2007 UTC (17 years, 3 months ago) by dpavlin

fix empty backups

Revision 366 - Directory Listing
Modified Thu Jan 25 09:25:23 2007 UTC (17 years, 3 months ago) by dpavlin

display archives and archvies without backup parts

Revision 365 - Directory Listing
Modified Thu Jan 25 09:24:02 2007 UTC (17 years, 3 months ago) by dpavlin

create view backups_on_dvds

Revision 364 - Directory Listing
Modified Tue Sep 26 14:14:14 2006 UTC (17 years, 7 months ago) by dpavlin

list all backups with dvd number (if burned)

Revision 358 - Directory Listing
Modified Thu Apr 27 10:01:56 2006 UTC (18 years ago) by dpavlin

added archive_burned correction (commented)

Revision 330 - Directory Listing
Modified Tue Jan 31 22:11:58 2006 UTC (18 years, 2 months ago) by dpavlin

 r9174@llin:  dpavlin | 2006-01-31 23:09:48 +0100
 make backup_parts_backup_id_part_nr unique

Revision 329 - Directory Listing
Modified Tue Jan 31 22:04:47 2006 UTC (18 years, 2 months ago) by dpavlin

 r9171@llin:  dpavlin | 2006-01-31 23:04:30 +0100
 removed all direct updates of parts which is now handled by custom referential triggers on backups and backup_parts (which
 also check part_nr)

Revision 324 - Directory Listing
Modified Tue Jan 31 16:22:21 2006 UTC (18 years, 2 months ago) by dpavlin

 r9162@llin:  dpavlin | 2006-01-31 17:21:33 +0100
 added trigger to ensure integrity of backup_parts

Revision 308 - Directory Listing
Modified Sun Jan 29 01:24:37 2006 UTC (18 years, 2 months ago) by dpavlin

check backup_parts against data in backups

Revision 301 - Directory Listing
Modified Thu Jan 26 23:24:11 2006 UTC (18 years, 3 months ago) by dpavlin

if BackupPC_burnArchiveCLI complains about consistency error in backup_parts,
this query will report which backups are problem

Revision 300 - Directory Listing
Modified Thu Jan 26 23:10:05 2006 UTC (18 years, 3 months ago) by dpavlin

generate increment filenames for DVD

Revision 299 - Directory Listing
Modified Thu Jan 26 17:31:29 2006 UTC (18 years, 3 months ago) by dpavlin

returns all increments which are stored on single DVD

Revision 290 - Directory Listing
Modified Wed Jan 25 21:31:20 2006 UTC (18 years, 3 months ago) by dpavlin

find backups without corresponding rows in backup_parts (database consistency check)

Revision 277 - Directory Listing
Modified Tue Dec 13 22:59:54 2005 UTC (18 years, 4 months ago) by dpavlin

cleanup files and add foreign key

Revision 273 - Directory Listing
Modified Tue Dec 13 19:41:34 2005 UTC (18 years, 4 months ago) by dpavlin

fix pending media created by test cases

Revision 272 - Directory Listing
Modified Tue Dec 13 19:34:09 2005 UTC (18 years, 4 months ago) by dpavlin

example how to manipulate with complex data

Revision 249 - Directory Listing
Modified Fri Dec 9 16:27:49 2005 UTC (18 years, 4 months ago) by dpavlin

small fixes

Revision 240 - Directory Listing
Modified Thu Nov 17 17:22:31 2005 UTC (18 years, 5 months ago) by dpavlin

added SQL which delete all backups afeter daylight saving time change.
added cludge which tolerate +/- 1 hour difference in mtime from (probably
windows) hosts which drift when DST is in action, thus producing duplicate
entries

Revision 238 - Directory Listing
Modified Thu Nov 17 15:00:26 2005 UTC (18 years, 5 months ago) by dpavlin

show ISO dates and not timestamps

Revision 235 - Directory Listing
Modified Thu Nov 10 15:07:10 2005 UTC (18 years, 5 months ago) by dpavlin

 r8747@llin:  dpavlin | 2005-11-10 16:06:57 +0100
 added backup_parts table to track parts of each backup, rewrote
 BackupPC_tarIncCreate to use backup_parts

Revision 220 - Directory Listing
Modified Sat Oct 22 15:40:35 2005 UTC (18 years, 6 months ago) by dpavlin

 r8652@llin:  dpavlin | 2005-10-20 23:55:31 +0200
 forgotten migration script

Revision 219 - Directory Listing
Modified Sat Oct 22 15:40:33 2005 UTC (18 years, 6 months ago) by dpavlin

 r8651@llin:  dpavlin | 2005-10-20 23:54:45 +0200
 dump all files in pool from database

Revision 199 - Directory Listing
Modified Thu Oct 13 21:19:06 2005 UTC (18 years, 6 months ago) by dpavlin

 r8512@llin:  dpavlin | 2005-10-13 23:06:07 +0200
 support for multi-parts increments.

Revision 196 - Directory Listing
Modified Thu Oct 13 18:32:59 2005 UTC (18 years, 6 months ago) by dpavlin

 r8506@llin:  dpavlin | 2005-10-13 19:26:50 +0200
 added parts to backups, make split calculate suffix length, added ability
 to join parts of increments if media size changes

Revision 195 - Directory Listing
Modified Thu Oct 13 17:12:00 2005 UTC (18 years, 6 months ago) by dpavlin

 r8503@llin:  dpavlin | 2005-10-13 19:11:50 +0200
 change iso_size to bigint

Revision 184 - Directory Listing
Modified Wed Oct 12 11:47:39 2005 UTC (18 years, 6 months ago) by dpavlin

clean dvd_nr and delete archive

Revision 180 - Directory Listing
Modified Tue Oct 11 19:31:51 2005 UTC (18 years, 6 months ago) by dpavlin

create archive_backup also

Revision 179 - Directory Listing
Modified Tue Oct 11 19:16:51 2005 UTC (18 years, 6 months ago) by dpavlin

migration sql to create archive database

Revision 178 - Directory Listing
Modified Tue Oct 11 19:11:32 2005 UTC (18 years, 6 months ago) by dpavlin

few more migration sqls

Revision 174 - Directory Listing
Modified Tue Oct 11 16:59:16 2005 UTC (18 years, 6 months ago) by dpavlin

 r8467@llin:  dpavlin | 2005-10-11 18:59:10 +0200
 first cut at BackupPC_burnArchiveCLI, used to burn archive media from command
 line.

Revision 173 - Directory Listing
Modified Tue Oct 11 16:00:03 2005 UTC (18 years, 6 months ago) by dpavlin

 r8464@llin:  dpavlin | 2005-10-11 17:18:18 +0200
 renamed migration sql files

Revision 151 - Directory Listing
Modified Mon Oct 10 10:29:59 2005 UTC (18 years, 6 months ago) by dpavlin

removed workflow parts

Revision 139 - Directory Listing
Modified Thu Oct 6 15:01:32 2005 UTC (18 years, 6 months ago) by dpavlin

reset sequence

Revision 137 - Directory Listing
Modified Thu Sep 29 08:46:13 2005 UTC (18 years, 6 months ago) by iklaric

 r145@klaxLaptop:  klax | 2005-09-29 10:46:02 +0200
 fixed getBackupsNotBurned();
 fixed insertion into archive_backup, workflows, workflow_step
 added needed sequences (workflow_schema_update.sql);

Revision 121 - Directory Listing
Modified Thu Sep 15 13:54:29 2005 UTC (18 years, 7 months ago) by iklaric

 r124@klaxLaptop:  klax | 2005-09-15 15:46:19 +0200
 - first step of workflow is done.

Revision 120 - Directory Listing
Modified Thu Sep 15 13:54:28 2005 UTC (18 years, 7 months ago) by iklaric

 r123@klaxLaptop:  klax | 2005-09-15 14:10:34 +0200
 - added workflow database schema

Revision 103 - Directory Listing
Modified Tue Aug 30 22:43:57 2005 UTC (18 years, 7 months ago) by dpavlin

added very complex backup query (which is slow, probably a good candidate
for materilaized view)

Revision 87 - Directory Listing
Modified Sun Aug 28 14:05:08 2005 UTC (18 years, 8 months ago) by dpavlin

bug fixes: date limit now works again, correct number of displayed results,
added SQL script to remove unneeded columns, dates only selection now
works with HyperEstraier (but, it's MUCH SLOWER than from database),
added ordinal number of result

Revision 76 - Directory Listing
Modified Fri Aug 26 21:18:37 2005 UTC (18 years, 8 months ago) by dpavlin

alternative implementation of fix with temporary table. must be commit-ed manually.

Revision 75 - Directory Listing
Added Fri Aug 26 20:44:24 2005 UTC (18 years, 8 months ago) by dpavlin

added some useful SQL examples. They are lightly commented within each file.

	ViewVC Help
Powered by ViewVC 1.1.26