From 45c0491dcf41c537595fdb465625aee806c9f390 Mon Sep 17 00:00:00 2001 From: Fabio Varesano Date: Wed, 3 Jan 2007 17:20:52 +0000 Subject: Added support for postgresql. --- video.install | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) (limited to 'video.install') diff --git a/video.install b/video.install index 7c946b6..a8e4c6f 100644 --- a/video.install +++ b/video.install @@ -31,6 +31,35 @@ function video_install() { serialized_data text NULL default NULL, PRIMARY KEY (vid) ) TYPE=MyISAM COMMENT='size is in bytes' /*!40100 DEFAULT CHARACTER SET utf8 */;"); + break; + case 'pgsql': + db_query("CREATE TABLE {video} ( + vid integer NOT NULL default '0', + nid integer NOT NULL default '0', + vidfile text NOT NULL default '', + videox smallint NOT NULL default '0', + videoy smallint NOT NULL default '0', + size bigint default NULL, + download_counter integer NOT NULL default '0', + play_counter integer NOT NULL default '0', + video_bitrate integer default NULL, + audio_bitrate integer default NULL, + audio_sampling_rate integer default NULL, + audio_channels varchar(10) default NULL, + playtime_seconds integer default NULL, + download_folder varchar(255) NULL default NULL, + disable_multidownload smallint NOT NULL default '0', + use_play_folder smallint NOT NULL default '0', + custom_field_1 varchar(255) NULL default NULL, + custom_field_2 varchar(255) NULL default NULL, + custom_field_3 varchar(255) NULL default NULL, + custom_field_4 varchar(255) NULL default NULL, + custom_field_5 text NULL default NULL, + custom_field_6 text NULL default NULL, + serialized_data text NULL default NULL, + PRIMARY KEY (vid) + );"); + } } -- cgit v1.2.3