1 CREATE TABLE /*_*/category_tmp (
2 cat_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
3 cat_title BLOB NOT NULL,
4 cat_pages INTEGER DEFAULT 0 NOT NULL,
5 cat_subcats INTEGER DEFAULT 0 NOT NULL,
6 cat_files INTEGER DEFAULT 0 NOT NULL
8 INSERT INTO /*_*/category_tmp
9 SELECT cat_id, cat_title, cat_pages, cat_subcats, cat_files
11 DROP TABLE /*_*/category;
12 ALTER TABLE /*_*/category_tmp RENAME TO /*_*/category;
14 CREATE UNIQUE INDEX cat_title ON /*_*/category (cat_title);
15 CREATE INDEX cat_pages ON /*_*/category (cat_pages);