This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
Log of /trunk/sql
Directory Listing
Revision
249 -
Directory Listing
Modified
Fri Dec 9 16:27:49 2005 UTC
(18 years, 6 months ago)
by
dpavlin
small fixes
Revision
240 -
Directory Listing
Modified
Thu Nov 17 17:22:31 2005 UTC
(18 years, 7 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, 7 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, 7 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 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, 8 months ago)
by
dpavlin
create archive_backup also
Revision
179 -
Directory Listing
Modified
Tue Oct 11 19:16:51 2005 UTC
(18 years, 8 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, 8 months ago)
by
dpavlin
few more migration sqls
Revision
174 -
Directory Listing
Modified
Tue Oct 11 16:59:16 2005 UTC
(18 years, 8 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, 8 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, 8 months ago)
by
dpavlin
removed workflow parts
Revision
139 -
Directory Listing
Modified
Thu Oct 6 15:01:32 2005 UTC
(18 years, 8 months ago)
by
dpavlin
reset sequence
Revision
137 -
Directory Listing
Modified
Thu Sep 29 08:46:13 2005 UTC
(18 years, 8 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, 9 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, 9 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, 9 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, 9 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, 9 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, 9 months ago)
by
dpavlin
added some useful SQL examples. They are lightly commented within each file.