-- -- Selected TOC Entries: -- \connect - chafar -- -- Data for TOC Entry ID 1 (OID 16559) -- -- Name: gnue_module Type: TABLE DATA Owner: chafar -- -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'gnue_module'; COPY "gnue_module" FROM stdin; GNU Enterprise System Management 00000000000000000000000000000000 gnue Address Management 00000000000000000000000000001000 address \. -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'gnue_module'; -- -- Data for TOC Entry ID 2 (OID 16562) -- -- Name: gnue_class Type: TABLE DATA Owner: chafar -- -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'gnue_class'; COPY "gnue_class" FROM stdin; GNU Enterprise Business Object Module 00000000000000000000000000000010 00000000000000000000000000000000 module GNU Enterprise Business Object Class 00000000000000000000000000000020 00000000000000000000000000000000 class GNU Enterprise Business Object Property 00000000000000000000000000000030 00000000000000000000000000000000 property GNU Enterprise Business Object Procedure 00000000000000000000000000000040 00000000000000000000000000000000 procedure GNU Enterprise User Authentication 00000000000000000000000000000060 00000000000000000000000000000000 useraccess Country 00000000000000000000000000001020 00000000000000000000000000001000 country Person 00000000000000000000000000001010 00000000000000000000000000001000 person \. -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'gnue_class'; -- -- Data for TOC Entry ID 3 (OID 16565) -- -- Name: gnue_property Type: TABLE DATA Owner: chafar -- -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'gnue_property'; COPY "gnue_property" FROM stdin; 00000000000000000000000000000010 Comment 00000000000000000000000000000013 70 00000000000000000000000000000000 comment 0 string 00000000000000000000000000000010 Object ID 00000000000000000000000000000011 0 00000000000000000000000000000000 id 0 id 00000000000000000000000000000010 Name 00000000000000000000000000000012 35 00000000000000000000000000000000 name 0 string 00000000000000000000000000000020 Comment 00000000000000000000000000000024 70 00000000000000000000000000000000 comment 0 string 00000000000000000000000000000020 Object ID 00000000000000000000000000000021 0 00000000000000000000000000000000 id 0 id 00000000000000000000000000000020 Module that defined this class 00000000000000000000000000000022 0 00000000000000000000000000000000 module 0 gnue_module 00000000000000000000000000000020 Classname without modulename 00000000000000000000000000000023 35 00000000000000000000000000000000 name 0 string 00000000000000000000000000000030 Class the property belongs to 00000000000000000000000000000032 0 00000000000000000000000000000000 class 0 gnue_class 00000000000000000000000000000030 Comment 00000000000000000000000000000038 70 00000000000000000000000000000000 comment 0 string 00000000000000000000000000000030 Object ID 00000000000000000000000000000031 0 00000000000000000000000000000000 id 0 id 00000000000000000000000000000030 Lenght of the property 00000000000000000000000000000036 6 00000000000000000000000000000000 length 0 number 00000000000000000000000000000030 Module that defined this property 00000000000000000000000000000033 0 00000000000000000000000000000000 module 0 gnue_module 00000000000000000000000000000030 Propertyname without modulename 00000000000000000000000000000034 35 00000000000000000000000000000000 name 0 string 00000000000000000000000000000030 Scale of numeric data 00000000000000000000000000000037 4 00000000000000000000000000000000 scale 0 number 00000000000000000000000000000030 Property type 00000000000000000000000000000035 35 00000000000000000000000000000000 type 0 string 00000000000000000000000000000040 Class the procedure belongs to 00000000000000000000000000000042 0 00000000000000000000000000000000 class 0 gnue_class 00000000000000000000000000000040 Procedure code 00000000000000000000000000000046 0 00000000000000000000000000000000 code 0 string 00000000000000000000000000000040 Comment 00000000000000000000000000000048 70 00000000000000000000000000000000 comment 0 string 00000000000000000000000000000040 Compiled procedure code 00000000000000000000000000000047 0 00000000000000000000000000000000 compiledcode 0 string 00000000000000000000000000000040 Object ID 00000000000000000000000000000041 0 00000000000000000000000000000000 id 0 id 00000000000000000000000000000040 Procedure language 00000000000000000000000000000045 10 00000000000000000000000000000000 language 0 string 00000000000000000000000000000040 Module that defined this procedure 00000000000000000000000000000043 0 00000000000000000000000000000000 module 0 gnue_module 00000000000000000000000000000040 Procedurename without modulename 00000000000000000000000000000044 35 00000000000000000000000000000000 name 0 string 00000000000000000000000000000060 List of classes with access allowed 00000000000000000000000000000064 100 00000000000000000000000000000000 accesslist 0 string 00000000000000000000000000000060 Object ID 00000000000000000000000000000061 0 00000000000000000000000000000000 id 0 id 00000000000000000000000000000060 Password 00000000000000000000000000000063 70 00000000000000000000000000000000 password 0 string 00000000000000000000000000000060 Username 00000000000000000000000000000062 20 00000000000000000000000000000000 username 0 string 00000000000000000000000000001020 ISO-Country code 00000000000000000000000000001022 2 00000000000000000000000000001000 code 0 string 00000000000000000000000000001020 The name of the country 00000000000000000000000000001023 35 00000000000000000000000000001000 name 0 string 00000000000000000000000000001020 Object ID 00000000000000000000000000001021 0 00000000000000000000000000000000 id 0 id 00000000000000000000000000001010 Birthday 00000000000000000000000000001019 0 00000000000000000000000000001000 born 0 date 00000000000000000000000000001010 Number of children 00000000000000000000000000001017 2 00000000000000000000000000001000 children 0 number 00000000000000000000000000001010 City where the person lives 00000000000000000000000000001015 35 00000000000000000000000000001000 city 0 string 00000000000000000000000000001010 Country where the person lives 00000000000000000000000000001016 32 00000000000000000000000000001000 country 0 address_country 00000000000000000000000000001010 Whether the person is human or not 0000000000000000000000000000101C 0 00000000000000000000000000001000 human 0 boolean 00000000000000000000000000001010 Date and time of the last meeting 0000000000000000000000000000101B 0 00000000000000000000000000001000 lastmeeting 0 datetime 00000000000000000000000000001010 Preferred time for meetings 0000000000000000000000000000101A 0 00000000000000000000000000001000 meettime 0 time 00000000000000000000000000001010 Name of the person 00000000000000000000000000001012 35 00000000000000000000000000001000 name 0 string 00000000000000000000000000001010 Street where the person lives 00000000000000000000000000001013 35 00000000000000000000000000001000 street 0 string 00000000000000000000000000001010 Weight of the person in kg 00000000000000000000000000001018 4 00000000000000000000000000001000 weight 1 number 00000000000000000000000000001010 Zip code of the city where the person lives 00000000000000000000000000001014 35 00000000000000000000000000001000 zip 0 string 00000000000000000000000000001010 Object ID 00000000000000000000000000001011 0 00000000000000000000000000000000 id 0 id \. -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'gnue_property'; -- -- Data for TOC Entry ID 4 (OID 16568) -- -- Name: gnue_procedure Type: TABLE DATA Owner: chafar -- -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'gnue_procedure'; COPY "gnue_procedure" FROM stdin; 00000000000000000000000000001010 print self.address_name Simple procedure to test Appserver \N 0000000000000000000000000000101F python 00000000000000000000000000001000 show 00000000000000000000000000001010 \nif self.address_name [0] == "(":\n self.address_name = self.address_name [1:len(self.address_name)-1]\nelse:\n self.address_name = "(" + self.address_name + ")"\n Simple procedure to test Appserver \N 0000000000000000000000000000101E python 00000000000000000000000000001000 test \. -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'gnue_procedure'; -- -- Data for TOC Entry ID 5 (OID 16602) -- -- Name: gnue_useraccess Type: TABLE DATA Owner: chafar -- -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'gnue_useraccess'; COPY "gnue_useraccess" FROM stdin; address_person,address_country 00000000000000000000001000000001 test test address_person,address_country,gnue_module,gnue_class,gnue_property,gnue_procedure 00000000000000000000001000000002 secret hacker \. -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'gnue_useraccess'; -- -- Data for TOC Entry ID 6 (OID 16610) -- -- Name: address_country Type: TABLE DATA Owner: chafar -- -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'address_country'; COPY "address_country" FROM stdin; AF Afghanistan 00000000000000000000002000000001 AX Aland Islands 00000000000000000000002000000002 AL Albania 00000000000000000000002000000003 DZ Algeria 00000000000000000000002000000004 AS American Samoa 00000000000000000000002000000005 AD Andorra 00000000000000000000002000000006 AO Angola 00000000000000000000002000000007 AI Anguilla 00000000000000000000002000000008 AQ Antarctica 00000000000000000000002000000009 AG Antigua And Barbuda 0000000000000000000000200000000A AR Argentina 0000000000000000000000200000000B AM Armenia 0000000000000000000000200000000C AW Aruba 0000000000000000000000200000000D AU Australia 0000000000000000000000200000000E AT Austria 0000000000000000000000200000000F AZ Azerbaijan 00000000000000000000002000000010 BS Bahamas 00000000000000000000002000000011 BH Bahrain 00000000000000000000002000000012 BD Bangladesh 00000000000000000000002000000013 BB Barbados 00000000000000000000002000000014 BY Belarus 00000000000000000000002000000015 BE Belgium 00000000000000000000002000000016 BZ Belize 00000000000000000000002000000017 BJ Benin 00000000000000000000002000000018 BM Bermuda 00000000000000000000002000000019 BT Bhutan 0000000000000000000000200000001A BO Bolivia 0000000000000000000000200000001B BA Bosnia And Herzegovina 0000000000000000000000200000001C BW Botswana 0000000000000000000000200000001D BV Bouvet Island 0000000000000000000000200000001E BR Brazil 0000000000000000000000200000001F IO British Indian Ocean Territory 00000000000000000000002000000020 BN Brunei Darussalam 00000000000000000000002000000021 BG Bulgaria 00000000000000000000002000000022 BF Burkina Faso 00000000000000000000002000000023 BI Burundi 00000000000000000000002000000024 KH Cambodia 00000000000000000000002000000025 CM Cameroon 00000000000000000000002000000026 CA Canada 00000000000000000000002000000027 CV Cape Verde 00000000000000000000002000000028 KY Cayman Islands 00000000000000000000002000000029 CF Central African Republic 0000000000000000000000200000002A TD Chad 0000000000000000000000200000002B CL Chile 0000000000000000000000200000002C CN China 0000000000000000000000200000002D CX Christmas Island 0000000000000000000000200000002E CC Cocos (Keeling) Islands 0000000000000000000000200000002F CO Colombia 00000000000000000000002000000030 KM Comoros 00000000000000000000002000000031 CG Congo 00000000000000000000002000000032 CD Congo, The Democratic Republic Of T 00000000000000000000002000000033 CK Cook Islands 00000000000000000000002000000034 CR Costa Rica 00000000000000000000002000000035 CI C?te D'Ivoire 00000000000000000000002000000036 HR Croatia 00000000000000000000002000000037 CU Cuba 00000000000000000000002000000038 CY Cyprus 00000000000000000000002000000039 CZ Czech Republic 0000000000000000000000200000003A DK Denmark 0000000000000000000000200000003B DJ Djibouti 0000000000000000000000200000003C DM Dominica 0000000000000000000000200000003D DO Dominican Republic 0000000000000000000000200000003E EC Ecuador 0000000000000000000000200000003F EG Egypt 00000000000000000000002000000040 SV El Salvador 00000000000000000000002000000041 GQ Equatorial Guinea 00000000000000000000002000000042 ER Eritrea 00000000000000000000002000000043 EE Estonia 00000000000000000000002000000044 ET Ethiopia 00000000000000000000002000000045 FK Falkland Islands (Malvinas) 00000000000000000000002000000046 FO Faroe Islands 00000000000000000000002000000047 FJ Fiji 00000000000000000000002000000048 FI Finland 00000000000000000000002000000049 FR France 0000000000000000000000200000004A GF French Guiana 0000000000000000000000200000004B PF French Polynesia 0000000000000000000000200000004C TF French Southern Territories 0000000000000000000000200000004D GA Gabon 0000000000000000000000200000004E GM Gambia 0000000000000000000000200000004F GE Georgia 00000000000000000000002000000050 DE Germany 00000000000000000000002000000051 GH Ghana 00000000000000000000002000000052 GI Gibraltar 00000000000000000000002000000053 GR Greece 00000000000000000000002000000054 GL Greenland 00000000000000000000002000000055 GD Grenada 00000000000000000000002000000056 GP Guadeloupe 00000000000000000000002000000057 GU Guam 00000000000000000000002000000058 GT Guatemala 00000000000000000000002000000059 GN Guinea 0000000000000000000000200000005A GW Guinea-Bissau 0000000000000000000000200000005B GY Guyana 0000000000000000000000200000005C HT Haiti 0000000000000000000000200000005D HM Heard Island And Mcdonald Islands 0000000000000000000000200000005E VA Holy See (Vatican City State) 0000000000000000000000200000005F HN Honduras 00000000000000000000002000000060 HK Hong Kong 00000000000000000000002000000061 HU Hungary 00000000000000000000002000000062 IS Iceland 00000000000000000000002000000063 IN India 00000000000000000000002000000064 ID Indonesia 00000000000000000000002000000065 IR Iran, Islamic Republic Of 00000000000000000000002000000066 IQ Iraq 00000000000000000000002000000067 IE Ireland 00000000000000000000002000000068 IL Israel 00000000000000000000002000000069 IT Italy 0000000000000000000000200000006A JM Jamaica 0000000000000000000000200000006B JP Japan 0000000000000000000000200000006C JO Jordan 0000000000000000000000200000006D KZ Kazakhstan 0000000000000000000000200000006E KE Kenya 0000000000000000000000200000006F KI Kiribati 00000000000000000000002000000070 KP Korea, Democratic People's Republic 00000000000000000000002000000071 KR Korea, Republic Of 00000000000000000000002000000072 KW Kuwait 00000000000000000000002000000073 KG Kyrgyzstan 00000000000000000000002000000074 LA Lao People's Democratic Republic 00000000000000000000002000000075 LV Latvia 00000000000000000000002000000076 LB Lebanon 00000000000000000000002000000077 LS Lesotho 00000000000000000000002000000078 LR Liberia 00000000000000000000002000000079 LY Libyan Arab Jamahiriya 0000000000000000000000200000007A LI Liechtenstein 0000000000000000000000200000007B LT Lithuania 0000000000000000000000200000007C LU Luxembourg 0000000000000000000000200000007D MO Macao 0000000000000000000000200000007E MK Macedonia, The Former Yugoslav Repu 0000000000000000000000200000007F MG Madagascar 00000000000000000000002000000080 MW Malawi 00000000000000000000002000000081 MY Malaysia 00000000000000000000002000000082 MV Maldives 00000000000000000000002000000083 ML Mali 00000000000000000000002000000084 MT Malta 00000000000000000000002000000085 MH Marshall Islands 00000000000000000000002000000086 MQ Martinique 00000000000000000000002000000087 MR Mauritania 00000000000000000000002000000088 MU Mauritius 00000000000000000000002000000089 YT Mayotte 0000000000000000000000200000008A MX Mexico 0000000000000000000000200000008B FM Micronesia, Federated States Of 0000000000000000000000200000008C MD Moldova, Republic Of 0000000000000000000000200000008D MC Monaco 0000000000000000000000200000008E MN Mongolia 0000000000000000000000200000008F MS Montserrat 00000000000000000000002000000090 MA Morocco 00000000000000000000002000000091 MZ Mozambique 00000000000000000000002000000092 MM Myanmar 00000000000000000000002000000093 NA Namibia 00000000000000000000002000000094 NR Nauru 00000000000000000000002000000095 NP Nepal 00000000000000000000002000000096 NL Netherlands 00000000000000000000002000000097 AN Netherlands Antilles 00000000000000000000002000000098 NC New Caledonia 00000000000000000000002000000099 NZ New Zealand 0000000000000000000000200000009A NI Nicaragua 0000000000000000000000200000009B NE Niger 0000000000000000000000200000009C NG Nigeria 0000000000000000000000200000009D NU Niue 0000000000000000000000200000009E NF Norfolk Island 0000000000000000000000200000009F MP Northern Mariana Islands 000000000000000000000020000000A0 NO Norway 000000000000000000000020000000A1 OM Oman 000000000000000000000020000000A2 PK Pakistan 000000000000000000000020000000A3 PW Palau 000000000000000000000020000000A4 PS Palestinian Territory, Occupied 000000000000000000000020000000A5 PA Panama 000000000000000000000020000000A6 PG Papua New Guinea 000000000000000000000020000000A7 PY Paraguay 000000000000000000000020000000A8 PE Peru 000000000000000000000020000000A9 PH Philippines 000000000000000000000020000000AA PN Pitcairn 000000000000000000000020000000AB PL Poland 000000000000000000000020000000AC PT Portugal 000000000000000000000020000000AD PR Puerto Rico 000000000000000000000020000000AE QA Qatar 000000000000000000000020000000AF RE R?union 000000000000000000000020000000B0 RO Romania 000000000000000000000020000000B1 RU Russian Federation 000000000000000000000020000000B2 RW Rwanda 000000000000000000000020000000B3 SH Saint Helena 000000000000000000000020000000B4 KN Saint Kitts And Nevis 000000000000000000000020000000B5 LC Saint Lucia 000000000000000000000020000000B6 PM Saint Pierre And Miquelon 000000000000000000000020000000B7 VC Saint Vincent And The Grenadines 000000000000000000000020000000B8 WS Samoa 000000000000000000000020000000B9 SM San Marino 000000000000000000000020000000BA ST Sao Tome And Principe 000000000000000000000020000000BB SA Saudi Arabia 000000000000000000000020000000BC SN Senegal 000000000000000000000020000000BD CS Serbia And Montenegro 000000000000000000000020000000BE SC Seychelles 000000000000000000000020000000BF SL Sierra Leone 000000000000000000000020000000C0 SG Singapore 000000000000000000000020000000C1 SK Slovakia 000000000000000000000020000000C2 SI Slovenia 000000000000000000000020000000C3 SB Solomon Islands 000000000000000000000020000000C4 SO Somalia 000000000000000000000020000000C5 ZA South Africa 000000000000000000000020000000C6 GS South Georgia And The South Sandwic 000000000000000000000020000000C7 ES Spain 000000000000000000000020000000C8 LK Sri Lanka 000000000000000000000020000000C9 SD Sudan 000000000000000000000020000000CA SR Suriname 000000000000000000000020000000CB SJ Svalbard And Jan Mayen 000000000000000000000020000000CC SZ Swaziland 000000000000000000000020000000CD SE Sweden 000000000000000000000020000000CE CH Switzerland 000000000000000000000020000000CF SY Syrian Arab Republic 000000000000000000000020000000D0 TW Taiwan, Province Of China 000000000000000000000020000000D1 TJ Tajikistan 000000000000000000000020000000D2 TZ Tanzania, United Republic Of 000000000000000000000020000000D3 TH Thailand 000000000000000000000020000000D4 TL Timor-Leste 000000000000000000000020000000D5 TG Togo 000000000000000000000020000000D6 TK Tokelau 000000000000000000000020000000D7 TO Tonga 000000000000000000000020000000D8 TT Trinidad And Tobago 000000000000000000000020000000D9 TN Tunisia 000000000000000000000020000000DA TR Turkey 000000000000000000000020000000DB TM Turkmenistan 000000000000000000000020000000DC TC Turks And Caicos Islands 000000000000000000000020000000DD TV Tuvalu 000000000000000000000020000000DE UG Uganda 000000000000000000000020000000DF UA Ukraine 000000000000000000000020000000E0 AE United Arab Emirates 000000000000000000000020000000E1 GB United Kingdom 000000000000000000000020000000E2 US United States 000000000000000000000020000000E3 UM United States Minor Outlying Island 000000000000000000000020000000E4 UY Uruguay 000000000000000000000020000000E5 UZ Uzbekistan 000000000000000000000020000000E6 VU Vanuatu 000000000000000000000020000000E7 VE Venezuela 000000000000000000000020000000E8 VN Viet Nam 000000000000000000000020000000E9 VG Virgin Islands, British 000000000000000000000020000000EA VI Virgin Islands, U.S. 000000000000000000000020000000EB WF Wallis And Futuna 000000000000000000000020000000EC EH Western Sahara 000000000000000000000020000000ED YE Yemen 000000000000000000000020000000EE ZM Zambia 000000000000000000000020000000EF ZW Zimbabwe 000000000000000000000020000000F0 \. -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'address_country'; -- -- Data for TOC Entry ID 7 (OID 16613) -- -- Name: address_person Type: TABLE DATA Owner: chafar -- -- Disable triggers UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'address_person'; COPY "address_person" FROM stdin; 2233-03-21 1 Gnutown 00000000000000000000002000000002 t 2270-05-31 18:30:00 19:00:00 James T. Kirk Enterprise Road 17 85.4 2002 00000000000000000000000000001100 2230-01-01 0 Vulcane 00000000000000000000002000000001 f 2270-05-17 08:00:00 06:30:00 Mr. Spock Vulc Lane 1 78.8 4711 00000000000000000000000000001101 \. -- Enable triggers UPDATE pg_class SET reltriggers = (SELECT count(*) FROM pg_trigger where pg_class.oid = tgrelid) WHERE relname = 'address_person';