Fossil SCM
Don't forget (dummy) isaux table column.
Commit
74ff0e1e41a3e7329a0bfaa1ab34c2c115b1f29d
Parent
aca8b6d32a6bf54…
1 file changed
+1
+1
| --- src/schema.c | ||
| +++ src/schema.c | ||
| @@ -238,10 +238,11 @@ | ||
| 238 | 238 | @ pid INTEGER REFERENCES blob, -- File ID in parent manifest |
| 239 | 239 | @ fid INTEGER REFERENCES blob, -- Changed file ID in this manifest |
| 240 | 240 | @ fnid INTEGER REFERENCES filename, -- Name of the file |
| 241 | 241 | @ pfnid INTEGER REFERENCES filename, -- Previous name. 0 if unchanged |
| 242 | 242 | @ mperm INTEGER -- File permissions. 1==exec |
| 243 | +@ isaux BOOLEAN DEFAULT 0 -- TRUE if pmid is the primary (not used yet) | |
| 243 | 244 | @ ); |
| 244 | 245 | @ CREATE INDEX mlink_i1 ON mlink(mid); |
| 245 | 246 | @ CREATE INDEX mlink_i2 ON mlink(fnid); |
| 246 | 247 | @ CREATE INDEX mlink_i3 ON mlink(fid); |
| 247 | 248 | @ CREATE INDEX mlink_i4 ON mlink(pid); |
| 248 | 249 |
| --- src/schema.c | |
| +++ src/schema.c | |
| @@ -238,10 +238,11 @@ | |
| 238 | @ pid INTEGER REFERENCES blob, -- File ID in parent manifest |
| 239 | @ fid INTEGER REFERENCES blob, -- Changed file ID in this manifest |
| 240 | @ fnid INTEGER REFERENCES filename, -- Name of the file |
| 241 | @ pfnid INTEGER REFERENCES filename, -- Previous name. 0 if unchanged |
| 242 | @ mperm INTEGER -- File permissions. 1==exec |
| 243 | @ ); |
| 244 | @ CREATE INDEX mlink_i1 ON mlink(mid); |
| 245 | @ CREATE INDEX mlink_i2 ON mlink(fnid); |
| 246 | @ CREATE INDEX mlink_i3 ON mlink(fid); |
| 247 | @ CREATE INDEX mlink_i4 ON mlink(pid); |
| 248 |
| --- src/schema.c | |
| +++ src/schema.c | |
| @@ -238,10 +238,11 @@ | |
| 238 | @ pid INTEGER REFERENCES blob, -- File ID in parent manifest |
| 239 | @ fid INTEGER REFERENCES blob, -- Changed file ID in this manifest |
| 240 | @ fnid INTEGER REFERENCES filename, -- Name of the file |
| 241 | @ pfnid INTEGER REFERENCES filename, -- Previous name. 0 if unchanged |
| 242 | @ mperm INTEGER -- File permissions. 1==exec |
| 243 | @ isaux BOOLEAN DEFAULT 0 -- TRUE if pmid is the primary (not used yet) |
| 244 | @ ); |
| 245 | @ CREATE INDEX mlink_i1 ON mlink(mid); |
| 246 | @ CREATE INDEX mlink_i2 ON mlink(fnid); |
| 247 | @ CREATE INDEX mlink_i3 ON mlink(fid); |
| 248 | @ CREATE INDEX mlink_i4 ON mlink(pid); |
| 249 |