aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/install/schemas/oracle_schema.sql
Commit message (Collapse)AuthorAgeFilesLines
* - fixed some bugsMeik Sievertsen2006-08-051-381/+508
| | | | | | | | | - made imageset naming more consistent - updated every schema to be consistent and also fixed it (every db should install fine now) - git-svn-id: file:///svn/phpbb/trunk@6237 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixing some bugsMeik Sievertsen2006-08-011-26/+29
| | | | | | | | | - shortening some db columns to meet the requirements - correctly increase/decrease user post counts - fix the topic title length bug(s) git-svn-id: file:///svn/phpbb/trunk@6224 89ea8834-ac86-4346-8a33-228a782c2dd0
* - BBCode helpline is now customizableDavid M2006-08-011-0/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@6223 89ea8834-ac86-4346-8a33-228a782c2dd0
* - removed an accidentaly pasted line [Bug #3227]Nils Adermann2006-07-301-0/+1
| | | | | | | | | | - added missing images to acp_styles [Bug #2623] and added a new image btn_warn - use the style name when exporting a style instead of the non existant path [Bug #2343] - fixed an incorrect call of acp_styles::install_style() [Bug #2325] - always define $search_query in fulltext_mysql [Bug #3476] git-svn-id: file:///svn/phpbb/trunk@6216 89ea8834-ac86-4346-8a33-228a782c2dd0
* OK...David M2006-07-241-7/+7
| | | | | | | | | | | | | | | | | | | | | | | | | This commit should increase the total number of BBCodes from 31 to 2040. Some things to watch out for: Each database likes to deal with binary data in its own, special way. They are, quite frankly, too cool for school. MySQL, MSSQL and Oracle all allow me to send in a default value for their binary column using a hex number. However, MSSQL forces me to send the specific data as a hex number and thus we must CAST it. PostgreSQL allows me to set a binary column, but with a twist. It demands that the default be in _octal_ and its datatype allows somewhere around a gigabyte's worth of BBCodes ( PGSQL users, we shut you down to 2040 for your own good! ) Firebird has no decent mechanism for allowing me to shuttle in binary data so I must force my way in. By virtue of triggers and a UDF, we ram in our default values. SQLite is the most bizarre of them all. They have no mechanism for turning an ASCII code into a ASCII character. Because of this, we have a trigger and a UDF (just like Firebird!) but with a twist! The UDF is defined on the PHP side of things instead of SQL. SQLite also demands that it's data be encoded before being sent off. Other notes: - SQLite installs again :D - Firebird nearly installs again :P - Database backup is not screwed up :P P.S. I hope nothing broke :D git-svn-id: file:///svn/phpbb/trunk@6209 89ea8834-ac86-4346-8a33-228a782c2dd0
* fix the schema files as well as other tiny bugs.Meik Sievertsen2006-07-171-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@6190 89ea8834-ac86-4346-8a33-228a782c2dd0
* hmm... This commit does not increase the number of BBCodes. However, this ↵David M2006-07-171-0/+3
| | | | | | does other things that we need to do first. This splits the usage of allow_* from the BBCode bitfield in forum descriptions, forum rules and group descriptions. This also fixes a tiny, tiny severe issue that nobody found :D I hope it works :P git-svn-id: file:///svn/phpbb/trunk@6188 89ea8834-ac86-4346-8a33-228a782c2dd0
* - renamed the following columns:Meik Sievertsen2006-07-131-1134/+1034
| | | | | | | | | | | | | | | comment -> attach_comment new, forwarded, unread, marked, deleted -> pm_new, pm_forwarded, pm_unread, pm_marked, pm_deleted module_name -> module_basename value -> lang_value - every column is now NOT NULL - every column is now having a DEFAULT value - hopefully mostly consistent across every db schema - untested schemas: sqlite, oracle, firebird git-svn-id: file:///svn/phpbb/trunk@6177 89ea8834-ac86-4346-8a33-228a782c2dd0
* - tackle some usability issuesMeik Sievertsen2006-07-091-3/+15
| | | | | | | | | - fix bug #3147 - added the lock-images made by SHS` - fixed MSSQL errors (adding the correct ESCAPE sequence) git-svn-id: file:///svn/phpbb/trunk@6161 89ea8834-ac86-4346-8a33-228a782c2dd0
* some bugfixesMeik Sievertsen2006-07-061-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@6149 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add additional auth check to the permission roles modulesMeik Sievertsen2006-07-011-1/+1
| | | | | | | | | | | | - added new function to return globally used expressions (get_preg_expression($mode)). This should be very helpful in getting wide spread similar checks (regular expressions) to one place reducing the risk of forgetting to change every location if you fix one. ;) We will add additional ones later, at the moment only the email check is retrieved... - added "active module" var to the module class returning the current active module - changed call to image magick - add administrator to global moderators group by default - extend auth_option column a little bit - other bugfixes git-svn-id: file:///svn/phpbb/trunk@6135 89ea8834-ac86-4346-8a33-228a782c2dd0
* schema! hooray!David M2006-06-211-19/+19
| | | | git-svn-id: file:///svn/phpbb/trunk@6110 89ea8834-ac86-4346-8a33-228a782c2dd0
* what? yeah...David M2006-06-201-1/+1
| | | | | | | | - turns out the backup issue was not a backup issue but a schema issue - let there be color git-svn-id: file:///svn/phpbb/trunk@6105 89ea8834-ac86-4346-8a33-228a782c2dd0
* - removed db cache (might re-appear, but for now we do not see the need for it)Meik Sievertsen2006-06-161-12/+2
| | | | | | | | | | | - all changes to styles/subsilver/template are purely cosmetic (no functional changes) - cosmetics - bugfixes - add index to modules table - use modules ordering code for forums too git-svn-id: file:///svn/phpbb/trunk@6073 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, sorry for this. :/Meik Sievertsen2006-06-071-47/+47
| | | | | | | - cleaned up table names/constants git-svn-id: file:///svn/phpbb/trunk@6021 89ea8834-ac86-4346-8a33-228a782c2dd0
* DB stuff, nothing cool at all unless you use Oracle.David M2006-06-031-165/+165
| | | | git-svn-id: file:///svn/phpbb/trunk@6006 89ea8834-ac86-4346-8a33-228a782c2dd0
* - create forums by defaultMeik Sievertsen2006-06-011-4/+4
| | | | | | | | | | - 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
* - add support for min/max of numerical search backend settingsNils Adermann2006-05-301-1/+1
| | | | | | | | - change word_text maximum length - don't update search settings if nothing was changed git-svn-id: file:///svn/phpbb/trunk@5993 89ea8834-ac86-4346-8a33-228a782c2dd0
* - making user_last_search a NULL column so MSSQL won't hate usNils Adermann2006-05-281-1/+1
| | | | | | | - making ignore_words and synonyms optional for language packs git-svn-id: file:///svn/phpbb/trunk@5983 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added search by author_id to solve problems with looking up posts of users ↵Nils Adermann2006-05-281-0/+1
| | | | | | | | | | | | | | with a name containing wildcards - user based flood control (seperate limits for users and guests) [Bug #1357] - inform the user about ignored words if he receives a "no words specified" message - solve problems with the number of entries per page [Bug #1973] - different height for popup window ["Bug" #1814] - speed improvements for posting and search reindexing in fulltext_native -> use php files for ignore words and synonyms git-svn-id: file:///svn/phpbb/trunk@5981 89ea8834-ac86-4346-8a33-228a782c2dd0
* - remove description from profile fieldsMeik Sievertsen2006-05-271-1/+0
| | | | | | | | - added disclaimer about DEBUG_EXTRA to the ACP (i think this is needed - some idiots might think it is wise to have this enabled on a production board. :) We *may* let it there for the Betas though, but it will be removed during the RC's) - some bugfixes git-svn-id: file:///svn/phpbb/trunk@5973 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Lets make stuff widerDavid M2006-05-201-7/+7
| | | | | | | - Firebird, second class citizen no more! (at least till something else breaks) git-svn-id: file:///svn/phpbb/trunk@5951 89ea8834-ac86-4346-8a33-228a782c2dd0
* a few changes ;-)David M2006-05-191-197/+197
| | | | git-svn-id: file:///svn/phpbb/trunk@5934 89ea8834-ac86-4346-8a33-228a782c2dd0
* some changes before i forget...Meik Sievertsen2006-05-161-12/+12
| | | | git-svn-id: file:///svn/phpbb/trunk@5916 89ea8834-ac86-4346-8a33-228a782c2dd0
* - introduce new function build_url to easily build a valid url from the ↵Meik Sievertsen2006-05-121-49/+49
| | | | | | | | | | | | | | user->page object as well as optionally removing certain keys - changed attachment config to utilize the config build methods - cleaned up posting.php - the submit/delete_post functions are now usable (functions_posting.php) - adjusted header icons (transparency) - a bunch of fixes for mssql - bug fixes git-svn-id: file:///svn/phpbb/trunk@5902 89ea8834-ac86-4346-8a33-228a782c2dd0
* A minor change to the default icon_id, so that there is no icon if someone ↵Graham Eames2006-05-061-1/+1
| | | | | | directly inserts into the db without specifying one git-svn-id: file:///svn/phpbb/trunk@5892 89ea8834-ac86-4346-8a33-228a782c2dd0
* - use varchar2 in favor of clob for some columns...Meik Sievertsen2006-04-261-11/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@5847 89ea8834-ac86-4346-8a33-228a782c2dd0
* - removed group settings from rolesMeik Sievertsen2006-04-221-1/+0
| | | | | | | | | | - added forum icon in front of forums in permissions acp - added trace permissions in permission masks (thanks naderman for writing the first code and for the idea... :)) - some bugfixes - PHP6 fix git-svn-id: file:///svn/phpbb/trunk@5824 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Olympus can now _install_ every database, more work to come on getting the ↵David M2006-04-211-24/+24
| | | | | | rest of the board to work git-svn-id: file:///svn/phpbb/trunk@5811 89ea8834-ac86-4346-8a33-228a782c2dd0
* say hello to role descriptions, role ordering and tooltips on role selectsMeik Sievertsen2006-04-171-0/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@5791 89ea8834-ac86-4346-8a33-228a782c2dd0
* - clean up marklist calls (global function)Meik Sievertsen2006-04-171-0/+1
| | | | | | | | | | - added new feature: test out others permissions (admin permissions will not be copied) - changed attachment processing by directly using the template engine - fixed some attachment related bugs - additional tiny fixes git-svn-id: file:///svn/phpbb/trunk@5790 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixed some bugsMeik Sievertsen2006-04-151-245/+306
| | | | | | | | | | - made sql schemas consistent - added correct sequences and generators to sql schemas - extended some rows to hold more data. This solves issues with multibyte characters and too short topic titles, names, etc. - allow multibyte characters in usernames git-svn-id: file:///svn/phpbb/trunk@5784 89ea8834-ac86-4346-8a33-228a782c2dd0
* extending the encoding fields a bit (11 chars seem to be not enough)Meik Sievertsen2006-04-081-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5769 89ea8834-ac86-4346-8a33-228a782c2dd0
* To all people having their bug status set to fixed: SF pserver CVS access is ↵Meik Sievertsen2006-04-061-0/+1
| | | | | | | | | | | | | | | | | | currently down, therefore the snapshots are still out of date. - fix a bunch of bugs - <!-- $Id$ --> is no longer allowed in template (.html) files - changed layout of private message screens (folders are menu items) - removed unread mode for private messages - added new feature to template engine - "jump out of loop" or "loop another loop within my loop" :D (will be documented within the coding guidelines) - added autologin field to sessions - check session length checks - added add_log statement to sessions to track session valid to invalid changes if ip/browser change depending on config settings (only debug) - added multibyte support for various variables (exception at the moment is usernames which needs some discussion) - hopefully not broke something. :/ git-svn-id: file:///svn/phpbb/trunk@5765 89ea8834-ac86-4346-8a33-228a782c2dd0
* - extended session_page and user_lastpage to hold a maximum of 200 chars ↵Meik Sievertsen2006-03-251-6/+9
| | | | | | | | | | | (instead of 100) - session_page gets truncated to 200 chars - streamlined the process of generating text with bbcode/smilies/urls (forum rules, forum descriptions, group descriptions at the moment) - a bunch of schema changes for the bbcode-enabled text and the session page change (sorry for this) - if decode_message is used there is no need to include functions_posting.php anymore (should fix the search.php bug too) git-svn-id: file:///svn/phpbb/trunk@5709 89ea8834-ac86-4346-8a33-228a782c2dd0
* - a bunch of bugfixes. :PMeik Sievertsen2006-03-211-3/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5678 89ea8834-ac86-4346-8a33-228a782c2dd0
* Warning changes for the other schema filesGraham Eames2006-03-171-1/+29
| | | | git-svn-id: file:///svn/phpbb/trunk@5646 89ea8834-ac86-4346-8a33-228a782c2dd0
* - streamlined reports to consist of the feature set we decided upon (Nils, ↵Meik Sievertsen2006-03-121-4/+6
| | | | | | | | | | | | | | your turn now) - use getenv instead of $_ENV (with $_ENV the case could be wrong) - permission fixes (there was a bug arising with getting permission flags - re-added them and handled roles deletion differently) - implemented max login attempts - changed the expected return parameters for logins/sessions - added acp page for editing report/denial reasons - other fixes here and there git-svn-id: file:///svn/phpbb/trunk@5622 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added "display_on_posting" setting to custom bbcodes (creates a button ↵Meik Sievertsen2006-03-061-2/+4
| | | | | | | | | | | with the bbcode tag) - fixed forum editing and parent id selection - completely removed HTML support (it only creates security problems) - changed cache_moderators() to reflect permission changes git-svn-id: file:///svn/phpbb/trunk@5603 89ea8834-ac86-4346-8a33-228a782c2dd0
* implementing permission rolesMeik Sievertsen2006-02-221-20/+20
| | | | | | | | | | | | | - copy permissions (adding groups) - copy permissions (adding forums) - checking proper groupadd/del settings - added intro page to permissions (to give an overview and quick links) - able to select forums + subforums, single forum, all groups, all users (permission screens) - able to reset permissions (only reset input field) - fix forum deletion bug git-svn-id: file:///svn/phpbb/trunk@5574 89ea8834-ac86-4346-8a33-228a782c2dd0
* my turn to break things... harharharMeik Sievertsen2006-02-121-7/+19
| | | | | | | | | | | | | | | | | - checking in permission settings and permission masks - permission presets and documentation not finished yet - added backtrace function to determine file/line for sql errors - fixed marlist for orphan attachments/groups/logs/users - able to change anonymous user settings/permissions now - re-arranged admin permissions a bit (added some and removed some) - setting forum permissions after creating/editing forum now selects every default group (copy permisson/dropdown to be added for adding forums) - finished user permissions in users acp note: the layout for permissions might change devs: please empty the user_permissions in phpbb_users. Also, first change your auth_options table, remove all cache files and then re-set admin permissions. After having set the admin permissions you can update your modules table (else you will not see the permission tabs) - or empty the auth setting within the modules table to be able to see the permission modules (they rely on newly added permission options) git-svn-id: file:///svn/phpbb/trunk@5553 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Please don't hurt me :pDavid M2006-02-041-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5524 89ea8834-ac86-4346-8a33-228a782c2dd0
* - overhauled search systemNils Adermann2006-01-111-7/+4
| | | | | | | | | | | | | | - updated structure for search backend plugins - better result caching using ACM - search results no longer session restricted => link to them by copying the URL :) - in-topic search - indexing posts now uses search backend plugins - develop/search_fill.php working again - fulltext_mysql not working yet - tiny bugfixes to ACM git-svn-id: file:///svn/phpbb/trunk@5441 89ea8834-ac86-4346-8a33-228a782c2dd0
* Removing an unused table from the schemaGraham Eames2006-01-061-14/+0
| | | | git-svn-id: file:///svn/phpbb/trunk@5433 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some changes to browser checking (was the reason for not working logins)Meik Sievertsen2005-12-281-1/+1
| | | | | | | | - partly working style acp - other tiny changes here and there git-svn-id: file:///svn/phpbb/trunk@5388 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add module_display to modules table (for modes executed but not displayed)Meik Sievertsen2005-11-081-0/+1
| | | | | | | - correctly assign $id variable for modules (name for modules and id for categories) git-svn-id: file:///svn/phpbb/trunk@5295 89ea8834-ac86-4346-8a33-228a782c2dd0
* - updated topic tracking codeMeik Sievertsen2005-10-191-1/+15
| | | | | | | | | - additional changes (mostly bugfixes) - bart, if you update your user table with the user_lastmark field, set it to the user_lastvisit value ;) - and last but not least, introducing some bugs in ucp main front (regarding topic tracking) git-svn-id: file:///svn/phpbb/trunk@5272 89ea8834-ac86-4346-8a33-228a782c2dd0
* - the schema/data changes needed for the new module classMeik Sievertsen2005-10-041-7/+11
| | | | git-svn-id: file:///svn/phpbb/trunk@5253 89ea8834-ac86-4346-8a33-228a782c2dd0
* okok, maybe assigning a default ordering is not that bad. harharMeik Sievertsen2005-10-031-4/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@5251 89ea8834-ac86-4346-8a33-228a782c2dd0
* It's been a while since I wrote schemas for non-mysql DB's ... so don't be ↵Paul S. Owen2005-07-041-0/+29
| | | | | | surprised if they are spectacularly incorrect git-svn-id: file:///svn/phpbb/trunk@5174 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2025-08-05 22:17:24 +0000