PageRenderTime 56ms CodeModel.GetById 18ms RepoModel.GetById 1ms 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. networkid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  3. userid INTEGER NOT NULL,
  4. networkname TEXT NOT NULL,
  5. identityid INTEGER NOT NULL DEFAULT 1,
  6. encodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
  7. decodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
  8. servercodec TEXT NOT NULL DEFAULT "",
  9. userandomserver INTEGER NOT NULL DEFAULT 0, -- BOOL
  10. perform TEXT,
  11. useautoidentify INTEGER NOT NULL DEFAULT 0, -- BOOL
  12. autoidentifyservice TEXT,
  13. autoidentifypassword TEXT,
  14. usesasl INTEGER NOT NULL DEFAULT 0, -- BOOL
  15. saslaccount TEXT,
  16. saslpassword TEXT,
  17. useautoreconnect INTEGER NOT NULL DEFAULT 0, -- BOOL
  18. autoreconnectinterval INTEGER NOT NULL DEFAULT 0,
  19. autoreconnectretries INTEGER NOT NULL DEFAULT 0,
  20. unlimitedconnectretries INTEGER NOT NULL DEFAULT 0, -- BOOL
  21. rejoinchannels INTEGER NOT NULL DEFAULT 0, -- BOOL
  22. connected INTEGER NOT NULL DEFAULT 0, -- BOOL
  23. usermode TEXT, -- user mode to restore
  24. awaymessage TEXT, -- away message to restore (empty if not away)
  25. attachperform TEXT, -- perform list for on attach
  26. detachperform TEXT, -- perform list for on detach
  27. UNIQUE (userid, networkname)
  28. )