Changeset 306 in subversion
- Timestamp:
- Aug 10, 2006 9:10:32 AM (7 years ago)
- Location:
- trunk/roundcubemail
- Files:
-
- 5 edited
-
CHANGELOG (modified) (1 diff)
-
SQL/mysql.initial.sql (modified) (1 diff)
-
SQL/mysql.update.sql (modified) (1 diff)
-
program/steps/addressbook/edit.inc (modified) (2 diffs)
-
program/steps/addressbook/save.inc (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/roundcubemail/CHANGELOG
r305 r306 1 1 CHANGELOG RoundCube Webmail 2 2 --------------------------- 3 4 2006/08/10 (tri) 5 ---------- 6 - Added a few fields to the contact table and made this fields avaiable (Ticket #1332930) 3 7 4 8 2006/08/10 (thomasb) -
trunk/roundcubemail/SQL/mysql.initial.sql
r297 r306 35 35 `name` varchar(128) NOT NULL default '', 36 36 `email` varchar(128) NOT NULL default '', 37 `firstname` varchar(128) NOT NULL default '', 38 `surname` varchar(128) NOT NULL default '', 37 `first_name` varchar(128) NOT NULL default '', 38 `middle_name` varchar(128) NOT NULL default '', 39 `last_name` varchar(128) NOT NULL default '', 40 `edu_title` varchar(128) NOT NULL default '', 41 `addon` varchar(128) NOT NULL default '', 42 `nickname` varchar(128) NOT NULL default '', 43 `company` varchar(128) NOT NULL default '', 44 `organisation` varchar(128) NOT NULL default '', 45 `department` varchar(128) NOT NULL default '', 46 `job_title` varchar(128) NOT NULL default '', 47 `note` varchar(128) NOT NULL default '', 48 `tel_work1_voice` varchar(128) NOT NULL default '', 49 `tel_work2_voice` varchar(128) NOT NULL default '', 50 `tel_home1_voice` varchar(128) NOT NULL default '', 51 `tel_home2_voice` varchar(128) NOT NULL default '', 52 `tel_cell_voice` varchar(128) NOT NULL default '', 53 `tel_car_voice` varchar(128) NOT NULL default '', 54 `tel_pager_voice` varchar(128) NOT NULL default '', 55 `tel_additional` varchar(128) NOT NULL default '', 56 `tel_work_fax` varchar(128) NOT NULL default '', 57 `tel_home_fax` varchar(128) NOT NULL default '', 58 `tel_isdn` varchar(128) NOT NULL default '', 59 `tel_preferred` varchar(128) NOT NULL default '', 60 `tel_telex` varchar(128) NOT NULL default '', 61 `work_street` varchar(128) NOT NULL default '', 62 `work_zip` varchar(128) NOT NULL default '', 63 `work_city` varchar(128) NOT NULL default '', 64 `work_region` varchar(128) NOT NULL default '', 65 `work_country` varchar(128) NOT NULL default '', 66 `home_street` varchar(128) NOT NULL default '', 67 `home_zip` varchar(128) NOT NULL default '', 68 `home_city` varchar(128) NOT NULL default '', 69 `home_region` varchar(128) NOT NULL default '', 70 `home_country` varchar(128) NOT NULL default '', 71 `postal_street` varchar(128) NOT NULL default '', 72 `postal_zip` varchar(128) NOT NULL default '', 73 `postal_city` varchar(128) NOT NULL default '', 74 `postal_region` varchar(128) NOT NULL default '', 75 `postal_country` varchar(128) NOT NULL default '', 76 `url_work` varchar(128) NOT NULL default '', 77 `role` varchar(128) NOT NULL default '', 78 `birthday` varchar(128) NOT NULL default '', 79 `rev` varchar(128) NOT NULL default '', 80 `lang` varchar(128) NOT NULL default '', 39 81 `vcard` text NOT NULL, 40 82 PRIMARY KEY (`contact_id`), -
trunk/roundcubemail/SQL/mysql.update.sql
r142 r306 2 2 -- Updates from version 0.1-20051007 3 3 4 ALTER TABLE `contacts` ADD `name` varchar(128) NOT NULL default ''; 5 ALTER TABLE `contacts` ADD `email` varchar(128) NOT NULL default ''; 6 ALTER TABLE `contacts` ADD `first_name` varchar(128) NOT NULL default ''; 7 ALTER TABLE `contacts` ADD `middle_name` varchar(128) NOT NULL default ''; 8 ALTER TABLE `contacts` ADD `last_name` varchar(128) NOT NULL default ''; 9 ALTER TABLE `contacts` ADD `edu_title` varchar(128) NOT NULL default ''; 10 ALTER TABLE `contacts` ADD `addon` varchar(128) NOT NULL default ''; 11 ALTER TABLE `contacts` ADD `nickname` varchar(128) NOT NULL default ''; 12 ALTER TABLE `contacts` ADD `company` varchar(128) NOT NULL default ''; 13 ALTER TABLE `contacts` ADD `organisation` varchar(128) NOT NULL default ''; 14 ALTER TABLE `contacts` ADD `department` varchar(128) NOT NULL default ''; 15 ALTER TABLE `contacts` ADD `job_title` varchar(128) NOT NULL default ''; 16 ALTER TABLE `contacts` ADD `note` varchar(128) NOT NULL default ''; 17 ALTER TABLE `contacts` ADD `tel_work1_voice` varchar(128) NOT NULL default ''; 18 ALTER TABLE `contacts` ADD `tel_work2_voice` varchar(128) NOT NULL default ''; 19 ALTER TABLE `contacts` ADD `tel_home1_voice` varchar(128) NOT NULL default ''; 20 ALTER TABLE `contacts` ADD `tel_home2_voice` varchar(128) NOT NULL default ''; 21 ALTER TABLE `contacts` ADD `tel_cell_voice` varchar(128) NOT NULL default ''; 22 ALTER TABLE `contacts` ADD `tel_car_voice` varchar(128) NOT NULL default ''; 23 ALTER TABLE `contacts` ADD `tel_pager_voice` varchar(128) NOT NULL default ''; 24 ALTER TABLE `contacts` ADD `tel_additional` varchar(128) NOT NULL default ''; 25 ALTER TABLE `contacts` ADD `tel_work_fax` varchar(128) NOT NULL default ''; 26 ALTER TABLE `contacts` ADD `tel_home_fax` varchar(128) NOT NULL default ''; 27 ALTER TABLE `contacts` ADD `tel_isdn` varchar(128) NOT NULL default ''; 28 ALTER TABLE `contacts` ADD `tel_preferred` varchar(128) NOT NULL default ''; 29 ALTER TABLE `contacts` ADD `tel_telex` varchar(128) NOT NULL default ''; 30 ALTER TABLE `contacts` ADD `work_street` varchar(128) NOT NULL default ''; 31 ALTER TABLE `contacts` ADD `work_zip` varchar(128) NOT NULL default ''; 32 ALTER TABLE `contacts` ADD `work_city` varchar(128) NOT NULL default ''; 33 ALTER TABLE `contacts` ADD `work_region` varchar(128) NOT NULL default ''; 34 ALTER TABLE `contacts` ADD `work_country` varchar(128) NOT NULL default ''; 35 ALTER TABLE `contacts` ADD `home_street` varchar(128) NOT NULL default ''; 36 ALTER TABLE `contacts` ADD `home_zip` varchar(128) NOT NULL default ''; 37 ALTER TABLE `contacts` ADD `home_city` varchar(128) NOT NULL default ''; 38 ALTER TABLE `contacts` ADD `home_region` varchar(128) NOT NULL default ''; 39 ALTER TABLE `contacts` ADD `home_country` varchar(128) NOT NULL default ''; 40 ALTER TABLE `contacts` ADD `postal_street` varchar(128) NOT NULL default ''; 41 ALTER TABLE `contacts` ADD `postal_zip` varchar(128) NOT NULL default ''; 42 ALTER TABLE `contacts` ADD `postal_city` varchar(128) NOT NULL default ''; 43 ALTER TABLE `contacts` ADD `postal_region` varchar(128) NOT NULL default ''; 44 ALTER TABLE `contacts` ADD `postal_country` varchar(128) NOT NULL default ''; 45 ALTER TABLE `contacts` ADD `url_work` varchar(128) NOT NULL default ''; 46 ALTER TABLE `contacts` ADD `role` varchar(128) NOT NULL default ''; 47 ALTER TABLE `contacts` ADD `birthday` varchar(128) NOT NULL default ''; 48 ALTER TABLE `contacts` ADD `rev` varchar(128) NOT NULL default ''; 49 ALTER TABLE `contacts` ADD `lang` varchar(128) NOT NULL default ''; 50 51 -- RoundCube Webmail update script for MySQL databases 52 -- Updates from version 0.1-20051007 4 53 5 54 ALTER TABLE `session` ADD `ip` VARCHAR(15) NOT NULL AFTER changed; -
trunk/roundcubemail/program/steps/addressbook/edit.inc
r88 r306 14 14 +-----------------------------------------------------------------------+ 15 15 | Author: Thomas Bruederli <roundcube@gmail.com> | 16 | Author: Tobias 'tri' Richter <tobias@datenwerkstatt-richter.de | 16 17 +-----------------------------------------------------------------------+ 17 18 … … 66 67 $out = "$form_start<table>\n\n"; 67 68 68 $a_show_cols = array('name', ' firstname', 'surname', 'email');69 $a_show_cols = array('name', 'email', 'first_name', 'middle_name', 'last_name', 'edu_title', 'addon', 'nickname', 'company', 'organisation', 'department', 'job_title', 'note', 'tel_work1_voice', 'tel_work2_voice', 'tel_home1_voice', 'tel_home2_voice', 'tel_cell_voice', 'tel_car_voice', 'tel_pager_voice', 'tel_additional', 'tel_work_fax', 'tel_home_fax', 'tel_isdn', 'tel_preferred', 'tel_telex', 'work_street', 'work_zip', 'work_city', 'work_region', 'work_country', 'home_street', 'home_zip', 'home_city', 'home_region', 'home_country', 'postal_street', 'postal_zip', 'postal_city', 'postal_region', 'postal_country', 'url_work', 'role', 'birthday', 'rev', 'lang'); 69 70 foreach ($a_show_cols as $col) 70 71 { -
trunk/roundcubemail/program/steps/addressbook/save.inc
r159 r306 14 14 +-----------------------------------------------------------------------+ 15 15 | Author: Thomas Bruederli <roundcube@gmail.com> | 16 | Author: Tobias 'tri' Richter <tobias@datenwerkstatt-richter.de> | 16 17 +-----------------------------------------------------------------------+ 17 18 … … 29 30 30 31 // setup some vars we need 31 $a_save_cols = array('name', ' firstname', 'surname', 'email');32 $a_save_cols = array('name', 'email', 'first_name', 'middle_name', 'last_name', 'edu_title', 'addon', 'nickname', 'company', 'organisation', 'department', 'job_title', 'note', 'tel_work1_voice', 'tel_work2_voice', 'tel_home1_voice', 'tel_home2_voice', 'tel_cell_voice', 'tel_car_voice', 'tel_pager_voice', 'tel_additional', 'tel_work_fax', 'tel_home_fax', 'tel_isdn', 'tel_preferred', 'tel_telex', 'work_street', 'work_zip', 'work_city', 'work_region', 'work_country', 'home_street', 'home_zip', 'home_city', 'home_region', 'home_country', 'postal_street', 'postal_zip', 'postal_city', 'postal_region', 'postal_country', 'url_work', 'role', 'birthday', 'rev', 'lang'); 32 33 $contacts_table = get_table_name('contacts'); 33 34
Note: See TracChangeset
for help on using the changeset viewer.
