/[Frey]/branches/no-pager/sql/a3c.sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Contents of /branches/no-pager/sql/a3c.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 132 - (show annotations)
Tue Jul 15 13:46:06 2008 UTC (14 years, 2 months ago) by dpavlin
Original Path: trunk/sql/a3c.sql
File size: 4919 byte(s)
 r149@eeepy:  dpavlin | 2008-07-15 15:46:23 +0200
 example of this schema for SQLite

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;

  ViewVC Help
Powered by ViewVC 1.1.26