Merge branch '3-remove-unused-fields-from-member-records' into 'master'
[memberdb.git] / update.sql
1 /** After refactoring */
2 RENAME TABLE
3     `memberdb_members` TO `members`;
4
5 RENAME TABLE
6     `memberdb_events` TO `events`;
7
8 RENAME TABLE
9     `memberdb_crypto` TO `cryptography`;
10
11 RENAME TABLE
12     `memberdb_earnings` TO `earnings`;
13
14 RENAME TABLE
15     `memberdb_expenses` TO `expenses`;
16
17 /** #3: Remove unused fields from member records */
18 ALTER TABLE `members`
19   DROP `fax`,
20   DROP `phone`,
21   DROP `mobile`,
22   DROP `jabber`,
23   DROP `icq`,
24   DROP `msn`,
25   DROP `aim`,
26   DROP `skype`,
27   DROP `url`,
28   DROP `twitter`;