GD SMTP
Материал из GedeminWiki
CREATE TABLE gd_smtp ( id dintkey, /* первичный ключ */ name dname, /* имя */ description dtext180, /* описание */ email dname, /* адрес электронной почты */ login dname, /* логин */ passw VARCHAR(256) NOT NULL, /* пароль */ ipsec dtext8, /* протокол безопасности SSLV2, SSLV23, SSLV3, TLSV1 */ timeout dinteger_notnull DEFAULT -1, server dtext80 NOT NULL, /* SMTP Sever */ port dinteger_notnull DEFAULT 25, /* SMTP Port */ principal dboolean_notnull, /* сервер по-умолчанию */ creatorkey dforeignkey, creationdate dcreationdate, editorkey dforeignkey, editiondate deditiondate, afull dsecurity, achag dsecurity, aview dsecurity, disabled ddisabled, CONSTRAINT gd_pk_smtp PRIMARY KEY (id), CONSTRAINT gd_smtp_fk_ck FOREIGN KEY (creatorkey) REFERENCES gd_contact (id) ON UPDATE CASCADE, CONSTRAINT gd_smtp_fk_ek FOREIGN KEY (editorkey) REFERENCES gd_contact (id) ON UPDATE CASCADE, CONSTRAINT gd_smtp_chk_timeout CHECK (timeout >= -1), CONSTRAINT gd_smtp_chk_ipsec CHECK(ipsec IN ('SSLV2', 'SSLV23', 'SSLV3', 'TLSV1')), CONSTRAINT gd_smtp_chk_server CHECK (server > ), CONSTRAINT gd_smtp_chk_port CHECK (port > 0 AND port < 65536) )