PageRenderTime 40ms CodeModel.GetById 13ms RepoModel.GetById 0ms app.codeStats 0ms

/quassel-0.7.3/src/core/SQL/SQLite/17/setup_020_network.sql

#
SQL | 28 lines | 28 code | 0 blank | 0 comment | 0 complexity | 982927888d4022ee93f67ebd56899748 MD5 | raw file
Possible License(s): GPL-2.0, GPL-3.0 
    

  1. CREATE TABLE network (
    2. 

  2.        networkid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    3. 

  3.        userid INTEGER NOT NULL,
    4. 

  4.        networkname TEXT NOT NULL,
    5. 

  5.        identityid INTEGER NOT NULL DEFAULT 1,
    6. 

  6.        encodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
    7. 

  7.        decodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
    8. 

  8.        servercodec TEXT NOT NULL DEFAULT "",
    9. 

  9.        userandomserver INTEGER NOT NULL DEFAULT 0, -- BOOL
    10. 

  10.        perform TEXT,
    11. 

  11.        useautoidentify INTEGER NOT NULL DEFAULT 0, -- BOOL
    12. 

  12.        autoidentifyservice TEXT,
    13. 

  13.        autoidentifypassword TEXT,
    14. 

  14.        usesasl INTEGER NOT NULL DEFAULT 0, -- BOOL
    15. 

  15.        saslaccount TEXT,
    16. 

  16.        saslpassword TEXT,
    17. 

  17.        useautoreconnect INTEGER NOT NULL DEFAULT 0, -- BOOL
    18. 

  18.        autoreconnectinterval INTEGER NOT NULL DEFAULT 0,
    19. 

  19.        autoreconnectretries INTEGER NOT NULL DEFAULT 0,
    20. 

  20.        unlimitedconnectretries INTEGER NOT NULL DEFAULT 0, -- BOOL
    21. 

  21.        rejoinchannels INTEGER NOT NULL DEFAULT 0, -- BOOL
    22. 

  22.        connected INTEGER NOT NULL DEFAULT 0, -- BOOL
    23. 

  23.        usermode TEXT, -- user mode to restore
    24. 

  24.        awaymessage TEXT, -- away message to restore (empty if not away)
    25. 

  25.        attachperform TEXT, -- perform list for on attach
    26. 

  26.        detachperform TEXT, -- perform list for on detach
    27. 

  27.        UNIQUE (userid, networkname)
    28. 

  28. )
    29. 

  29.