From efad769aead9d04d0b7a3c8f99e708129f8f1f89 Mon Sep 17 00:00:00 2001 From: Fabio Varesano Date: Fri, 28 Oct 2005 18:50:36 +0000 Subject: Added unsigned to all int fields. --- video.mysql | 21 +++++++++++---------- 1 file changed, 11 insertions(+), 10 deletions(-) diff --git a/video.mysql b/video.mysql index a1ebf0e..e36af20 100644 --- a/video.mysql +++ b/video.mysql @@ -1,19 +1,20 @@ +-- $Id$ CREATE TABLE video ( nid int(10) unsigned NOT NULL default '0', - vidfile text NOT NULL, - videox smallint(4) NOT NULL default '0', - videoy smallint(4) NOT NULL default '0', - size bigint(13) default NULL, + vidfile text NOT NULL default '', + videox smallint(4) unsigned NOT NULL default '0', + videoy smallint(4) unsigned NOT NULL default '0', + size bigint(13) unsigned default NULL, download_counter int(10) unsigned NOT NULL default '0', play_counter int(10) unsigned NOT NULL default '0', - video_bitrate int(11) default NULL, - audio_bitrate int(11) default NULL, - audio_sampling_rate int(11) default NULL, + video_bitrate int(11) unsigned default NULL, + audio_bitrate int(11) unsigned default NULL, + audio_sampling_rate int(11) unsigned default NULL, audio_channels enum('','5.1','stereo','mono') default NULL, - playtime_seconds int(11) default NULL, + playtime_seconds int(11) unsigned default NULL, download_folder varchar(255) NULL default NULL, - disable_multidownload tinyint(1) NOT NULL default '0', - use_play_folder tinyint(1) NOT NULL default '0', + disable_multidownload tinyint(1) unsigned NOT NULL default '0', + use_play_folder tinyint(1) unsigned 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, -- cgit v1.2.3