/* DOMENY SYSTEMU */
/*		  */
/* connect 'C:\HELION\BAZA\BDE\TEST_BDE.GDB' USER 'SYSDBA' password 'masterkey'; */

CREATE DOMAIN D_ROK		AS DECIMAL(4,0) CHECK( VALUE BETWEEN 1990 AND 2020 );
CREATE DOMAIN D_MC		AS DECIMAL(2,0) CHECK( VALUE BETWEEN 1 AND 12 );
CREATE DOMAIN D_SHORTC		AS CHAR(05);
CREATE DOMAIN D_SHORTC10	AS CHAR(10);
CREATE DOMAIN D_MEDIUMC		AS CHAR(25);
CREATE DOMAIN D_LONGC		AS CHAR(50);
CREATE DOMAIN D_NIP		AS CHAR(13);
CREATE DOMAIN D_CYFRA		AS DECIMAL(9,2);
CREATE DOMAIN D_KODP		AS CHAR(06);
CREATE DOMAIN D_BOOLEAN		AS CHAR(1) DEFAULT 'N' CHECK(value in ('T', 'N')) NOT NULL;
CREATE DOMAIN D_PESEL		AS CHAR(11);