diff options
| author | msquare <msquare@notrademark.de> | 2017-11-28 15:43:51 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2017-11-28 15:43:51 +0100 |
| commit | 599f2fd264bfc7b1b6826fe206442806e317340f (patch) | |
| tree | 50cf84d7d07d11bd65b45c2c17f37632f6cd8eff /db/anonymize.sql | |
| parent | a5fc5bd0979e8de1fce8a8addd351a6e7bd6aeb8 (diff) | |
| parent | eda7f7788ea8012bd8be46405c56a666c11f3fa5 (diff) | |
Merge pull request #365 from engelsystem/feature-igel-rewrite
Feature igel rewrite
Diffstat (limited to 'db/anonymize.sql')
| -rw-r--r-- | db/anonymize.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/db/anonymize.sql b/db/anonymize.sql new file mode 100644 index 00000000..ba420d79 --- /dev/null +++ b/db/anonymize.sql @@ -0,0 +1,10 @@ +update User set Nick=concat('User',UID), Name=concat('Name',UID), Vorname=concat('Prename',UID), `Alter`=0, Telefon='', DECT='', Handy='', email=concat('engel', UID, '@engelsystem.de'), jabber='', Hometown=''; +update Messages set Text=concat('Message', id); +update News set Betreff=concat('Subject', ID), Text=concat('News', ID); +update NewsComments set Text=concat('Comment', ID); +update Questions set Question=concat('Question', QID), Answer=concat('Answer', QID); +update ShiftEntry set Comment='', freeload_comment=''; +update ShiftTypes set name=concat('Shifttype',id), description='Description'; +update AngelTypes set name=concat('Angeltype',id), description=concat('Description of angeltype',id); +TRUNCATE TABLE LogEntries; + |