[Phpbb-php5mod-cvs-checkins] phpbb-php5/install/schemas mssql_basic.sql,1.8,1.9 mssql_schema.sql,1.2
Brought to you by:
jelly_doughnut
Menu
▾
▴
[Phpbb-php5mod-cvs-checkins] phpbb-php5/install/schemas mssql_basic.sql,1.8,1.9 mssql_schema.sql,1.2,1.3 mysql_basic.sql,1.8,1.9 mysql_schema.sql,1.2,1.3 postgres_basic.sql,1.8,1.9 postgres_schema.sql,1.2,1.3
Update of /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv1999/install_/schemas Modified Files: mssql_basic.sql mssql_schema.sql mysql_basic.sql mysql_schema.sql postgres_basic.sql postgres_schema.sql Log Message: Schema updates Index: mysql_schema.sql =================================================================== RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_schema.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** mysql_schema.sql 9 May 2005 00:33:17 -0000 1.2 --- mysql_schema.sql 31 Oct 2005 21:35:11 -0000 1.3 *************** *** 312,315 **** --- 312,328 ---- ); + # -------------------------------------------------------- + # + # Table structure for table `phpbb_sessions_keys` + # + CREATE TABLE phpbb_sessions_keys ( + key_id varchar(32) DEFAULT '0' NOT NULL, + user_id mediumint(8) DEFAULT '0' NOT NULL, + last_ip varchar(8) DEFAULT '0' NOT NULL, + last_login int(11) DEFAULT '0' NOT NULL, + PRIMARY KEY (key_id, user_id), + KEY last_login (last_login) + ); + # -------------------------------------------------------- Index: postgres_schema.sql =================================================================== RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_schema.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** postgres_schema.sql 9 May 2005 00:33:17 -0000 1.2 --- postgres_schema.sql 31 Oct 2005 21:35:11 -0000 1.3 *************** *** 296,299 **** --- 296,311 ---- CREATE INDEX session_id_ip_user_id_phpbb_sessions_index ON phpbb_sessions (session_id, session_ip, session_user_id); + /* -------------------------------------------------------- + Table structure for table phpbb_sessions_keys + -------------------------------------------------------- */ + CREATE TABLE phpbb_sessions_keys ( + key_id char(32) DEFAULT '0' NOT NULL, + user_id int4 DEFAULT '0' NOT NULL, + last_ip char(8) DEFAULT '0' NOT NULL, + last_login int4 DEFAULT '0' NOT NULL, + CONSTRAINT phpbb_sessions_keys_pkey PRIMARY KEY (key_id, user_id) + ); + CREATE INDEX last_login_phpbb_sessions_keys_index ON phpbb_sessions_keys (last_login); + /* -------------------------------------------------------- *************** *** 490,497 **** user_avatar varchar(100), user_avatar_type int2 DEFAULT '0' NOT NULL, ! user_level int4 DEFAULT '1', user_lang varchar(255), user_timezone decimal(5) DEFAULT '0' NOT NULL, ! user_dateformat varchar(14) DEFAULT 'd M Y H:m' NOT NULL, user_notify_pm int2 DEFAULT '0' NOT NULL, user_popup_pm int2 DEFAULT '0' NOT NULL, --- 502,509 ---- user_avatar varchar(100), user_avatar_type int2 DEFAULT '0' NOT NULL, ! user_level int4 DEFAULT '0', user_lang varchar(255), user_timezone decimal(5) DEFAULT '0' NOT NULL, ! user_dateformat varchar(14) DEFAULT 'd M Y H:i' NOT NULL, user_notify_pm int2 DEFAULT '0' NOT NULL, user_popup_pm int2 DEFAULT '0' NOT NULL, Index: mssql_schema.sql =================================================================== RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_schema.sql,v retrieving revision 1.2 retrieving revision 1.3 diff -C2 -d -r1.2 -r1.3 *** mssql_schema.sql 9 May 2005 00:33:17 -0000 1.2 --- mssql_schema.sql 31 Oct 2005 21:35:11 -0000 1.3 *************** *** 196,199 **** --- 196,207 ---- GO + CREATE TABLE [phpbb_sessions_keys] ( + [key_id] [char] (32) NOT NULL , + [user_id] [int] NOT NULL , + [last_ip] [char] (8) NOT NULL , + [last_login] [int] NOT NULL + ) ON [PRIMARY] + GO + CREATE TABLE [phpbb_smilies] ( [smilies_id] [int] IDENTITY (1, 1) NOT NULL , *************** *** 617,620 **** --- 625,629 ---- CONSTRAINT [DF_phpbb_users_user_notify_pm] DEFAULT (0) FOR [user_notify_pm], CONSTRAINT [DF_phpbb_users_user_popup_pm] DEFAULT (1) FOR [user_popup_pm], + CONSTRAINT [DF_phpbb_users_user_dateformat] DEFAULT('d M Y H:i') FOR [user_dateformat], CONSTRAINT [DF_phpbb_users_user_avatar_type] DEFAULT (0) FOR [user_avatar_type] GO *************** *** 677,680 **** --- 686,696 ---- GO + CREATE INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([key_id], [user_id]) ON [PRIMARY] + GO + + CREATE INDEX [IX_phpbb_sessions_keys] ON [phpbb_sessions_keys]([last_login]) ON [PRIMARY] + GO + + CREATE INDEX [IX_phpbb_user_group] ON [phpbb_user_group]([group_id], [user_id]) ON [PRIMARY] GO Index: postgres_basic.sql =================================================================== RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/postgres_basic.sql,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** postgres_basic.sql 19 Jul 2005 23:14:52 -0000 1.8 --- postgres_basic.sql 31 Oct 2005 21:35:11 -0000 1.9 *************** *** 26,29 **** --- 26,31 ---- INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0'); + INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1'); + INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15'); *************** *** 64,69 **** INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.17'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5'); -- Categories --- 66,71 ---- INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.18'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.18.5'); -- Categories Index: mysql_basic.sql =================================================================== RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mysql_basic.sql,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** mysql_basic.sql 19 Jul 2005 23:14:52 -0000 1.8 --- mysql_basic.sql 31 Oct 2005 21:35:11 -0000 1.9 *************** *** 25,28 **** --- 25,30 ---- INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0'); + INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1'); + INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15'); *************** *** 63,68 **** INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.17'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5'); --- 65,70 ---- INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.18'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.18.5'); Index: mssql_basic.sql =================================================================== RCS file: /cvsroot/phpbb-php5mod/phpbb-php5/install/schemas/mssql_basic.sql,v retrieving revision 1.8 retrieving revision 1.9 diff -C2 -d -r1.8 -r1.9 *** mssql_basic.sql 19 Jul 2005 23:14:52 -0000 1.8 --- mssql_basic.sql 31 Oct 2005 21:35:11 -0000 1.9 *************** *** 43,46 **** --- 43,48 ---- INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','you...@yo...'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('enable_confirm', '0'); + INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_autologin','1'); + INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_autologin_time','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host',''); *************** *** 70,75 **** INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.17'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.17.5'); /* --- 72,77 ---- INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.18'); ! INSERT INTO phpbb_config (config_name, config_value) VALUES ('version5', '.0.18.5'); /* |
