diff options
Diffstat (limited to 'update.php')
| -rw-r--r-- | update.php | 50 |
1 files changed, 25 insertions, 25 deletions
diff --git a/update.php b/update.php index 38738dee9..46ce7d87d 100644 --- a/update.php +++ b/update.php @@ -624,7 +624,7 @@ function update_create_cache_tables() { created int NOT NULL default '0', headers text, PRIMARY KEY (cid), - INDEX expire (expire) + INDEX expire (expire), ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); $ret[] = update_sql("CREATE TABLE {cache_menu} ( cid varchar(255) NOT NULL default '', @@ -633,7 +633,7 @@ function update_create_cache_tables() { created int NOT NULL default '0', headers text, PRIMARY KEY (cid), - INDEX expire (expire) + INDEX expire (expire), ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); $ret[] = update_sql("CREATE TABLE {cache_page} ( cid varchar(255) BINARY NOT NULL default '', @@ -642,7 +642,7 @@ function update_create_cache_tables() { created int NOT NULL default '0', headers text, PRIMARY KEY (cid), - INDEX expire (expire) + INDEX expire (expire), ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); break; case 'pgsql': @@ -652,28 +652,28 @@ function update_create_cache_tables() { expire int NOT NULL default '0', created int NOT NULL default '0', headers text, - PRIMARY KEY (cid) - )"); - $ret[] = update_sql("CREATE TABLE {cache_menu} ( - cid varchar(255) NOT NULL default '', - data bytea, - expire int NOT NULL default '0', - created int NOT NULL default '0', - headers text, - PRIMARY KEY (cid) - )"); - $ret[] = update_sql("CREATE TABLE {cache_page} ( - cid varchar(255) NOT NULL default '', - data bytea, - expire int NOT NULL default '0', - created int NOT NULL default '0', - headers text, - PRIMARY KEY (cid) - )"); - $ret[] = update_sql("CREATE INDEX {cache_filter}_expire_idx ON {cache_filter} (expire)"); - $ret[] = update_sql("CREATE INDEX {cache_menu}_expire_idx ON {cache_menu} (expire)"); - $ret[] = update_sql("CREATE INDEX {cache_page}_expire_idx ON {cache_page} (expire)"); - break; + PRIMARY KEY (cid), + )"); + $ret[] = update_sql("CREATE TABLE {cache_menu} ( + cid varchar(255) NOT NULL default '', + data bytea, + expire int NOT NULL default '0', + created int NOT NULL default '0', + headers text, + PRIMARY KEY (cid), + )"); + $ret[] = update_sql("CREATE TABLE {cache_page} ( + cid varchar(255) NOT NULL default '', + data bytea, + expire int NOT NULL default '0', + created int NOT NULL default '0', + headers text, + PRIMARY KEY (cid), + )"); + $ret[] = update_sql("CREATE INDEX {cache_filter}_expire_idx ON {cache_filter} (expire)"); + $ret[] = update_sql("CREATE INDEX {cache_menu}_expire_idx ON {cache_menu} (expire)"); + $ret[] = update_sql("CREATE INDEX {cache_page}_expire_idx ON {cache_page} (expire)"); + break; } return $ret; } |