Remove applications

To completely remove applications from the greenphone it is not enough to delete the package. The application still be showing in the "installed apps" menue. To remove this entry the SQLite database have to be revised. (Equally the applications can be removed from the emulator.) First, connect to the phone: 

	telnet gp
Get to the directory the SQLite databasefile is located: 
	cd /mnt/disk2/home/4.2/Applications/Qtopia
	Emualtor: cd /home/user/Application/Qtopia
Now execute sqlite and open the database: 
	/mnt/disk2/Qtopia/bin/sqlite qtopia_db.sqlite
	Emualtor: sqlite qtopia_db.sqlite
The tables content and contentProps contains the according information. The table content stores the application name (uiName) and its ID (cid). Through this ID the record is linked to the table contentProps. In the table contentProps you can find the application's installation path by looking up the cid.

sqlite> SELECT * FROM content;
You can see the table schema by calling .schema content: 


	

		cid
		uiName
		mType
		drmFlags
		docStatus
		path
		location
		icon
		linkFile
		linkLocation
		mimeTypes
		lastUpdated
	

	

		1
		QtImage
		1
		65536
		a
		c18009c7c11a0ed0f5c6b6d838fc3394_qtimage
		0
		QtImage
		QtImage.desktop
		10
		 
		1153909962

Table contentProps with schema: 


	

		cid
		grp
		name
		value
		

	

	

		1
		Package Data
		Path
		/mnt/disk2/packages/c18009c7c11a0ed0f5c6b6d838fc3394

Now you can delete the concerning records:

	DELETE FROM content WHERE cid = 1;
	DELETE FROM contentProps WHERE cid = 1;
The application packet can be found and removed at /mnt/disk2/packages/c18009c7c11a0ed0f5c6b6d838fc3394. You have to restart the phone so that the application menue gets refreshed.