import sqlite3

def init(conn):
  c = conn.cursor()
  c.execute(
    '''CREATE TABLE IF NOT EXISTS email_log (
         `id` INTEGER PRIMARY KEY AUTOINCREMENT,
         `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         `param` TEXT,
         `email` TEXT,
         `stage` INTEGER DEFAULT 0,
         `sender` TEXT,
         `receiver` TEXT,
         `subject` TEXT,
         `date_raw` TEXT,
         `message_id` TEXT,
         `attachments` INTEGER,
         `in_reply_to` TEXT,
         `in_reply_to_id` INTEGER,
         `references` TEXT
       )''')


import sqlite3

def init(conn):
  c = conn.cursor()
  c.execute(
    '''CREATE TABLE IF NOT EXISTS email_log (
         `id` INTEGER PRIMARY KEY AUTOINCREMENT,
         `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         `param` TEXT,
         `email` TEXT,
         `stage` INTEGER DEFAULT 0,
         `sender` TEXT,
         `receiver` TEXT,
         `subject` TEXT,
         `date_raw` TEXT,
         `message_id` TEXT,
         `attachments` INTEGER,
         `in_reply_to` TEXT,
         `in_reply_to_id` INTEGER,
         `references` TEXT
       )''')

  c.execute(
    '''CREATE INDEX IF NOT EXISTS email_log_idx_message_id
       ON email_log (message_id)
    ''')


Add index to the message_id column
Add index to the message_id column

  import sqlite3
  
  def init(conn):
    c = conn.cursor()
    c.execute(
      '''CREATE TABLE IF NOT EXISTS email_log (
           `id` INTEGER PRIMARY KEY AUTOINCREMENT,
           `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
           `param` TEXT,
           `email` TEXT,
           `stage` INTEGER DEFAULT 0,
           `sender` TEXT,
           `receiver` TEXT,
           `subject` TEXT,
           `date_raw` TEXT,
           `message_id` TEXT,
           `attachments` INTEGER,
           `in_reply_to` TEXT,
           `in_reply_to_id` INTEGER,
           `references` TEXT
         )''')
  
+   c.execute(
+     '''CREATE INDEX IF NOT EXISTS email_log_idx_message_id
+        ON email_log (message_id)
+     ''')
  
+ 
Add index to the message_id column
## Code Before:
import sqlite3

def init(conn):
  c = conn.cursor()
  c.execute(
    '''CREATE TABLE IF NOT EXISTS email_log (
         `id` INTEGER PRIMARY KEY AUTOINCREMENT,
         `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         `param` TEXT,
         `email` TEXT,
         `stage` INTEGER DEFAULT 0,
         `sender` TEXT,
         `receiver` TEXT,
         `subject` TEXT,
         `date_raw` TEXT,
         `message_id` TEXT,
         `attachments` INTEGER,
         `in_reply_to` TEXT,
         `in_reply_to_id` INTEGER,
         `references` TEXT
       )''')


## Instruction:
Add index to the message_id column
## Code After:
import sqlite3

def init(conn):
  c = conn.cursor()
  c.execute(
    '''CREATE TABLE IF NOT EXISTS email_log (
         `id` INTEGER PRIMARY KEY AUTOINCREMENT,
         `timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         `param` TEXT,
         `email` TEXT,
         `stage` INTEGER DEFAULT 0,
         `sender` TEXT,
         `receiver` TEXT,
         `subject` TEXT,
         `date_raw` TEXT,
         `message_id` TEXT,
         `attachments` INTEGER,
         `in_reply_to` TEXT,
         `in_reply_to_id` INTEGER,
         `references` TEXT
       )''')

  c.execute(
    '''CREATE INDEX IF NOT EXISTS email_log_idx_message_id
       ON email_log (message_id)
    ''')

