alter table prefs add column main_cols varchar(10) default 'csfdzam';
CREATE TABLE bookmarks(
id int NOT NULL auto_increment,
owner int NOT NULL,
name text,
url text,
grp text,
is_private char,
comments text,
PRIMARY KEY (id),
KEY id (id),
KEY owner (owner)
);
alter table prefs add column clock_system tinyint(4) default 12;
CREATE TABLE cache(
id int NOT NULL auto_increment,
owner int NOT NULL,
cache_key varchar(64),
cache_data text,
PRIMARY KEY(id),
KEY id (id),
KEY owner (owner),
KEY cache_key (cache_key)
);
alter table prefs add column nav_no_flag char;
syntax highlighted by Code2HTML, v. 0.9.1