27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
** Create a table to represent pending moderation requests, if the
** table does not already exist.
*/
void moderation_table_create(void){
db_multi_exec(
"CREATE TABLE IF NOT EXISTS modreq("
" mreqid INTEGER PRIMARY KEY," /* Unique ID for the request */
" ctime DATE," /* Julian day number */
" user TEXT," /* Name of user submitter */
" ipaddr TEXT," /* IP address of submitter */
" mtype CHAR(1)," /* 't', 'w', or 'a' */
" rid INT," /* Record pending approval */
" objid ANY" /* TicketId or Wiki Name */
");"
);
}
|
>
|
<
|
|
|
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
|
** Create a table to represent pending moderation requests, if the
** table does not already exist.
*/
void moderation_table_create(void){
db_multi_exec(
"CREATE TABLE IF NOT EXISTS modreq("
" mreqid INTEGER PRIMARY KEY," /* Unique ID for the request */
" objid INT UNIQUE," /* Record pending approval */
" ctime DATETIME," /* Julian day number */
" user TEXT," /* Name of user submitter */
" ipaddr TEXT," /* IP address of submitter */
" mtype TEXT," /* 't', 'w', 'at', or 'aw' */
" afile INT," /* File being attached, or NULL */
" aid ANY" /* TicketId or Wiki Name */
");"
);
}
|