Friday 25 July 2008

Database

A database is a structured collection of records or data. A computer database relies upon software to organize the storage of data. The software models the database structure in what are known as database model. The model in most common use today is the relation model. Other models such as the hierarchical model and the network model use a more explicit representation of relationships (see below for explanation of the various database models).

Database management systems (DBMS) are the software used to organize and maintain the database. These are categorized according to the database model that they support. The model tends to determine the query languages that are available to access the database. A great deal of the internal engineering of a DBMS, however, is independent of the data model, and is concerned with managing factors such as performance, concurrency, integrity, and recovery from hardware failure. In these areas there are large differences between products.

Thursday 3 July 2008

Desktop.INI

DESKTOP.INI is a standard text file that can be added to any Windows folder to customize certain aspects of the folder's behaviour.
Occasionally DESKTOP.INI is used by other programs for their own settings.

[.ShellClassInfo]
CLSID=CLSID value for creating system and special folders
CLSID2=CLSID value
UICLSID=CLSID value
ConfirmFileOp=0 no special warning when deleting, moving or renaming a read-only or system folder (before XP)
NoSharing=1 prevents the folder from being shared (before XP)
Sharing=1 the folder is shared (XP)
IconFile=path specifies a custom icon for the folder (ico, bmp, exe, dll, icl), example: c:\test.ico
IconIndex=number specifies the index for a custom icon (0=first icon), if negative it is a resource ID
InfoTip=text informational text string or string ID in a resource module, example: @shell32.dll,-12689
HTMLInfoTipFile=file://Comment.htt HyperText file containing InfoTip string (before XP)
URL=http://www.test.com for opening the folder as a web page
Logo=file://C:\WINDOWS\clouds.bmp small logo when you open the folder as a web page
WideLogo=file://C:\WINDOWS\clouds.bmp large logo
LocalizedResourceName=@shell32.dll,-21765 specifies a resource module and the string ID to use as the name of the folder
BuyURL=SamplePictures link which opens when you click Buy Pictures in 'Sample Pictures' folder:
http://windowsmedia.com/redir/xpsample.asp
MusicBuyUrl=url link which opens when you click Buy Music in 'Shared Music' folder
RunWizard=1 used when Windows creates a Briefcase folder
DefaultToFS=0 locks folder (?) used in some History folders
DefaultDropEffect=number default action when you 'Drag and Drop' files in the folder
1 - Copy
2 - Move
4 - Create a shortcut
FolderType=Documents DEFAULT Folder Type if Show Common Tasks in Folders is selected
MyDocuments This works only if the Folder Type is not already placed in the registry
Pictures Place a Desktop.ini file with the FolderType entry in a folder
MyPictures In Explorer, choose Tools, Folder Options and click the View tab,
PhotoAlbum click the button labeled Reset All Folders
Music
MyMusic
MusicArtist
MusicAlbum
Videos
MyVideos
VideoAlbum
UseLegacyHTT
CommonDocuments


[ExtShellFolderViews]
Default={5984FFE0-28D4-11CF-AE66-08002B2E1262} default view
{BE098140-A513-11D0-A3A4-00C04FD706EC}={BE098140-A513-11D0-A3A4-00C04FD706EC} folder settings
{8BEBB290-52D0-11d0-B7F4-00C04FD706EC}={8BEBB290-52D0-11d0-B7F4-00C04FD706EC} thumbnail view
{5984FFE0-28D4-11CF-AE66-08002B2E1262}={5984FFE0-28D4-11CF-AE66-08002B2E1262} web view


[{5984FFE0-28D4-11CF-AE66-08002B2E1262}]
PersistMoniker=file://template.htt HyperText Template
WebViewTemplate.NT5=ImgView.htt
PersistMonikerPreview=\web\imgview.htt


[{BE098140-A513-11D0-A3A4-00C04FD706EC}]
Attributes=1
IconArea_Image=C:\WINDOWS\clouds.bmp background picture
IconArea_Text=0x00000000 text color
IconArea_TextBackground=0x00000000 background text color


[{8BEBB290-52D0-11d0-B7F4-00C04FD706EC}]
MenuName=T&humbnails
ToolTipText=T&humbnails
HelpText=Displays items using thumbnail view status bar message
Attributes=0x60000000


[Channel]
CDFURL=http://www.iechannelguide.com/guide.cdf?loc=en_us website
ScreenSaverURL=file://test.htm URL of HTML page to display as screen saver
Logo=file://C:\WINDOWS\web\chang_sl.gif small logo
WideLogo=file://C:\WINDOWS\web\chang_wl.gif large logo
Icon=file://C:\WINDOWS\web\chang.ico


[LocalizedFileNames]
Windows-catalogus.lnk=@%SystemRoot%\system32\shell32.dll,-22075 maps filenames to string values


[Encryption]
Disable=1 disables EFS encryption for the specified folder


