1 |
BEGIN TRANSACTION; |
2 |
CREATE TABLE hr_edu_orgs ( |
3 |
id integer primary key autoincrement NOT NULL, |
4 |
hreduorguniquenumber character varying(255) NOT NULL, |
5 |
hreduorgmail character varying(255) NOT NULL, |
6 |
o character varying(255) NOT NULL, |
7 |
hreduorgurl character varying(255) NOT NULL, |
8 |
hreduorgtype character varying(255) NOT NULL, |
9 |
objectclass character varying(255) NOT NULL, |
10 |
businesscategory character varying(255), |
11 |
searchguide character varying(255), |
12 |
internationalisdnnumber character varying(255), |
13 |
telexnumber character varying(255), |
14 |
hreduorgpolicyuri character varying(255), |
15 |
postofficebox character varying(255), |
16 |
telephonenumber character varying(255), |
17 |
destinationindicator character varying(255), |
18 |
facsimiletelephonenumber character varying(255), |
19 |
hreduorgmobile character varying(255), |
20 |
userpassword character varying(255), |
21 |
x121address character varying(255), |
22 |
st character varying(255), |
23 |
postalcode character varying(255), |
24 |
seealso character varying(255), |
25 |
postaladdress character varying(255), |
26 |
physicaldeliveryofficename character varying(255), |
27 |
teletexterminalidentifier character varying(255), |
28 |
l character varying(255), |
29 |
registeredaddress character varying(255), |
30 |
hreduorgmember character varying(255), |
31 |
description character varying(255), |
32 |
preferreddeliverymethod character varying(255), |
33 |
street character varying(255), |
34 |
dc character varying(255) NOT NULL, |
35 |
uidnumber integer NOT NULL, |
36 |
uid character varying(255) NOT NULL, |
37 |
homedirectory character varying(255) NOT NULL, |
38 |
cn character varying(255) NOT NULL, |
39 |
gidnumber integer NOT NULL, |
40 |
gecos character varying(255), |
41 |
loginshell character varying(255) |
42 |
); |
43 |
INSERT INTO "hr_edu_orgs" VALUES(1,'MBUST: 1234','ured@os-test-zg.skole.hr','Testna2 OS <*> podrucna skola u Sesvetama','www.os-test-zg.skole.hr','Osnovna škola','hrEduOrg <*> organization <*> dcObject <*> top <*> posixAccount',NULL,NULL,NULL,NULL,'www.skole.hr/policy.html',NULL,'+385 1 1234-567 <*> +385 1 3456 ',NULL,'+385 1 1234-568','+385 91 1234-567',NULL,NULL,NULL,'10000',NULL,'Kroflinova 17, pp 17',NULL,NULL,'Zagreb',NULL,'SOS',NULL,NULL,'Kroflinofa','os-test-zg',1000,'os-test-zg','/web/sites/os-test-zg.skole.hr','os-test-zg',1000,NULL,'/bin/false'); |
44 |
INSERT INTO "hr_edu_orgs" VALUES(2,'MZOS_SIFRA: 00-000-00','ured@os-tesla-zg.skole.hr','OŠ Nikole Tesle','www.os-tesla-zg.skole.hr','Osnovna škola','hrEduOrg <*> organization <*> dcObject <*> top <*> posixAccount',NULL,NULL,NULL,NULL,'www.skole.hr/policy.html',NULL,'+385 1 388 1561',NULL,NULL,NULL,NULL,NULL,NULL,'HR-10000',NULL,'Matetićeva 67, |
45 |
10000 Zagreb',NULL,NULL,'Zagreb',NULL,NULL,NULL,NULL,'Matetićeva 67','os-tesla-zg',1004,'os-tesla-zg','/web/sites/os-tesla-zg.skole.hr','os-tesla-zg',1004,NULL,'/bin/false'); |
46 |
INSERT INTO "hr_edu_orgs" VALUES(3,'MBUST: 127631 <*> MZOS_SIFRA: YY-YYY-XXX','ured@ss-test-pu.skole.hr','Testna SS Pula','www.ss-test-pu.skole.hr','Srednja škola','hrEduOrg <*> organization <*> dcObject <*> top <*> posixAccount',NULL,NULL,NULL,NULL,'www.skole.hr/policy.html',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HR-52100',NULL,'Puljanska b.b., |
47 |
52100 Pula',NULL,NULL,'Pula',NULL,NULL,NULL,NULL,'Puljanska 5','ss-test-pu',1005,'ss-test-pu','/web/sites/ss-test-pu.skole.hr','ss-test-pu',1005,NULL,'/bin/false'); |
48 |
INSERT INTO "hr_edu_orgs" VALUES(201,'MZOS_SIFRA: 1111','ured@os-test0604-zg.skole.hr','Testna nova 200604 OS Skola','www.os-test0604-zg.skole.hr','Osnovna škola','hrEduOrg <*> organization <*> dcObject <*> top <*> posixAccount',NULL,NULL,NULL,NULL,'www.skole.hr/policy.html',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'HR-99999',NULL,'Uličica 2 |
49 |
HR-99999 Mjestašce',NULL,NULL,'Mjestašce',NULL,NULL,NULL,NULL,'Uličica 2','os-test0604-zg',4131,'os-test0604-zg','/web/sites/os-test0604-zg.skole.hr','os-test0604-zg',4131,NULL,'/bin/false'); |
50 |
INSERT INTO "hr_edu_orgs" VALUES(1276,'MZOS_SIFRA: 01-123-123','ured@test-helpdesk.skole.hr','test skola za Helpdesk','www.test-helpdesk.skole.hr','Osnovna škola','hrEduOrg <*> organization <*> dcObject <*> top <*> posixAccount',NULL,NULL,NULL,NULL,'www.skole.hr/policy.html',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Maroh 5',NULL,NULL,'Zagreb',NULL,NULL,NULL,NULL,NULL,'test-helpdesk',7814,'test-helpdesk','/web/sites/test-helpdesk.skole.hr','test-helpdesk',7814,NULL,'/bin/false'); |
51 |
INSERT INTO "hr_edu_orgs" VALUES(1278,'MZOS_SIFRA: 1111','ured@ss-test0610-zg.skole.hr','Testna nova 200610 SS Skola','www.ss-test0610-zg.skole.hr','Srednja škola','hrEduOrg <*> organization <*> dcObject <*> top <*> posixAccount',NULL,NULL,NULL,NULL,'www.skole.hr/policy.html',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NE POSTOJIM |
52 |
TEST NE DIRAJ |
53 |
Matija',NULL,NULL,'Zagreb',NULL,NULL,NULL,NULL,NULL,'ss-test0610-zg',9731,'ss-test0610-zg','/web/sites/ss-test0610-zg.skole.hr','ss-test0610-zg',9731,NULL,'/bin/false'); |
54 |
COMMIT; |