|
From: Paul S. O. <ps...@us...> - 2002-05-08 23:34:42
|
Update of /cvsroot/phpbb/phpBB2/db/schemas
In directory usw-pr-cvs1:/tmp/cvs-serv29613/db/schemas
Modified Files:
mssql_schema.sql mysql_schema.sql postgres_schema.sql
Log Message:
IP size to 40 chars
Index: mssql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mssql_schema.sql,v
retrieving revision 1.26
retrieving revision 1.27
diff -C2 -r1.26 -r1.27
*** mssql_schema.sql 20 Apr 2002 23:43:46 -0000 1.26
--- mssql_schema.sql 8 May 2002 23:34:36 -0000 1.27
***************
*** 31,35 ****
[ban_id] [int] IDENTITY (1, 1) NOT NULL ,
[ban_userid] [int] NULL ,
! [ban_ip] [char] (8) NULL ,
[ban_email] [varchar] (50) NULL
) ON [PRIMARY]
--- 31,35 ----
[ban_id] [int] IDENTITY (1, 1) NOT NULL ,
[ban_userid] [int] NULL ,
! [ban_ip] [char] (40) NULL ,
[ban_email] [varchar] (50) NULL
) ON [PRIMARY]
***************
*** 112,116 ****
[poster_id] [int] NOT NULL ,
[post_time] [int] NOT NULL ,
! [poster_ip] [char] (8) NULL ,
[post_username] [char] (25) NULL ,
[enable_bbcode] [smallint] NULL ,
--- 112,116 ----
[poster_id] [int] NOT NULL ,
[post_time] [int] NOT NULL ,
! [poster_ip] [char] (40) NULL ,
[post_username] [char] (25) NULL ,
[enable_bbcode] [smallint] NULL ,
***************
*** 138,142 ****
[privmsgs_to_userid] [int] NOT NULL ,
[privmsgs_date] [int] NOT NULL ,
! [privmsgs_ip] [char] (8) NOT NULL ,
[privmsgs_enable_bbcode] [smallint] NULL ,
[privmsgs_enable_html] [smallint] NULL ,
--- 138,142 ----
[privmsgs_to_userid] [int] NOT NULL ,
[privmsgs_date] [int] NOT NULL ,
! [privmsgs_ip] [char] (40) NOT NULL ,
[privmsgs_enable_bbcode] [smallint] NULL ,
[privmsgs_enable_html] [smallint] NULL ,
***************
*** 188,192 ****
[session_start] [int] NULL ,
[session_time] [int] NULL ,
! [session_ip] [char] (8) NOT NULL ,
[session_page] [int] NULL ,
[session_logged_in] [smallint] NULL
--- 188,192 ----
[session_start] [int] NULL ,
[session_time] [int] NULL ,
! [session_ip] [char] (40) NOT NULL ,
[session_page] [int] NULL ,
[session_logged_in] [smallint] NULL
***************
*** 384,388 ****
[vote_id] [int] NOT NULL ,
[vote_user_id] [int] NOT NULL ,
! [vote_user_ip] [char] (8) NOT NULL
) ON [PRIMARY]
GO
--- 384,388 ----
[vote_id] [int] NOT NULL ,
[vote_user_id] [int] NOT NULL ,
! [vote_user_ip] [char] (40) NOT NULL
) ON [PRIMARY]
GO
Index: mysql_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/mysql_schema.sql,v
retrieving revision 1.19
retrieving revision 1.20
diff -C2 -r1.19 -r1.20
*** mysql_schema.sql 20 Apr 2002 23:43:46 -0000 1.19
--- mysql_schema.sql 8 May 2002 23:34:36 -0000 1.20
***************
*** 61,66 ****
ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
ban_userid mediumint(8) NOT NULL,
! ban_ip char(8) NOT NULL,
! ban_email varchar(255),
PRIMARY KEY (ban_id),
KEY ban_ip_user_id (ban_ip, ban_userid)
--- 61,66 ----
ban_id mediumint(8) UNSIGNED NOT NULL auto_increment,
ban_userid mediumint(8) NOT NULL,
! ban_ip char(40) NOT NULL,
! ban_email char(50),
PRIMARY KEY (ban_id),
KEY ban_ip_user_id (ban_ip, ban_userid)
***************
*** 74,78 ****
CREATE TABLE phpbb_categories (
cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! cat_title varchar(100),
cat_order mediumint(8) UNSIGNED NOT NULL,
PRIMARY KEY (cat_id),
--- 74,78 ----
CREATE TABLE phpbb_categories (
cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! cat_title char(60),
cat_order mediumint(8) UNSIGNED NOT NULL,
PRIMARY KEY (cat_id),
***************
*** 98,102 ****
CREATE TABLE phpbb_disallow (
disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! disallow_username varchar(25),
PRIMARY KEY (disallow_id)
);
--- 98,102 ----
CREATE TABLE phpbb_disallow (
disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! disallow_username char(30),
PRIMARY KEY (disallow_id)
);
***************
*** 175,179 ****
poster_id mediumint(8) DEFAULT '0' NOT NULL,
post_time int(11) DEFAULT '0' NOT NULL,
! poster_ip char(8) NOT NULL,
post_username varchar(25),
enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
--- 175,179 ----
poster_id mediumint(8) DEFAULT '0' NOT NULL,
post_time int(11) DEFAULT '0' NOT NULL,
! poster_ip char(40) NOT NULL,
post_username varchar(25),
enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
***************
*** 211,219 ****
privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment,
privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
! privmsgs_subject varchar(255) DEFAULT '0' NOT NULL,
privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_date int(11) DEFAULT '0' NOT NULL,
! privmsgs_ip char(8) NOT NULL,
privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
--- 211,219 ----
privmsgs_id mediumint(8) UNSIGNED NOT NULL auto_increment,
privmsgs_type tinyint(4) DEFAULT '0' NOT NULL,
! privmsgs_subject char(60) DEFAULT '0' NOT NULL,
privmsgs_from_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_to_userid mediumint(8) DEFAULT '0' NOT NULL,
privmsgs_date int(11) DEFAULT '0' NOT NULL,
! privmsgs_ip char(40) NOT NULL,
privmsgs_enable_bbcode tinyint(1) DEFAULT '1' NOT NULL,
privmsgs_enable_html tinyint(1) DEFAULT '0' NOT NULL,
***************
*** 244,251 ****
CREATE TABLE phpbb_ranks (
rank_id smallint(5) UNSIGNED NOT NULL auto_increment,
! rank_title varchar(50) NOT NULL,
rank_min mediumint(8) DEFAULT '0' NOT NULL,
rank_special tinyint(1) DEFAULT '0',
! rank_image varchar(255),
PRIMARY KEY (rank_id)
);
--- 244,251 ----
CREATE TABLE phpbb_ranks (
rank_id smallint(5) UNSIGNED NOT NULL auto_increment,
! rank_title char(50) NOT NULL,
rank_min mediumint(8) DEFAULT '0' NOT NULL,
rank_special tinyint(1) DEFAULT '0',
! rank_image char(100),
PRIMARY KEY (rank_id)
);
***************
*** 270,274 ****
#
CREATE TABLE phpbb_search_wordlist (
! word_text varchar(50) binary NOT NULL default '',
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL default '0',
--- 270,274 ----
#
CREATE TABLE phpbb_search_wordlist (
! word_text char(25) binary NOT NULL default '',
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
word_common tinyint(1) unsigned NOT NULL default '0',
***************
*** 309,313 ****
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
! session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
--- 309,313 ----
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
! session_ip char(40) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
***************
*** 324,330 ****
CREATE TABLE phpbb_smilies (
smilies_id smallint(5) UNSIGNED NOT NULL auto_increment,
! code varchar(50),
! smile_url varchar(100),
! emoticon varchar(75),
PRIMARY KEY (smilies_id)
);
--- 324,330 ----
CREATE TABLE phpbb_smilies (
smilies_id smallint(5) UNSIGNED NOT NULL auto_increment,
! code char(10),
! smile_url char(50),
! emoticon char(50),
PRIMARY KEY (smilies_id)
);
***************
*** 337,380 ****
CREATE TABLE phpbb_themes (
themes_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! template_name varchar(30) NOT NULL default '',
! style_name varchar(30) NOT NULL default '',
! head_stylesheet varchar(100) default NULL,
! body_background varchar(100) default NULL,
! body_bgcolor varchar(6) default NULL,
! body_text varchar(6) default NULL,
! body_link varchar(6) default NULL,
! body_vlink varchar(6) default NULL,
! body_alink varchar(6) default NULL,
! body_hlink varchar(6) default NULL,
! tr_color1 varchar(6) default NULL,
! tr_color2 varchar(6) default NULL,
! tr_color3 varchar(6) default NULL,
! tr_class1 varchar(25) default NULL,
! tr_class2 varchar(25) default NULL,
! tr_class3 varchar(25) default NULL,
! th_color1 varchar(6) default NULL,
! th_color2 varchar(6) default NULL,
! th_color3 varchar(6) default NULL,
! th_class1 varchar(25) default NULL,
! th_class2 varchar(25) default NULL,
! th_class3 varchar(25) default NULL,
! td_color1 varchar(6) default NULL,
! td_color2 varchar(6) default NULL,
! td_color3 varchar(6) default NULL,
! td_class1 varchar(25) default NULL,
! td_class2 varchar(25) default NULL,
! td_class3 varchar(25) default NULL,
! fontface1 varchar(50) default NULL,
! fontface2 varchar(50) default NULL,
! fontface3 varchar(50) default NULL,
fontsize1 tinyint(4) default NULL,
fontsize2 tinyint(4) default NULL,
fontsize3 tinyint(4) default NULL,
! fontcolor1 varchar(6) default NULL,
! fontcolor2 varchar(6) default NULL,
! fontcolor3 varchar(6) default NULL,
! span_class1 varchar(25) default NULL,
! span_class2 varchar(25) default NULL,
! span_class3 varchar(25) default NULL,
img_size_poll smallint(5) UNSIGNED,
img_size_privmsg smallint(5) UNSIGNED,
--- 337,380 ----
CREATE TABLE phpbb_themes (
themes_id mediumint(8) UNSIGNED NOT NULL auto_increment,
! template_name char(30) NOT NULL default '',
! style_name char(30) NOT NULL default '',
! head_stylesheet char(100) default NULL,
! body_background char(100) default NULL,
! body_bgcolor char(6) default NULL,
! body_text char(6) default NULL,
! body_link char(6) default NULL,
! body_vlink char(6) default NULL,
! body_alink char(6) default NULL,
! body_hlink char(6) default NULL,
! tr_color1 char(6) default NULL,
! tr_color2 char(6) default NULL,
! tr_color3 char(6) default NULL,
! tr_class1 char(25) default NULL,
! tr_class2 char(25) default NULL,
! tr_class3 char(25) default NULL,
! th_color1 char(6) default NULL,
! th_color2 char(6) default NULL,
! th_color3 char(6) default NULL,
! th_class1 char(25) default NULL,
! th_class2 char(25) default NULL,
! th_class3 char(25) default NULL,
! td_color1 char(6) default NULL,
! td_color2 char(6) default NULL,
! td_color3 char(6) default NULL,
! td_class1 char(25) default NULL,
! td_class2 char(25) default NULL,
! td_class3 char(25) default NULL,
! fontface1 char(50) default NULL,
! fontface2 char(50) default NULL,
! fontface3 char(50) default NULL,
fontsize1 tinyint(4) default NULL,
fontsize2 tinyint(4) default NULL,
fontsize3 tinyint(4) default NULL,
! fontcolor1 char(6) default NULL,
! fontcolor2 char(6) default NULL,
! fontcolor3 char(6) default NULL,
! span_class1 char(25) default NULL,
! span_class2 char(25) default NULL,
! span_class3 char(25) default NULL,
img_size_poll smallint(5) UNSIGNED,
img_size_privmsg smallint(5) UNSIGNED,
***************
*** 470,475 ****
user_id mediumint(8) NOT NULL auto_increment,
user_active tinyint(1) DEFAULT '1',
! username varchar(25) NOT NULL,
! user_password varchar(32) NOT NULL,
user_session_time int(11) DEFAULT '0' NOT NULL,
user_session_page smallint(5) DEFAULT '0' NOT NULL,
--- 470,475 ----
user_id mediumint(8) NOT NULL auto_increment,
user_active tinyint(1) DEFAULT '1',
! username char(30) NOT NULL,
! user_password char(32) NOT NULL,
user_session_time int(11) DEFAULT '0' NOT NULL,
user_session_page smallint(5) DEFAULT '0' NOT NULL,
***************
*** 480,485 ****
user_timezone decimal(4,2) DEFAULT '0' NOT NULL,
user_style tinyint(4),
! user_lang varchar(255),
! user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL,
user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
--- 480,485 ----
user_timezone decimal(4,2) DEFAULT '0' NOT NULL,
user_style tinyint(4),
! user_lang char(50),
! user_dateformat char(15) DEFAULT 'd M Y H:i' NOT NULL,
user_new_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
user_unread_privmsg smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
***************
*** 498,504 ****
user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
user_rank int(11) DEFAULT '0',
! user_avatar varchar(100),
user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
! user_email varchar(255),
user_icq varchar(15),
user_website varchar(100),
--- 498,504 ----
user_popup_pm tinyint(1) DEFAULT '0' NOT NULL,
user_rank int(11) DEFAULT '0',
! user_avatar char(100),
user_avatar_type tinyint(4) DEFAULT '0' NOT NULL,
! user_email char(60),
user_icq varchar(15),
user_website varchar(100),
***************
*** 554,558 ****
vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
vote_user_id mediumint(8) NOT NULL DEFAULT '0',
! vote_user_ip char(8) NOT NULL,
KEY vote_id (vote_id),
KEY vote_user_id (vote_user_id),
--- 554,558 ----
vote_id mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
vote_user_id mediumint(8) NOT NULL DEFAULT '0',
! vote_user_ip char(40) NOT NULL,
KEY vote_id (vote_id),
KEY vote_user_id (vote_user_id),
Index: postgres_schema.sql
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/db/schemas/postgres_schema.sql,v
retrieving revision 1.21
retrieving revision 1.22
diff -C2 -r1.21 -r1.22
*** postgres_schema.sql 20 Apr 2002 23:43:46 -0000 1.21
--- postgres_schema.sql 8 May 2002 23:34:36 -0000 1.22
***************
*** 64,68 ****
ban_id int4 DEFAULT nextval('phpbb_banlist_id_seq'::text) NOT NULL,
ban_userid int4,
! ban_ip char(8),
ban_email varchar(255),
CONSTRAINT phpbb_banlist_pkey PRIMARY KEY (ban_id)
--- 64,68 ----
ban_id int4 DEFAULT nextval('phpbb_banlist_id_seq'::text) NOT NULL,
ban_userid int4,
! ban_ip char(40),
ban_email varchar(255),
CONSTRAINT phpbb_banlist_pkey PRIMARY KEY (ban_id)
***************
*** 172,176 ****
post_time int4 DEFAULT '0' NOT NULL,
post_username varchar(25),
! poster_ip char(8) DEFAULT '' NOT NULL,
enable_bbcode int2 DEFAULT '1' NOT NULL,
enable_html int2 DEFAULT '0' NOT NULL,
--- 172,176 ----
post_time int4 DEFAULT '0' NOT NULL,
post_username varchar(25),
! poster_ip char(40) DEFAULT '' NOT NULL,
enable_bbcode int2 DEFAULT '1' NOT NULL,
enable_html int2 DEFAULT '0' NOT NULL,
***************
*** 209,213 ****
privmsgs_to_userid int4 DEFAULT '0' NOT NULL,
privmsgs_date int4 DEFAULT '0' NOT NULL,
! privmsgs_ip char(8) NOT NULL,
privmsgs_enable_bbcode int2 DEFAULT '1' NOT NULL,
privmsgs_enable_html int2 DEFAULT '0' NOT NULL,
--- 209,213 ----
privmsgs_to_userid int4 DEFAULT '0' NOT NULL,
privmsgs_date int4 DEFAULT '0' NOT NULL,
! privmsgs_ip char(40) NOT NULL,
privmsgs_enable_bbcode int2 DEFAULT '1' NOT NULL,
privmsgs_enable_html int2 DEFAULT '0' NOT NULL,
***************
*** 287,291 ****
session_start int4 DEFAULT '0' NOT NULL,
session_time int4 DEFAULT '0' NOT NULL,
! session_ip char(8) DEFAULT '0' NOT NULL,
session_page int4 DEFAULT '0' NOT NULL,
session_logged_in int2 DEFAULT '0' NOT NULL,
--- 287,291 ----
session_start int4 DEFAULT '0' NOT NULL,
session_time int4 DEFAULT '0' NOT NULL,
! session_ip char(40) DEFAULT '0' NOT NULL,
session_page int4 DEFAULT '0' NOT NULL,
session_logged_in int2 DEFAULT '0' NOT NULL,
***************
*** 533,537 ****
vote_id int4 NOT NULL DEFAULT '0',
vote_user_id int4 NOT NULL DEFAULT '0',
! vote_user_ip char(8) NOT NULL
);
CREATE INDEX vote_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_id);
--- 533,537 ----
vote_id int4 NOT NULL DEFAULT '0',
vote_user_id int4 NOT NULL DEFAULT '0',
! vote_user_ip char(40) NOT NULL
);
CREATE INDEX vote_id_phpbb_vote_voters_index ON phpbb_vote_voters (vote_id);
|