telsafilm

Untitled

Feb 23rd, 2019
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. create table Person(
  2. ID INTEGER NOT NULL,
  3. Vorname VARCHAR CHECK (Vorname NOT GLOB '*[^-~]*' AND Vorname != '') NOT NULL,
  4. Nachname VARCHAR CHECK (Nachname NOT GLOB '*[^ -~]*' AND Nachname != '') NOT NULL,
  5. Geburtstag DATE CHECK (strftime('%Y-%m-%d',Geburtstag) == Geburtstag AND strftime('%Y-%m-%d',Geburtstag) IS NOT NULL) NOT NULL,
  6. Primary key (ID)
  7. );
  8.  
  9.  
  10. insert into Person
  11. values (1, 'Peter', 'Pan', '1990-03-03');
  12.  
  13. insert into Person
  14. values (2, 'Donald', 'Duck', '1983-04-25');
  15.  
  16. insert into Person
  17. values (3, 'Mickey', 'Mouse', '1988-05-12');
  18.  
  19. insert into Person
  20. values (4, 'Koenig', 'Mufasa', '1989-08-04');
Advertisement
Add Comment
Please, Sign In to add comment