Fossil SCM
Update the unversioned file documentation to show the revised schema.
Commit
26c985ce13a6a4d30de3183fbadf183d3cebe278
Parent
9dba92f4a82c78c…
1 file changed
+3
-2
+3
-2
| --- www/unvers.wiki | ||
| +++ www/unvers.wiki | ||
| @@ -66,18 +66,19 @@ | ||
| 66 | 66 | Unversioned content is stored in the repository in the |
| 67 | 67 | "unversioned" table: |
| 68 | 68 | |
| 69 | 69 | <blockquote><pre> |
| 70 | 70 | CREATE TABLE unversioned( |
| 71 | - name TEXT PRIMARY KEY, -- Name of the file | |
| 71 | + uvid INTEGER PRIMARY KEY AUTOINCREMENT, -- unique ID for this file | |
| 72 | + name TEXT UNIQUE, -- Name of the file | |
| 72 | 73 | rcvid INTEGER, -- From whence this file was received |
| 73 | 74 | mtime DATETIME, -- Last change (seconds since 1970) |
| 74 | 75 | hash TEXT, -- SHA1 hash of uncompressed content |
| 75 | 76 | sz INTEGER, -- Size of uncompressed content |
| 76 | 77 | encoding INT, -- 0: plaintext 1: zlib compressed |
| 77 | 78 | content BLOB -- File content |
| 78 | -) WITHOUT ROWID; | |
| 79 | +); | |
| 79 | 80 | </pre></blockquote> |
| 80 | 81 | |
| 81 | 82 | If there are no unversioned files in the repository, then the |
| 82 | 83 | "unversioned" table does not necessarily exist. |
| 83 | 84 | A simple way to purge all unversioned content from a repository |
| 84 | 85 |
| --- www/unvers.wiki | |
| +++ www/unvers.wiki | |
| @@ -66,18 +66,19 @@ | |
| 66 | Unversioned content is stored in the repository in the |
| 67 | "unversioned" table: |
| 68 | |
| 69 | <blockquote><pre> |
| 70 | CREATE TABLE unversioned( |
| 71 | name TEXT PRIMARY KEY, -- Name of the file |
| 72 | rcvid INTEGER, -- From whence this file was received |
| 73 | mtime DATETIME, -- Last change (seconds since 1970) |
| 74 | hash TEXT, -- SHA1 hash of uncompressed content |
| 75 | sz INTEGER, -- Size of uncompressed content |
| 76 | encoding INT, -- 0: plaintext 1: zlib compressed |
| 77 | content BLOB -- File content |
| 78 | ) WITHOUT ROWID; |
| 79 | </pre></blockquote> |
| 80 | |
| 81 | If there are no unversioned files in the repository, then the |
| 82 | "unversioned" table does not necessarily exist. |
| 83 | A simple way to purge all unversioned content from a repository |
| 84 |
| --- www/unvers.wiki | |
| +++ www/unvers.wiki | |
| @@ -66,18 +66,19 @@ | |
| 66 | Unversioned content is stored in the repository in the |
| 67 | "unversioned" table: |
| 68 | |
| 69 | <blockquote><pre> |
| 70 | CREATE TABLE unversioned( |
| 71 | uvid INTEGER PRIMARY KEY AUTOINCREMENT, -- unique ID for this file |
| 72 | name TEXT UNIQUE, -- Name of the file |
| 73 | rcvid INTEGER, -- From whence this file was received |
| 74 | mtime DATETIME, -- Last change (seconds since 1970) |
| 75 | hash TEXT, -- SHA1 hash of uncompressed content |
| 76 | sz INTEGER, -- Size of uncompressed content |
| 77 | encoding INT, -- 0: plaintext 1: zlib compressed |
| 78 | content BLOB -- File content |
| 79 | ); |
| 80 | </pre></blockquote> |
| 81 | |
| 82 | If there are no unversioned files in the repository, then the |
| 83 | "unversioned" table does not necessarily exist. |
| 84 | A simple way to purge all unversioned content from a repository |
| 85 |