[Vince]

Quote:

Originally Posted by Logic_ Hi there, I'm trying to revert the values of the column to the default one, but I'm not sure how can I do it. I've posted my SQL(ite) table below. Thanks. PHP Code: CREATE TABLE IF NOT EXISTS `Gangs` (`GangID` INTEGER PRIMARY KEY AUTOINCREMENT, `GangName` STRING DEFAULT 'Null', `GangMotd` STRING DEFAULT 'Null', `GangMembers` INTEGER DEFAULT 0, `GangRank1` STRING DEFAULT 'Rank 1', `GangRank2` STRING DEFAULT 'Rank 2', `GangRank3` STRING DEFAULT 'Rank 3', `GangRank4` STRING DEFAULT 'Rank 4', `GangRank5` STRING DEFAULT 'Rank 5', `GangRank6` STRING DEFAULT 'Rank 6')

Delete the row. It's no use to store a row full of null values. If your gamemode cannot function without the presence of a specific row in a database then that is a design flaw. This table is also not properly normalized. Ideally you would have an extra table to store the rank names which would have three columns: gangid, rank sequence number and the actual name. In that way you also don't limit yourself to six. If you want to remove a rank you just delete that row from the table.