Fossil

Check-in [fd73e79b]
Login

Check-in [fd73e79b]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Typo fix. Moved chat.file to the end of the schema, per forum suggestion.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: fd73e79b8303cc4a425fcd4fa4415774f3cdfda8b2a71883bf7d016c47dd5262
User & Date: stephan 2020-12-26 20:47:44
Context
2020-12-26
20:57
chat: disable line-wrap on the message tabs. Removed an extraneous duplicated style entry. ... (check-in: adc90d82 user: stephan tags: trunk)
20:47
Typo fix. Moved chat.file to the end of the schema, per forum suggestion. ... (check-in: fd73e79b user: stephan tags: trunk)
20:33
Lowercased 'zulu' per chat discussion. ... (check-in: c7a017e1 user: stephan tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/chat.c.
︙︙
165
166
167
168
169
170
171
172
173
174
175
176
177
178

179
180
181
182
183
184
185


/* Definition of repository tables used by chat
*/
static const char zChatSchema1[] =
@ CREATE TABLE repository.chat(
@   msgid INTEGER PRIMARY KEY AUTOINCREMENT,
@   mtime JULIANDAY,       -- Time for this entry - Julianday Zulu
@   lmtime TEXT,           -- Localtime when message originall sent
@   xfrom TEXT,            -- Login of the sender
@   xmsg  TEXT,            -- Raw, unformatted text of the message
@   file  BLOB,            -- Text of the uploaded file, or NULL
@   fname TEXT,            -- Filename of the uploaded file, or NULL
@   fmime TEXT,            -- MIMEType of the upload file, or NULL
@   mdel INT               -- msgid of another message to delete

@ );
;


/*
** Make sure the repository data tables used by chat exist.  Create them
** if they do not.








|


<


|
>








165
166
167
168
169
170
171
172
173
174

175
176
177
178
179
180
181
182
183
184
185


/* Definition of repository tables used by chat
*/
static const char zChatSchema1[] =
@ CREATE TABLE repository.chat(
@   msgid INTEGER PRIMARY KEY AUTOINCREMENT,
@   mtime JULIANDAY,       -- Time for this entry - Julianday Zulu
@   lmtime TEXT,           -- Localtime when message originally sent
@   xfrom TEXT,            -- Login of the sender
@   xmsg  TEXT,            -- Raw, unformatted text of the message

@   fname TEXT,            -- Filename of the uploaded file, or NULL
@   fmime TEXT,            -- MIMEType of the upload file, or NULL
@   mdel INT,              -- msgid of another message to delete
@   file  BLOB             -- Text of the uploaded file, or NULL
@ );
;


/*
** Make sure the repository data tables used by chat exist.  Create them
** if they do not.
︙︙