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
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, 10 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, 10 months ago)
by
dpavlin
added some useful SQL examples. They are lightly commented within each file.