Context Navigation

source: trunk/expressoMail1_2/setup/tables_update.inc.php @ 1035

Revision 1035, 6.4 KB checked in by rafaelraymundo, 15 years ago (diff)
Ticket #558 - Adicionada funcionalidade de assinatura e criptografia de e-mails.

Line
1	<?php
2	/**************************************************************************\
3	* ExpressoLivre - Setup *
4	* http://www.expressolivre.org *
5	* -------------------------------------------- *
6	* This program is free software; you can redistribute it and/or modify it *
7	* under the terms of the GNU General Public License as published by the *
8	* Free Software Foundation; either version 2 of the License, or (at your *
9	* option) any later version. *
10	\**************************************************************************/
11	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.233'){
12	$test[] = '1.233';
13	function expressoMail1_2_upgrade1_233() {
14	$oProc = $GLOBALS['phpgw_setup']->oProc;
15	$oProc->CreateTable('phpgw_expressomail_contacts',array(
16	'fd' => array(
17	'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
18	'data' => array( 'type' => 'text')
19	),
20	'pk' => array('id_owner'),
21	'fk' => array(),
22	'ix' => array(),
23	'uc' => array()
24	)
25	);
26
27	$oProc->CreateTable('phpgw_certificados',array(
28	'fd' => array(
29	'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
30	'chave_publica' => array( 'type' => 'text'),
31	'expirado' => array('type' => 'bool', 'default' => 'false'),
32	'revogado' => array('type' => 'bool', 'default' => 'false'),
33	'serialnumber' => array('type' => 'int', 'precision' => 8, 'nullable' => false),
34	'authoritykeyidentifier' => array( 'type' => 'text', 'nullable' => false),
35	),
36	'pk' => array('email','serialnumber','authoritykeyidentifier'),
37	'fk' => array(),
38	'ix' => array(),
39	'uc' => array()
40	)
41	);
42
43	$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.334';
44	return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
45	}
46	}
47	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.232'){
48	$test[] = '1.232';
49	function expressoMail1_2_upgrade1_232() {
50	$setup_info['expressoMail1_2']['currentver'] = '1.233';
51	return $setup_info['expressoMail1_2']['currentver'];
52	}
53	}
54	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.231'){
55	$test[] = '1.231';
56	function expressoMail1_2_upgrade1_231() {
57	$setup_info['expressoMail1_2']['currentver'] = '1.232';
58	return $setup_info['expressoMail1_2']['currentver'];
59	}
60	}
61
62	function expressoMail1_2_upgrade1_230() {
63	$oProc = $GLOBALS['phpgw_setup']->oProc;
64	$oProc->CreateTable('phpgw_expressomail_contacts',array(
65	'fd' => array(
66	'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
67	'data' => array( 'type' => 'text')
68	),
69	'pk' => array('id_owner'),
70	'fk' => array(),
71	'ix' => array(),
72	'uc' => array() )
73	);
74	$setup_info['expressoMail1_2']['currentver'] = '1.231';
75	return $setup_info['expressoMail1_2']['currentver'];
76	}
77
78	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.230'){
79	$test[] = '1.230';
80	return expressoMail1_2_upgrade1_230();
81	}
82	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.222'){
83	$test[] = '1.222';
84	function expressoMail1_2_upgrade1_222() {
85	$oProc = $GLOBALS['phpgw_setup']->oProc;
86	$oProc->CreateTable('phpgw_expressomail_contacts',array(
87	'fd' => array(
88	'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
89	'data' => array( 'type' => 'text')
90	),
91	'pk' => array('id_owner'),
92	'fk' => array(),
93	'ix' => array(),
94	'uc' => array()
95	)
96	);
97	$oProc->CreateTable('phpgw_certificados',array(
98	'fd' => array(
99	'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
100	'chave_publica' => array( 'type' => 'text'),
101	'expirado' => array('type' => 'bool', 'default' => 'false')
102	),
103	'pk' => array('email'),
104	'fk' => array(),
105	'ix' => array(),
106	'uc' => array()
107	)
108	);
109	$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.223';
110	return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
111	}
112	}
113	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.2211'){
114	$test[] = '1.2211';
115	function expressoMail1_2_upgrade1_2211() {
116	$oProc = $GLOBALS['phpgw_setup']->oProc;
117	$oProc->CreateTable('phpgw_expressomail_contacts',array(
118	'fd' => array(
119	'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
120	'data' => array( 'type' => 'text')
121	),
122	'pk' => array('id_owner'),
123	'fk' => array(),
124	'ix' => array(),
125	'uc' => array()
126	)
127	);
128	$oProc->CreateTable('phpgw_certificados',array(
129	'fd' => array(
130	'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
131	'chave_publica' => array( 'type' => 'text'),
132	'expirado' => array('type' => 'bool', 'default' => 'false')
133	),
134	'pk' => array('email'),
135	'fk' => array(),
136	'ix' => array(),
137	'uc' => array()
138	)
139	);
140	$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.223';
141	return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
142	}
143	}
144	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.2201'){
145	$test[] = '1.2201';
146	function expressoMail1_2_upgrade1_2201() {return expressoMail1_2_upgrade1_230();}
147	}
148
149	if ($GLOBALS['setup_info']['expressoMail1_2']['currentver'] == '1.2031'){
150	$test[] = '1.2031';
151	function expressoMail1_2_upgrade1_2031() {
152	$oProc = $GLOBALS['phpgw_setup']->oProc;
153	$oProc->CreateTable('phpgw_expressomail_contacts',array(
154	'fd' => array(
155	'id_owner' => array( 'type' => 'int', 'precision' => 8, 'nullable' => false),
156	'data' => array( 'type' => 'text')
157	),
158	'pk' => array('id_owner'),
159	'fk' => array(),
160	'ix' => array(),
161	'uc' => array()
162	)
163	);
164	$oProc->CreateTable('phpgw_certificados',array(
165	'fd' => array(
166	'email' => array( 'type' => 'varchar', 'precision' => 60, 'nullable' => false),
167	'chave_publica' => array( 'type' => 'text'),
168	'expirado' => array('type' => 'bool', 'default' => 'false')
169	),
170	'pk' => array('email'),
171	'fk' => array(),
172	'ix' => array(),
173	'uc' => array()
174	)
175	);
176	$GLOBALS['setup_info']['expressoMail1_2']['currentver'] = '1.223';
177	return $GLOBALS['setup_info']['expressoMail1_2']['currentver'];
178	}
179	}
180	?>

Note: See TracBrowser for help on using the repository browser.

Download in other formats: