aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2006-06-01 13:47:42 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2006-06-01 13:47:42 +0000
commit721a9dd4a146a08f26866196d8a347c7aad57274 (patch)
tree181f0955fd519718bc30274d226e4ddd108a7242 /phpBB/install
parent4354cda6dc695806dc01fdad1e4d11b2749ee9d4 (diff)
downloadforums-721a9dd4a146a08f26866196d8a347c7aad57274.tar
forums-721a9dd4a146a08f26866196d8a347c7aad57274.tar.gz
forums-721a9dd4a146a08f26866196d8a347c7aad57274.tar.bz2
forums-721a9dd4a146a08f26866196d8a347c7aad57274.tar.xz
forums-721a9dd4a146a08f26866196d8a347c7aad57274.zip
- create forums by default
- hide prune options if not enabled - fixed module management enable/disable switch if in module itself - fixed some schema errors - adjusted $user->page array generation for developers calling scripts outside of phpBB root git-svn-id: file:///svn/phpbb/trunk@5995 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/install')
-rw-r--r--phpBB/install/schemas/firebird_schema.sql8
-rw-r--r--phpBB/install/schemas/mssql_schema.sql10
-rw-r--r--phpBB/install/schemas/mysql_schema.sql8
-rw-r--r--phpBB/install/schemas/oracle_schema.sql8
-rw-r--r--phpBB/install/schemas/postgres_schema.sql8
-rw-r--r--phpBB/install/schemas/sqlite_schema.sql6
6 files changed, 24 insertions, 24 deletions
diff --git a/phpBB/install/schemas/firebird_schema.sql b/phpBB/install/schemas/firebird_schema.sql
index 97d5592fe7..e33efd71a9 100644
--- a/phpBB/install/schemas/firebird_schema.sql
+++ b/phpBB/install/schemas/firebird_schema.sql
@@ -1238,9 +1238,9 @@ CREATE TABLE phpbb_topics (
topic_moved_id INTEGER DEFAULT 0 NOT NULL,
topic_bumped INTEGER DEFAULT 0 NOT NULL,
topic_bumper INTEGER DEFAULT 0 NOT NULL,
- poll_title BLOB SUB_TYPE TEXT,
- poll_start INTEGER DEFAULT 0 NOT NULL,
- poll_length INTEGER DEFAULT 0 NOT NULL,
+ poll_title BLOB SUB_TYPE TEXT NULL,
+ poll_start INTEGER DEFAULT 0 NULL,
+ poll_length INTEGER DEFAULT 0 NULL,
poll_max_options INTEGER DEFAULT 1 NOT NULL,
poll_last_vote INTEGER DEFAULT 0 ,
poll_vote_change INTEGER DEFAULT 0 NOT NULL
@@ -1317,7 +1317,7 @@ CREATE TABLE phpbb_users (
user_type INTEGER DEFAULT 0 NOT NULL,
group_id INTEGER DEFAULT 3 NOT NULL,
user_permissions BLOB SUB_TYPE TEXT,
- user_perm_from INTEGER DEFAULT 0 NOT NULL,
+ user_perm_from INTEGER DEFAULT 0 NULL,
user_ip VARCHAR(40) DEFAULT '' NOT NULL,
user_regdate INTEGER DEFAULT 0 NOT NULL,
username VARCHAR(252) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/mssql_schema.sql b/phpBB/install/schemas/mssql_schema.sql
index debfe8548a..49dc1f22b0 100644
--- a/phpBB/install/schemas/mssql_schema.sql
+++ b/phpBB/install/schemas/mssql_schema.sql
@@ -1943,9 +1943,9 @@ CREATE TABLE [phpbb_topics] (
[topic_moved_id] [int] NOT NULL ,
[topic_bumped] [int] NOT NULL ,
[topic_bumper] [int] NOT NULL ,
- [poll_title] [varchar] (3000) ,
- [poll_start] [int] NOT NULL ,
- [poll_length] [int] NOT NULL ,
+ [poll_title] [varchar] (3000) NULL ,
+ [poll_start] [int] NULL ,
+ [poll_length] [int] NULL ,
[poll_max_options] [int] NOT NULL ,
[poll_last_vote] [int] NULL ,
[poll_vote_change] [int] NOT NULL
@@ -2114,14 +2114,14 @@ CREATE TABLE [phpbb_users] (
[user_type] [int] NOT NULL ,
[group_id] [int] NOT NULL ,
[user_permissions] [text] NULL ,
- [user_perm_from] [int] NOT NULL ,
+ [user_perm_from] [int] NULL ,
[user_ip] [varchar] (40) NOT NULL ,
[user_regdate] [int] NOT NULL ,
[username] [varchar] (255) NOT NULL ,
[user_password] [varchar] (40) NOT NULL ,
[user_passchg] [int] NULL ,
[user_email] [varchar] (100) NOT NULL ,
- [user_email_hash] [int] NOT NULL ,
+ [user_email_hash] [float] NOT NULL ,
[user_birthday] [varchar] (10) NULL ,
[user_lastvisit] [int] NOT NULL ,
[user_lastmark] [int] NOT NULL ,
diff --git a/phpBB/install/schemas/mysql_schema.sql b/phpBB/install/schemas/mysql_schema.sql
index b626ef39e4..b3de43cf50 100644
--- a/phpBB/install/schemas/mysql_schema.sql
+++ b/phpBB/install/schemas/mysql_schema.sql
@@ -817,9 +817,9 @@ CREATE TABLE phpbb_topics (
topic_moved_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
- poll_title text,
- poll_start int(11) DEFAULT '0' NOT NULL,
- poll_length int(11) DEFAULT '0' NOT NULL,
+ poll_title text NULL,
+ poll_start int(11) DEFAULT '0' NULL,
+ poll_length int(11) DEFAULT '0' NULL,
poll_max_options tinyint(4) UNSIGNED DEFAULT '1' NOT NULL,
poll_last_vote int(11) UNSIGNED DEFAULT '0',
poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
@@ -874,7 +874,7 @@ CREATE TABLE phpbb_users (
user_type tinyint(1) DEFAULT '0' NOT NULL,
group_id mediumint(8) DEFAULT '3' NOT NULL,
user_permissions text NULL,
- user_perm_from mediumint(8) DEFAULT '0' NOT NULL,
+ user_perm_from mediumint(8) DEFAULT '0' NULL,
user_ip varchar(40) DEFAULT '' NOT NULL,
user_regdate int(11) DEFAULT '0' NOT NULL,
username varchar(255) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql
index 16daf340b5..7aea30d6da 100644
--- a/phpBB/install/schemas/oracle_schema.sql
+++ b/phpBB/install/schemas/oracle_schema.sql
@@ -1609,9 +1609,9 @@ CREATE TABLE phpbb_topics (
topic_moved_id number(8) DEFAULT '0' NOT NULL,
topic_bumped number(1) DEFAULT '0' NOT NULL,
topic_bumper number(8) DEFAULT '0' NOT NULL,
- poll_title varchar2(3000),
- poll_start number(11) DEFAULT '0' NOT NULL,
- poll_length number(11) DEFAULT '0' NOT NULL,
+ poll_title varchar2(3000) NULL,
+ poll_start number(11) DEFAULT '0' NULL,
+ poll_length number(11) DEFAULT '0' NULL,
poll_max_options number(4) DEFAULT '1' NOT NULL,
poll_last_vote number(11) DEFAULT '0',
poll_vote_change number(1) DEFAULT '0' NOT NULL,
@@ -1715,7 +1715,7 @@ CREATE TABLE phpbb_users (
user_type number(1) DEFAULT '0' NOT NULL,
group_id number(8) DEFAULT '3' NOT NULL,
user_permissions clob NULL,
- user_perm_from number(8) DEFAULT '0' NOT NULL,
+ user_perm_from number(8) DEFAULT '0' NULL,
user_ip varchar2(40) DEFAULT '' NOT NULL,
user_regdate number(11) DEFAULT '0' NOT NULL,
username varchar2(255) DEFAULT '' NOT NULL,
diff --git a/phpBB/install/schemas/postgres_schema.sql b/phpBB/install/schemas/postgres_schema.sql
index c979573ca9..7191e442eb 100644
--- a/phpBB/install/schemas/postgres_schema.sql
+++ b/phpBB/install/schemas/postgres_schema.sql
@@ -1197,9 +1197,9 @@ CREATE TABLE phpbb_topics (
topic_moved_id INT4 DEFAULT '0' NOT NULL,
topic_bumped INT2 DEFAULT '0' NOT NULL,
topic_bumper INT4 DEFAULT '0' NOT NULL,
- poll_title varchar(3000),
- poll_start INT4 DEFAULT '0' NOT NULL,
- poll_length INT4 DEFAULT '0' NOT NULL,
+ poll_title varchar(3000) NULL,
+ poll_start INT4 DEFAULT '0' NULL,
+ poll_length INT4 DEFAULT '0' NULL,
poll_max_options INT2 DEFAULT '1' NOT NULL,
poll_last_vote INT4 DEFAULT '0',
poll_vote_change INT2 DEFAULT '0' NOT NULL,
@@ -1291,7 +1291,7 @@ CREATE TABLE phpbb_users (
user_type INT2 DEFAULT '0' NOT NULL,
group_id INT4 DEFAULT '3' NOT NULL,
user_permissions TEXT NULL,
- user_perm_from INT4 DEFAULT '0' NOT NULL,
+ user_perm_from INT4 DEFAULT '0' NULL,
user_ip varchar(40) DEFAULT '' NOT NULL,
user_regdate INT4 DEFAULT '0' NOT NULL,
username varchar_ci,
diff --git a/phpBB/install/schemas/sqlite_schema.sql b/phpBB/install/schemas/sqlite_schema.sql
index f9f458ad13..32808cf5e5 100644
--- a/phpBB/install/schemas/sqlite_schema.sql
+++ b/phpBB/install/schemas/sqlite_schema.sql
@@ -873,9 +873,9 @@ CREATE TABLE phpbb_topics (
topic_moved_id mediumint(8) NOT NULL DEFAULT '0',
topic_bumped tinyint(1) NOT NULL DEFAULT '0',
topic_bumper mediumint(8) NOT NULL DEFAULT '0',
- poll_title text(65535),
- poll_start int(11) NOT NULL DEFAULT '0',
- poll_length int(11) NOT NULL DEFAULT '0',
+ poll_title text(65535) NULL,
+ poll_start int(11) NULL DEFAULT '0',
+ poll_length int(11) NULL DEFAULT '0',
poll_max_options tinyint(4) NOT NULL DEFAULT '1',
poll_last_vote int(11) DEFAULT '0',
poll_vote_change tinyint(1) NOT NULL DEFAULT '0'
generated by cgit v1.2.1 (git 2.21.0) at 2026-01-04 01:40:07 +0000