sqlite> explain create table if not exists fucknuts (fuck int); addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Init 0 2 0 00 Start at 2 1 Halt 0 0 0 00 2 Transaction 0 0 1 0 01 usesStmtJournal=0 3 Goto 0 1 0 00 sqlite> explain create table if not exists fucknuts2 (fucky int); addr opcode p1 p2 p3 p4 p5 comment ---- ------------- ---- ---- ---- ------------- -- ------------- 0 Init 0 30 0 00 Start at 30 1 ReadCookie 0 3 2 00 2 If 3 5 0 00 3 SetCookie 0 2 4 00 4 SetCookie 0 5 1 00 5 CreateTable 0 2 0 00 r[2]=root iDb=0 6 OpenWrite 0 1 0 5 00 root=1 iDb=0 7 NewRowid 0 1 0 00 r[1]=rowid 8 Blob 6 3 0 00 r[3]= (len=6) 9 Insert 0 3 1 08 intkey=r[1] data=r[3] 10 Close 0 0 0 00 11 Close 0 0 0 00 12 Null 0 4 5 00 r[4..5]=NULL 13 OpenWrite 1 1 0 5 00 root=1 iDb=0; sqlite_master 14 Explain 0 0 0 SEARCH TABLE sqlite_master USING INTEGER PRIMARY KEY (rowid=?) 00 15 MustBeInt 1 18 0 00 16 NotExists 1 18 1 00 intkey=r[1]; pk 17 Rowid 1 5 0 00 r[5]=rowid 18 IsNull 5 26 0 00 if r[5]==NULL goto 26 19 String8 0 6 0 table 00 r[6]='table' 20 String8 0 7 0 fucknuts2 00 r[7]='fucknuts2' 21 String8 0 8 0 fucknuts2 00 r[8]='fucknuts2' 22 Copy 2 9 0 00 r[9]=r[2] 23 String8 0 10 0 CREATE TABLE fucknuts2 (fucky int) 00 r[10]='CREATE TABLE fucknuts2 (fucky int)' 24 MakeRecord 6 5 11 BBBDB 00 r[11]=mkrec(r[6..10]) 25 Insert 1 11 5 00 intkey=r[5] data=r[11] 26 Close 1 0 0 00 27 SetCookie 0 1 2 00 28 ParseSchema 0 0 0 tbl_name='fucknuts2' AND type!='trigger' 00 29 Halt 0 0 0 00 30 Transaction 0 1 1 0 01 usesStmtJournal=0 31 TableLock 0 1 1 sqlite_master 00 iDb=0 root=1 write=1 32 Goto 0 1 0 00