diff options
| author | James Atkinson <thefinn@users.sourceforge.net> | 2001-09-14 00:09:28 +0000 |
|---|---|---|
| committer | James Atkinson <thefinn@users.sourceforge.net> | 2001-09-14 00:09:28 +0000 |
| commit | 788cc77be50ad881b5a57e9abe41b6028e840646 (patch) | |
| tree | 3de4286c95616a245a02c977f919e8fd335c8e02 | |
| parent | e175b8eee449f722aa1b330776a8dafeb39b6c47 (diff) | |
| download | forums-788cc77be50ad881b5a57e9abe41b6028e840646.tar forums-788cc77be50ad881b5a57e9abe41b6028e840646.tar.gz forums-788cc77be50ad881b5a57e9abe41b6028e840646.tar.bz2 forums-788cc77be50ad881b5a57e9abe41b6028e840646.tar.xz forums-788cc77be50ad881b5a57e9abe41b6028e840646.zip | |
Updated oracle_schema and added queries to create a table space and a user for phpBB. Makes it a little easier for the novice oracle users out there
git-svn-id: file:///svn/phpbb/trunk@1036 89ea8834-ac86-4346-8a33-228a782c2dd0
| -rwxr-xr-x | phpBB/db/oracle_basic.sql | 2 | ||||
| -rwxr-xr-x | phpBB/db/oracle_schema.sql | 40 | ||||
| -rwxr-xr-x | phpBB/db/oracle_triggers.sql | 4 |
3 files changed, 44 insertions, 2 deletions
diff --git a/phpBB/db/oracle_basic.sql b/phpBB/db/oracle_basic.sql index 400c3f7c05..1424b08065 100755 --- a/phpBB/db/oracle_basic.sql +++ b/phpBB/db/oracle_basic.sql @@ -139,3 +139,5 @@ INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '37', INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '38', ':-|', 'icon_neutral.gif', 'Neutral'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '39', ':neutral:', 'icon_neutral.gif', 'Neutral'); INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( '40', ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green'); + +COMMIT; diff --git a/phpBB/db/oracle_schema.sql b/phpBB/db/oracle_schema.sql index 22ae342a36..94fa2a6b0c 100755 --- a/phpBB/db/oracle_schema.sql +++ b/phpBB/db/oracle_schema.sql @@ -4,6 +4,42 @@ $Id$ */ +/* + 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 befor you run this script!! +*/ + +/* +CREATE TABLESPACE phpbb + DATAFILE '/path/to/oracle/oradata/SID/phpbb01.dbf' + SIZE 10M + AUTOEXTEND ON NEXT 10M + MAXSIZE 100M; + +CREATE USER phpbb + IDENTIFIED BY phpbb_password + DEFAULT TABLESPACE phpbb + TEMPORARY TABLESPACE temp; + +GRANT CREATE SESSION TO phpbb; +GRANT CREATE TABLE TO phpbb; +GRANT CREATE SEQUENCE TO phpbb; +GRANT CREATE TRIGGER TO phpbb; + +ALTER USER phpbb QUOTA unlimited ON phpbb; + +COMMIT; +DISCONNECT; + +CONNECT phpbb/phpbb_password; +*/ + + + CREATE SEQUENCE phpbb_banlist_id_seq increment by 1 start with 2 minvalue 0; CREATE SEQUENCE phpbb_categories_id_seq increment by 1 start with 2 minvalue 0; CREATE SEQUENCE phpbb_config_id_seq increment by 1 start with 2 minvalue 0; @@ -87,7 +123,7 @@ CREATE TABLE phpbb_categories ( -------------------------------------------------------- */ CREATE TABLE phpbb_config ( config_name varchar(255) NOT NULL, - config_value varchar(255) NOT NULL, + config_value varchar(255), CONSTRAINT phpbb_config_pkey PRIMARY KEY (config_name) ); @@ -479,3 +515,5 @@ CREATE TABLE phpbb_words ( replacement varchar(100) DEFAULT '' NOT NULL, CONSTRAINT phpbb_words_pkey PRIMARY KEY (word_id) ); + +COMMIT;
\ No newline at end of file diff --git a/phpBB/db/oracle_triggers.sql b/phpBB/db/oracle_triggers.sql index e3a507882f..f22fa46f66 100755 --- a/phpBB/db/oracle_triggers.sql +++ b/phpBB/db/oracle_triggers.sql @@ -212,4 +212,6 @@ SELECT PHPBB_WORDS_ID_SEQ.NEXTVAL INTO :NEW.word_id FROM DUAL; END; -/
\ No newline at end of file +/ + +COMMIT; |