diff options
Diffstat (limited to 'phpBB/db')
| -rw-r--r-- | phpBB/db/mysql_basic.sql | 8 | ||||
| -rw-r--r-- | phpBB/db/mysql_schema.sql | 11 |
2 files changed, 12 insertions, 7 deletions
diff --git a/phpBB/db/mysql_basic.sql b/phpBB/db/mysql_basic.sql index b5adbb8316..c2f152b3f6 100644 --- a/phpBB/db/mysql_basic.sql +++ b/phpBB/db/mysql_basic.sql @@ -16,9 +16,9 @@ INSERT INTO phpbb_forums VALUES (1,'Test Forum 1','This is just a test forum, no INSERT INTO phpbb_forum_mods VALUES (1,1,0); # -- Users -INSERT INTO phpbb_users VALUES (1,'admin',NOW(),'21232f297a57a5a743894a0e4a801fc3','admin@yourdomain.com','','','','','','This is just a stupid sig',1,1,'','','',0,1,0,0,0,0,'',4,'','','',0,'-8',1, ''); -INSERT INTO phpbb_users VALUES (-1,'Anonymous',NOW(),'','','','','','','','',0,0,'','','',0,0,0,0,0,0,'',0,'','','',0,'-8',1,'Default'); +INSERT INTO phpbb_users VALUES (1,'admin',NOW(),'21232f297a57a5a743894a0e4a801fc3','admin@yourdomain.com','','','','','','','This is just a stupid sig',1,1,'','','',0,1,0,0,0,0,'',4,'','','',0,'-8',1, ''); +INSERT INTO phpbb_users VALUES (-1,'Anonymous',NOW(),'','','','','','','','','',0,0,'','','',0,0,0,0,0,0,'',0,'','','',0,'-8',1,'Default'); # -- Themes -INSERT INTO phpbb_themes VALUES ( '1', 'Default', '', 'FFFFFF', '000000', '', '', '', '', '', '', '', '495FA8', '', '', '000000', 'CCCCCC', 'DDDDDD', 'sans-serif', '', '', '2', '0', '0', 'FFFFFF', '000000', '', '', '', '', ''); -INSERT INTO phpbb_themes_name VALUES ( '1', '', '', '', 'Table Header', '', '', 'Table background', 'Row Color 1', 'Row Color 2', '', '', '', 'Titles', '', '', 'Titles', 'General Text', '', '', '', '', ''); +INSERT INTO phpbb_themes VALUES ( '1', 'Default', '', '', 'FFFFFF', '000000', '', '', '', '', '', '', '', '495FA8', '', '', '000000', 'CCCCCC', 'DDDDDD', 'sans-serif', '', '', '2', '0', '0', 'FFFFFF', '000000', '', '', '', '', ''); +INSERT INTO phpbb_themes_name VALUES ( '1', '', '', '', '', 'Table Header', '', '', 'Table background', 'Row Color 1', 'Row Color 2', '', '', '', 'Titles', '', '', 'Titles', 'General Text', '', '', '', '', ''); diff --git a/phpBB/db/mysql_schema.sql b/phpBB/db/mysql_schema.sql index e3f56e0614..82519c2ed3 100644 --- a/phpBB/db/mysql_schema.sql +++ b/phpBB/db/mysql_schema.sql @@ -200,13 +200,16 @@ CREATE TABLE phpbb_ranks ( # CREATE TABLE phpbb_session ( - session_id int(11) unsigned NOT NULL, + session_id int(11) NOT NULL, session_user_id int(11) NOT NULL, - session_time int(11) unsigned NOT NULL, + session_start int(11) NOT NULL, + session_time int(11) NOT NULL, session_ip char(8) NOT NULL, session_page int(11), session_logged_in tinyint(1) NOT NULL, - PRIMARY KEY (session_id) + PRIMARY KEY (session_id), + KEY session_ip (session_ip), + KEY session_user_id (session_user_id) ); @@ -232,6 +235,7 @@ CREATE TABLE phpbb_smilies ( CREATE TABLE phpbb_themes ( themes_id int(11) NOT NULL auto_increment, themes_name varchar(30), + head_stylesheet varchar(100), body_background varchar(100), body_bgcolor varchar(6), body_text varchar(6), @@ -331,6 +335,7 @@ CREATE TABLE phpbb_users ( username varchar(40) NOT NULL, user_regdate varchar(20) NOT NULL, user_password varchar(32) NOT NULL, + user_autologin_key varchar(32), user_hint varchar(25) NOT NULL, user_email varchar(255), user_icq varchar(15), |