Fossil SCM
Typo fix. Moved chat.file to the end of the schema, per forum suggestion.
Commit
fd73e79b8303cc4a425fcd4fa4415774f3cdfda8b2a71883bf7d016c47dd5262
Parent
c7a017e169930e7…
1 file changed
+3
-3
+3
-3
| --- src/chat.c | ||
| +++ src/chat.c | ||
| @@ -167,17 +167,17 @@ | ||
| 167 | 167 | */ |
| 168 | 168 | static const char zChatSchema1[] = |
| 169 | 169 | @ CREATE TABLE repository.chat( |
| 170 | 170 | @ msgid INTEGER PRIMARY KEY AUTOINCREMENT, |
| 171 | 171 | @ mtime JULIANDAY, -- Time for this entry - Julianday Zulu |
| 172 | -@ lmtime TEXT, -- Localtime when message originall sent | |
| 172 | +@ lmtime TEXT, -- Localtime when message originally sent | |
| 173 | 173 | @ xfrom TEXT, -- Login of the sender |
| 174 | 174 | @ xmsg TEXT, -- Raw, unformatted text of the message |
| 175 | -@ file BLOB, -- Text of the uploaded file, or NULL | |
| 176 | 175 | @ fname TEXT, -- Filename of the uploaded file, or NULL |
| 177 | 176 | @ fmime TEXT, -- MIMEType of the upload file, or NULL |
| 178 | -@ mdel INT -- msgid of another message to delete | |
| 177 | +@ mdel INT, -- msgid of another message to delete | |
| 178 | +@ file BLOB -- Text of the uploaded file, or NULL | |
| 179 | 179 | @ ); |
| 180 | 180 | ; |
| 181 | 181 | |
| 182 | 182 | |
| 183 | 183 | /* |
| 184 | 184 |
| --- src/chat.c | |
| +++ src/chat.c | |
| @@ -167,17 +167,17 @@ | |
| 167 | */ |
| 168 | static const char zChatSchema1[] = |
| 169 | @ CREATE TABLE repository.chat( |
| 170 | @ msgid INTEGER PRIMARY KEY AUTOINCREMENT, |
| 171 | @ mtime JULIANDAY, -- Time for this entry - Julianday Zulu |
| 172 | @ lmtime TEXT, -- Localtime when message originall sent |
| 173 | @ xfrom TEXT, -- Login of the sender |
| 174 | @ xmsg TEXT, -- Raw, unformatted text of the message |
| 175 | @ file BLOB, -- Text of the uploaded file, or NULL |
| 176 | @ fname TEXT, -- Filename of the uploaded file, or NULL |
| 177 | @ fmime TEXT, -- MIMEType of the upload file, or NULL |
| 178 | @ mdel INT -- msgid of another message to delete |
| 179 | @ ); |
| 180 | ; |
| 181 | |
| 182 | |
| 183 | /* |
| 184 |
| --- src/chat.c | |
| +++ src/chat.c | |
| @@ -167,17 +167,17 @@ | |
| 167 | */ |
| 168 | static const char zChatSchema1[] = |
| 169 | @ CREATE TABLE repository.chat( |
| 170 | @ msgid INTEGER PRIMARY KEY AUTOINCREMENT, |
| 171 | @ mtime JULIANDAY, -- Time for this entry - Julianday Zulu |
| 172 | @ lmtime TEXT, -- Localtime when message originally sent |
| 173 | @ xfrom TEXT, -- Login of the sender |
| 174 | @ xmsg TEXT, -- Raw, unformatted text of the message |
| 175 | @ fname TEXT, -- Filename of the uploaded file, or NULL |
| 176 | @ fmime TEXT, -- MIMEType of the upload file, or NULL |
| 177 | @ mdel INT, -- msgid of another message to delete |
| 178 | @ file BLOB -- Text of the uploaded file, or NULL |
| 179 | @ ); |
| 180 | ; |
| 181 | |
| 182 | |
| 183 | /* |
| 184 |