diff options
| author | Mate Bartus <mate.bartus@gmail.com> | 2015-06-30 16:36:34 +0200 |
|---|---|---|
| committer | Mate Bartus <mate.bartus@gmail.com> | 2015-07-08 01:28:10 +0200 |
| commit | 10f6716566fce9d9c38f3dd99419595b2a1cba4c (patch) | |
| tree | 435a7a88bea17219187c271e38f2b07a677223aa /phpBB/install/schemas/oracle_schema.sql | |
| parent | 249345d9cc6d6bff380436d6e05f24918d762c0d (diff) | |
| download | forums-10f6716566fce9d9c38f3dd99419595b2a1cba4c.tar forums-10f6716566fce9d9c38f3dd99419595b2a1cba4c.tar.gz forums-10f6716566fce9d9c38f3dd99419595b2a1cba4c.tar.bz2 forums-10f6716566fce9d9c38f3dd99419595b2a1cba4c.tar.xz forums-10f6716566fce9d9c38f3dd99419595b2a1cba4c.zip | |
[ticket/13740] Restore original install folder
This reverts commit 934e2821f1cef5e2e21ad6d96f7beb45647ed81c.
PHPBB3-13740
Diffstat (limited to 'phpBB/install/schemas/oracle_schema.sql')
| -rw-r--r-- | phpBB/install/schemas/oracle_schema.sql | 37 |
1 files changed, 37 insertions, 0 deletions
diff --git a/phpBB/install/schemas/oracle_schema.sql b/phpBB/install/schemas/oracle_schema.sql new file mode 100644 index 0000000000..2473d31aab --- /dev/null +++ b/phpBB/install/schemas/oracle_schema.sql @@ -0,0 +1,37 @@ +/* + This first section is optional, however its probably the best method + of running phpBB on Oracle. If you already have a tablespace and user created + for phpBB you can leave this section commented out! + + The first set of statements create a phpBB tablespace and a phpBB user, + make sure you change the password of the phpBB user before you run this script!! +*/ + +/* +CREATE TABLESPACE "PHPBB" + LOGGING + DATAFILE 'E:\ORACLE\ORADATA\LOCAL\PHPBB.ora' + SIZE 10M + AUTOEXTEND ON NEXT 10M + MAXSIZE 100M; + +CREATE USER "PHPBB" + PROFILE "DEFAULT" + IDENTIFIED BY "phpbb_password" + DEFAULT TABLESPACE "PHPBB" + QUOTA UNLIMITED ON "PHPBB" + ACCOUNT UNLOCK; + +GRANT ANALYZE ANY TO "PHPBB"; +GRANT CREATE SEQUENCE TO "PHPBB"; +GRANT CREATE SESSION TO "PHPBB"; +GRANT CREATE TABLE TO "PHPBB"; +GRANT CREATE TRIGGER TO "PHPBB"; +GRANT CREATE VIEW TO "PHPBB"; +GRANT "CONNECT" TO "PHPBB"; + +COMMIT; +DISCONNECT; + +CONNECT phpbb/phpbb_password; +*/ |