[DeleteOnCopy] if you copy the desktop.ini to another location this section will not appear in the copied desktop.ini
Owner=%username% if 'Owner' has a different name than the user's, the folder is labeled with a different user's logon name
Personalized=5
PersonalizedName=My Documents means that without the desktop.ini file, the 'My Documents' folder would be called Documents

--------------------------------------------------------------------------------------------------------------------------------------------

CLSID values: (+ works, - does not work, 0 not usable, ? not tested)

Name Value XP ME 95
--------------------------------------------------------------------------------------------------------------------------------------------
Inbox {00020D76-0000-0000-C000-000000000046} - - +
Cabinet File {0CD7A5C0-9F37-11CE-AE65-08002B2E1262} - +0 +0
Taskbar and Start Menu {0DF44EAA-FF21-4412-828E-260A8728E7F1} - + -
Favorites {1A9BA3A0-143A-11CF-8350-444553540000} - +0 -
Assembly {1D2680C9-0E2A-469d-B787-065558BC7D43} + - -
Computer Search Results Folder {1f4de370-d627-11d1-ba4f-00a0c91eedba} +0 +0 -
My Network Places {208D2C60-3AEA-1069-A2D7-08002B30309D} + + -
My Computer {20D04FE0-3AEA-1069-A2D8-08002B30309D} + - -
Control Panel {21EC2020-3AEA-1069-A2DD-08002B30309D} + + +
Printers {2227A280-3AEA-1069-A2DE-08002B30309D} + + +
Internet {2559a1f4-21d7-11d4-bdaf-00c04f60b9f0} + - -
E-Mail {2559a1f5-21d7-11d4-bdaf-00c04f60b9f0} + - -
The Internet {3DC7A020-0ACD-11CF-A9BB-00AA004AE837} + + +
My Documents {450D8FBA-AD25-11D0-98A8-0800361B1103} +0 +0 -
Start Menu Folder {48e7caab-b918-4e58-a94d-505519c795dc} + - -
FTP Folder {63da6ec0-2e98-11cf-8d82-444553540000} +0 - -
Recycle Bin {645FF040-5081-101B-9F08-00AA002F954E} + + +
Extensions Manager Folder {692F0339-CBAA-47e6-B5B5-3B84DB604E87} + - -
Folder Options {6DFD7C5C-2451-11d3-A299-00C04F8EF6AF} - + -
Network Connections {7007ACC7-3202-11D1-AAD2-00805FC1270E} + - -
Programs Folder {7be9d83c-a729-4d97-b5a7-1b7313c39e0a} + - -
Briefcase {85BBD920-42A0-1069-A2E4-08002B30309D} + - -
Briefcase Folder {86747AC0-42A0-1069-A2E6-08002B30309D} +0 - -
Internet Explorer {871C5380-42A0-1069-A2EA-08002B30309D} + + +
Setup MSN Internet Access {88667D10-10F0-11D0-8150-00AA00BF8457} - + -
Downloaded Program Files {88C6C381-2E85-11d0-94DE-444553540000} + + +
Network Connections {992CFFA0-F557-101A-88EC-00DD010CCC48} + + -
Home Networking Wizard {B45EE8BF-8131-47A3-8E6D-92252F331CFF} - + -
Web Folders {BDEADF00-C265-11d0-BCED-00A0C90AB50F} + + -
Add Network Place {D4480A50-BA28-11d1-8E75-00C04FA31A86} - + -
Tasks {d6277990-4c6a-11cf-8d87-00aa0060f5bf} + + +
Search Results Folder {e17d4fc0-5564-11d1-83f2-00a0c90dc849} +0 +0 -
Scanners and Camera's {E211B736-43FD-11D1-9EFB-0000F8757FCD} + + -
Offline Web Pages {F5175861-2688-11d0-9C5E-00AA00A45957} + + +
Scanners and Camera's {FB0C9C8A-6C50-11D1-9F1D-0000F8757FCD} + + -
Composite Folder {FEF10DED-355E-4e06-9381-9B24D7F7CC88} - +0 -
History {FF393560-C2A7-11CF-BFF4-444553540000} +0 + +

Folder Shortcut {0AFACED1-E828-11D1-9187-B532F1E9575D} + + -

Create a shortcut to a map named TARGET.LNK and place this in a folder with the DESKTOP.INI
When this folder is opened, TARGET.LNK will be executed.


UICLSID values:

Fonts {BD84B380-8CA2-1069-AB1D-08000948F534} +0 + +
Temporary Internet Files {7BD29E00-76C1-11CF-9DD0-00A0C9034933} +0 + +


NON-WINDOWS values:

McAfee Fortress 2.0 {0ce45360-6245-11d0-b599-10005a11ba95} ? ? +
McAfee ZIP Manager 1.03 {be504840-6d2e-11d0-a40f-10005a641926} ? ? +
McAfee File Shredder 2.0 {dd7450c0-3e14-11d0-b599-10005a11ba95} ? ? +
McAfee Quick Copy {f59f3760-6fae-11d1-b87d-444553540000} ? ? +