/[BackupPC]/trunk/sql/drop_unneeded_colums.sql

This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!

Contents of /trunk/sql/drop_unneeded_colums.sql

Parent Directory | Revision Log

Revision 87 - (show annotations)
Sun Aug 28 14:05:08 2005 UTC (18 years, 8 months ago) by dpavlin
File size: 182 byte(s)

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

1	-- this is file to convert your database to new format which is used
2	-- from r70 commit.
3
4	begin;
5	alter table shares drop column share ;
6	alter table files drop column dvdid ;
7	commit;

	ViewVC Help
Powered by ViewVC 1.1.26