Log of /trunk/sql

---

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, 7 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, 8 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.