Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Always generate the SEARCH box on the website. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
09c7a61e1a07f6cee4c43653017be46d |
User & Date: | drh 2010-08-02 13:05:31.000 |
Context
2010-08-02
| ||
18:03 | Updates to documentation for ATTACH. (check-in: 213b37eef1 user: drh tags: trunk) | |
13:05 | Always generate the SEARCH box on the website. (check-in: 09c7a61e1a user: drh tags: trunk) | |
2010-07-28
| ||
15:04 | Add sqlite3_prepare16_v2() to the list of routines that accept SQL. (check-in: 83cbf2ca08 user: drh tags: trunk) | |
Changes
Changes to pages/lang.in.
︙ | ︙ | |||
154 155 156 157 158 159 160 | is used to add a new column to an existing table. ^The new column is always appended to the end of the list of existing columns. The [column-def] rule defines the characteristics of the new column. ^(The new column may take any of the forms permissable in a [CREATE TABLE] statement, with the following restrictions:)^ <ul> <li>^The column may not have a PRIMARY KEY or UNIQUE constraint.</li> | | | | | 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 | is used to add a new column to an existing table. ^The new column is always appended to the end of the list of existing columns. The [column-def] rule defines the characteristics of the new column. ^(The new column may take any of the forms permissable in a [CREATE TABLE] statement, with the following restrictions:)^ <ul> <li>^The column may not have a PRIMARY KEY or UNIQUE constraint.</li> <li>^The column may not have a default value of CURRENT_TIME, CURRENT_DATE, CURRENT_TIMESTAMP, or an expression in parentheses.</li> <li>^If a NOT NULL constraint is specified, then the column must have a default value other than NULL. <li>^If [foreign key constraints] are [foreign_keys pragma | enabled] and a column with a [foreign-key-clause | REFERENCES clause] is added, the column must have a default value of NULL. </ul> <p>^Note also that when adding a CHECK constraint, the CHECK constraint is not tested against preexisting rows of the table. ^This can result in a table that contains data that is in violation of the CHECK constraint. Future versions of SQLite might change to validate CHECK constraints as they are added.</p> <p> The execution time of the ALTER TABLE command is independent of the amount of data in the table. The ALTER TABLE command runs as quickly on a table with 10 million rows as it does on a table with 1 row. </p> <p>After ADD COLUMN has been run on a database, that database will not be readable by SQLite version 3.1.3 and earlier.</p> |
︙ | ︙ |
Changes to wrap.tcl.
︙ | ︙ | |||
455 456 457 458 459 460 461 | <a href="${path}docs.html">Documentation</a> <a href="${path}download.html">Download</a> <a href="${path}copyright.html">License</a> <a href="${path}news.html">News</a> <a href="${path}support.html">Support</a> </div>} | | | | 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 | <a href="${path}docs.html">Documentation</a> <a href="${path}download.html">Download</a> <a href="${path}copyright.html">License</a> <a href="${path}news.html">News</a> <a href="${path}support.html">Support</a> </div>} if {1} { putsin4 $fd {<script> gMsg = "Search SQLite Docs..." function entersearch() { var q = document.getElementById("q"); if( q.value == gMsg ) { q.value = "" } q.style.color = "black" q.style.fontStyle = "normal" } function leavesearch() { var q = document.getElementById("q"); if( q.value == "" ) { q.value = gMsg q.style.color = "#044a64" q.style.fontStyle = "italic" } } </script>} } if {1} { putsin4 $fd {<td> <div style="padding:0 1em 0px 0;white-space:nowrap"> <form name=f method="GET" action="http://www.sqlite.org/search"> <input id=q name=q type=text onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs..."> <input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex"> </form> |
︙ | ︙ |