--- node_images.install.ORIGINAL 2007-03-18 12:50:10.000000000 +0000 +++ node_images.install 2007-03-18 12:48:40.000000000 +0000 @@ -25,5 +25,25 @@ KEY uid (uid), KEY nid_status (nid,status) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + break; + case 'pgsql': + db_query("CREATE TABLE {node_images} ( + id SERIAL PRIMARY KEY, + nid integer NOT NULL default '0', + uid integer NOT NULL default '0', + filename varchar(255) NOT NULL default '', + filepath varchar(255) NOT NULL default '', + filemime varchar(255) NOT NULL default '', + filesize integer NOT NULL default '0', + thumbpath varchar(255) NOT NULL default '', + thumbsize integer NOT NULL default '0', + status smallint NOT NULL default '1', + weight smallint NOT NULL default '0', + description varchar(255) default NULL + )"); + db_query("CREATE INDEX {node_images}_uid ON {node_images} (uid)"); + db_query("CREATE INDEX {node_images}_nid_status + ON {node_images} (nid,status)"); + break; } }