Open Bug 977160 Opened 7 years ago Updated 5 months ago

use WITHOUT ROWID in inputhistory table

Categories

(Toolkit :: Places, defect, P5)

defect
Points:
2

Tracking

()

REOPENED

People

(Reporter: mak, Unassigned)

References

(Blocks 2 open bugs)

Details

This is backwards compatible

ALTER TABLE moz_inputhistory RENAME TO moz_inputhistory_old

CREATE TABLE moz_inputhistory (
  place_id INTEGER NOT NULL,
  input TEXT NOT NULL,
  use_count INTEGER,
  PRIMARY KEY (place_id, input)
) WITHOUT ROWID

INSERT INTO moz_inputhistory SELECT place_id, input, use_count from moz_inputhistory_old

DROP TABLE moz_inputhistory_old
Priority: -- → P5
Per policy at https://wiki.mozilla.org/Bug_Triage/Projects/Bug_Handling/Bug_Husbandry#Inactive_Bugs. If this bug is not an enhancement request or a bug not present in a supported release of Firefox, then it may be reopened.
Status: NEW → RESOLVED
Closed: 2 years ago
Resolution: --- → INACTIVE
Status: RESOLVED → REOPENED
Resolution: INACTIVE → ---
Blocks: 1562823
Points: --- → 2
You need to log in before you can comment on or make changes to this bug.