summaryrefslogtreecommitdiffstats
path: root/user_guide/database
diff options
context:
space:
mode:
authorDerek Allard <derek.allard@ellislab.com>2008-04-07 16:01:01 +0200
committerDerek Allard <derek.allard@ellislab.com>2008-04-07 16:01:01 +0200
commit2385d30422b865052bbc6f333e6a189f46215a61 (patch)
tree396a5623d07b711ab1da0f92a61d1276f80d9fce /user_guide/database
parent16629b1cef61db05646839d6789d98ddc5aaf16b (diff)
Added rename_table() into DBForge.
Diffstat (limited to 'user_guide/database')
-rw-r--r--user_guide/database/forge.html11
1 files changed, 8 insertions, 3 deletions
diff --git a/user_guide/database/forge.html b/user_guide/database/forge.html
index f21591c7f..655ab96c1 100644
--- a/user_guide/database/forge.html
+++ b/user_guide/database/forge.html
@@ -71,6 +71,7 @@ Database Forge Class
<li><a href="#add_key">Adding Keys</a></li>
<li><a href="#create_table">Creating a Table</a></li>
<li><a href="#drop_table">Dropping a Table</a></li>
+<li><a href="#rename_table">Renaming a Table</a></li>
<li><a href="#modifying_tables">Modifying a Table</a></li>
</ul>
@@ -168,7 +169,7 @@ already be running, since the forge class relies on it.</p>
<br />
$this-&gt;dbforge-&gt;add_key('blog_name');<br />
// gives KEY (blog_name)</code></p>
-<h2><a name="create_table" id="create_table2"></a>Creating a table</h2>
+<h2><a name="create_table" id="create_table"></a>Creating a table</h2>
<p>After fields and keys have been declared, you can create a new table with</p>
<p><code>$this-&gt;dbforge-&gt;create_table('table_name');<br />
// gives CREATE TABLE table_name</code></p>
@@ -178,8 +179,12 @@ already be running, since the forge class relies on it.</p>
<h2><a name="drop_table" id="drop_table"></a>Dropping a table</h2>
<p>Executes a DROP TABLE sql</p>
<p><code>$this-&gt;dbforge-&gt;drop_table('table_name');<br />
-// gives DROP TABLE IF EXISTS table_name</code></p>
-<h1><a name="modifying_tables" id="drop_table2"></a>Modifying Tables</h1>
+ // gives DROP TABLE IF EXISTS table_name</code></p>
+<h2><a name="rename_table" id="rename_table"></a>Renaming a table</h2>
+<p>Executes a TABLE rename</p>
+<p><code>$this-&gt;dbforge-&gt;rename_table('old_table_name', 'new_table_name');<br />
+ // gives ALTER TABLE old_table_name RENAME TO new_table_name</code></p>
+<h1><a name="modifying_tables" id="modifying_tables"></a>Modifying Tables</h1>
<h2>$this-&gt;dbforge-&gt;add_column()</h2>
<p>The add_column() function is used to modify an existing table. It accepts the same field array as above, and can be used for an unlimited number of additional fields.</p>
<p><code>$fields = array(<br />