maintenance/sqlite/archives/patch-ip_changes-pc_rev_timestamp-drop-default.sql

   1 CREATE TABLE /*_*/ip_changes_tmp (
   2   ipc_rev_id INTEGER UNSIGNED DEFAULT 0 NOT NULL,
   3   ipc_rev_timestamp BLOB NOT NULL,
   4   ipc_hex BLOB DEFAULT '' NOT NULL,
   5   PRIMARY KEY(ipc_rev_id)
   6 );
   7
   8 INSERT INTO /*_*/ip_changes_tmp
   9   SELECT ipc_rev_id, ipc_rev_timestamp, ipc_hex
  10   FROM /*_*/ip_changes;
  11 DROP TABLE /*_*/ip_changes;
  12 ALTER TABLE /*_*/ip_changes_tmp RENAME TO /*_*/ip_changes;
  13
  14
  15 CREATE INDEX ipc_rev_timestamp ON /*_*/ip_changes (ipc_rev_timestamp);
  16
  17 CREATE INDEX ipc_hex_time ON /*_*/ip_changes (ipc_hex, ipc_rev_timestamp);