18 lines
546 B
PHP
18 lines
546 B
PHP
|
//SQL DDL - tblKlijent
|
||
|
|
Lista.Add ('CREATE TABLE IF NOT EXISTS tblKlijent (' +
|
||
|
|
'id INTEGER PRIMARY KEY,' +
|
||
|
|
'Ime TEXT NOT NULL,' +
|
||
|
|
'Prezime TEXT NOT NULL,' +
|
||
|
|
'Adresa TEXT,' +
|
||
|
|
'Email TEXT,' +
|
||
|
|
'Datum DATETIME,' +
|
||
|
|
'Napomena TEXT);');
|
||
|
|
|
||
|
|
//SQL DDL - tblTelefon
|
||
|
|
Lista.Add ('CREATE TABLE tblTelefon (' +
|
||
|
|
'id INTEGER REFERENCES tblKlijent (id) ON DELETE CASCADE ' +
|
||
|
|
'ON UPDATE NO ACTION MATCH SIMPLE DEFERRABLE INITIALLY DEFERRED, ' +
|
||
|
|
'Telefon TEXT);');
|
||
|
|
|
||
|
|
|