Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Person(
- ID INTEGER NOT NULL,
- Vorname VARCHAR CHECK (Vorname NOT GLOB '*[^-~]*' AND Vorname != '') NOT NULL,
- Nachname VARCHAR CHECK (Nachname NOT GLOB '*[^ -~]*' AND Nachname != '') NOT NULL,
- Geburtstag DATE CHECK (strftime('%Y-%m-%d',Geburtstag) == Geburtstag AND strftime('%Y-%m-%d',Geburtstag) IS NOT NULL) NOT NULL,
- Primary key (ID)
- );
- insert into Person
- values (1, 'Peter', 'Pan', '1990-03-03');
- insert into Person
- values (2, 'Donald', 'Duck', '1983-04-25');
- insert into Person
- values (3, 'Mickey', 'Mouse', '1988-05-12');
- insert into Person
- values (4, 'Koenig', 'Mufasa', '1989-08-04');
Advertisement
Add Comment
Please, Sign In to add comment