# Copyright (c) 2003 Juraj Kolesár (koli) <koli@koli.sk>               

# dump of data for database tucniak

USE tucniak;
#TABLE c_company
INSERT INTO c_company (name, idn, txn) 
	VALUES ('Zákazníci', '', '');
INSERT INTO c_company (name, idn, txn) 
	VALUES ('Koli', '123456', '654321');
#TABLE c_person
INSERT INTO c_person (name, surname, nickname) 
	VALUES ('Juraj', 'Kolesár', 'Koli');
INSERT INTO c_person (name, surname, nickname) 
	VALUES ('Stanka', 'Kolesárová', 'xica');
INSERT INTO c_person (name, surname, nickname) 
	VALUES ('Michal', 'Dvořáček', 'Lampa');
INSERT INTO c_person (name, surname, nickname) 
	VALUES ('Peter', 'Ročkai', 'yenar');
INSERT INTO c_person (name, surname, nickname) 
	VALUES ('Ondrej', 'Jombík', 'nepto');
INSERT INTO c_person (name, surname, nickname) 
	VALUES ('Jóžin', 'z Bážin', 'nemto');
INSERT INTO c_person (name, surname, nickname) 
	VALUES ('Jožko', 'Mrkvička', 'alias');
#TABLE list_c_employ
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','1','2','P','owner');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','2','2','P','partner');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','2','1','S','');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','3','1','P','contributor');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','4','1','P','contributor');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','5','1','P','');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','6','1','P','');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','COMPANY','7','1','P','');
#TABLE c_phone
INSERT INTO c_phone (number) 
	VALUES ('0905 423 071');
INSERT INTO c_phone (number) 
	VALUES ('0907 239 529');
INSERT INTO c_phone (number) 
	VALUES ('123456');
INSERT INTO c_phone (number) 
	VALUES ('5423 0714');
#TABLE c_email
INSERT INTO c_email (url) 
	VALUES ('koli@koli.sk');
INSERT INTO c_email (url) 
	VALUES ('xica@koli.sk');
INSERT INTO c_email (url) 
	VALUES ('txiqueteta@yahoo.com');
INSERT INTO c_email (url) 
	VALUES ('padackar@yahoo.com');
INSERT INTO c_email (url) 
	VALUES ('xkolesar@st.fmph.uniba.sk');
INSERT INTO c_email (url) 
	VALUES ('1benediktova@st.fmph.uniba.sk');
INSERT INTO c_email (url) 
	VALUES ('lampa@brutusmud.cz');
#TABLE lists_c
#PHONES
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','PHONE','1','1','P','mobil');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','PHONE','1','2','S','mobil zeny');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','PHONE','2','2','P','mobil');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','PHONE','1','3','S','pevna blbost');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','PHONE','7','4','P','pevna linka');
#EMAILS
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ("PERSON",'EMAIL','1','1','P','standard');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','EMAIL','2','2','P','');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','EMAIL','2','3','S','web mail');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','EMAIL','1','4','S','web mail');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','EMAIL','1','5','S','škola');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','EMAIL','2','6','S','škola');
INSERT INTO lists_c (c_table, c_contact, fk_table, fk_contact, priority, note) 
	VALUES ('PERSON','EMAIL','3','7','S','all day');