Updated: 2022/Sep/29

Please read Privacy Policy. It's for your privacy.

SQLITE_CREATE_INDEX(3)     Library Functions Manual     SQLITE_CREATE_INDEX(3)

NAME
     SQLITE_CREATE_INDEX, SQLITE_CREATE_TABLE, SQLITE_CREATE_TEMP_INDEX,
     SQLITE_CREATE_TEMP_TABLE, SQLITE_CREATE_TEMP_TRIGGER,
     SQLITE_CREATE_TEMP_VIEW, SQLITE_CREATE_TRIGGER, SQLITE_CREATE_VIEW,
     SQLITE_DELETE, SQLITE_DROP_INDEX, SQLITE_DROP_TABLE,
     SQLITE_DROP_TEMP_INDEX, SQLITE_DROP_TEMP_TABLE, SQLITE_DROP_TEMP_TRIGGER,
     SQLITE_DROP_TEMP_VIEW, SQLITE_DROP_TRIGGER, SQLITE_DROP_VIEW,
     SQLITE_INSERT, SQLITE_PRAGMA, SQLITE_READ, SQLITE_SELECT,
     SQLITE_TRANSACTION, SQLITE_UPDATE, SQLITE_ATTACH, SQLITE_DETACH,
     SQLITE_ALTER_TABLE, SQLITE_REINDEX, SQLITE_ANALYZE, SQLITE_CREATE_VTABLE,
     SQLITE_DROP_VTABLE, SQLITE_FUNCTION, SQLITE_SAVEPOINT, SQLITE_COPY,
     SQLITE_RECURSIVE - authorizer action codes

SYNOPSIS
     #include <sqlite3.h>

     #define SQLITE_CREATE_INDEX
     #define SQLITE_CREATE_TABLE
     #define SQLITE_CREATE_TEMP_INDEX
     #define SQLITE_CREATE_TEMP_TABLE
     #define SQLITE_CREATE_TEMP_TRIGGER
     #define SQLITE_CREATE_TEMP_VIEW
     #define SQLITE_CREATE_TRIGGER
     #define SQLITE_CREATE_VIEW
     #define SQLITE_DELETE
     #define SQLITE_DROP_INDEX
     #define SQLITE_DROP_TABLE
     #define SQLITE_DROP_TEMP_INDEX
     #define SQLITE_DROP_TEMP_TABLE
     #define SQLITE_DROP_TEMP_TRIGGER
     #define SQLITE_DROP_TEMP_VIEW
     #define SQLITE_DROP_TRIGGER
     #define SQLITE_DROP_VIEW
     #define SQLITE_INSERT
     #define SQLITE_PRAGMA
     #define SQLITE_READ
     #define SQLITE_SELECT
     #define SQLITE_TRANSACTION
     #define SQLITE_UPDATE
     #define SQLITE_ATTACH
     #define SQLITE_DETACH
     #define SQLITE_ALTER_TABLE
     #define SQLITE_REINDEX
     #define SQLITE_ANALYZE
     #define SQLITE_CREATE_VTABLE
     #define SQLITE_DROP_VTABLE
     #define SQLITE_FUNCTION
     #define SQLITE_SAVEPOINT
     #define SQLITE_COPY
     #define SQLITE_RECURSIVE

DESCRIPTION
     The sqlite3_set_authorizer() interface registers a callback function that
     is invoked to authorize certain SQL statement actions.  The second
     parameter to the callback is an integer code that specifies what action
     is being authorized.  These are the integer action codes that the
     authorizer callback may be passed.

     These action code values signify what kind of operation is to be
     authorized.  The 3rd and 4th parameters to the authorization callback
     function will be parameters or NULL depending on which of these codes is
     used as the second parameter.  The 5th parameter to the authorizer
     callback is the name of the database ("main", "temp", etc.) if
     applicable.  The 6th parameter to the authorizer callback is the name of
     the inner-most trigger or view that is responsible for the access attempt
     or NULL if this access attempt is directly from top-level SQL code.

IMPLEMENTATION NOTES
     These declarations were extracted from the interface documentation at
     line 3234.

     /******************************************* 3rd ************ 4th ***********/
     #define SQLITE_CREATE_INDEX          1   /* Index Name      Table Name      */
     #define SQLITE_CREATE_TABLE          2   /* Table Name      NULL            */
     #define SQLITE_CREATE_TEMP_INDEX     3   /* Index Name      Table Name      */
     #define SQLITE_CREATE_TEMP_TABLE     4   /* Table Name      NULL            */
     #define SQLITE_CREATE_TEMP_TRIGGER   5   /* Trigger Name    Table Name      */
     #define SQLITE_CREATE_TEMP_VIEW      6   /* View Name       NULL            */
     #define SQLITE_CREATE_TRIGGER        7   /* Trigger Name    Table Name      */
     #define SQLITE_CREATE_VIEW           8   /* View Name       NULL            */
     #define SQLITE_DELETE                9   /* Table Name      NULL            */
     #define SQLITE_DROP_INDEX           10   /* Index Name      Table Name      */
     #define SQLITE_DROP_TABLE           11   /* Table Name      NULL            */
     #define SQLITE_DROP_TEMP_INDEX      12   /* Index Name      Table Name      */
     #define SQLITE_DROP_TEMP_TABLE      13   /* Table Name      NULL            */
     #define SQLITE_DROP_TEMP_TRIGGER    14   /* Trigger Name    Table Name      */
     #define SQLITE_DROP_TEMP_VIEW       15   /* View Name       NULL            */
     #define SQLITE_DROP_TRIGGER         16   /* Trigger Name    Table Name      */
     #define SQLITE_DROP_VIEW            17   /* View Name       NULL            */
     #define SQLITE_INSERT               18   /* Table Name      NULL            */
     #define SQLITE_PRAGMA               19   /* Pragma Name     1st arg or NULL */
     #define SQLITE_READ                 20   /* Table Name      Column Name     */
     #define SQLITE_SELECT               21   /* NULL            NULL            */
     #define SQLITE_TRANSACTION          22   /* Operation       NULL            */
     #define SQLITE_UPDATE               23   /* Table Name      Column Name     */
     #define SQLITE_ATTACH               24   /* Filename        NULL            */
     #define SQLITE_DETACH               25   /* Database Name   NULL            */
     #define SQLITE_ALTER_TABLE          26   /* Database Name   Table Name      */
     #define SQLITE_REINDEX              27   /* Index Name      NULL            */
     #define SQLITE_ANALYZE              28   /* Table Name      NULL            */
     #define SQLITE_CREATE_VTABLE        29   /* Table Name      Module Name     */
     #define SQLITE_DROP_VTABLE          30   /* Table Name      Module Name     */
     #define SQLITE_FUNCTION             31   /* NULL            Function Name   */
     #define SQLITE_SAVEPOINT            32   /* Operation       Savepoint Name  */
     #define SQLITE_COPY                  0   /* No longer used */
     #define SQLITE_RECURSIVE            33   /* NULL            NULL            */

SEE ALSO
     sqlite3_set_authorizer(3)

NetBSD 10.99                    August 24, 2023                   NetBSD 10.99