devlab-oy/pupesoft — pull request #1308 by jonikanerva (2014-01-16 13:51:42+00:00)
Title: Vaihdetaan muuttaja/laatija -tiedot

luontiaika → created_at
laatija → created_by
muutospvm → updated_at
muuttaja → updated_by

```sql

ALTER TABLE abc_parametrit
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE asiakas
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE asiakasalennus
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE asiakashinta
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE asiakaskommentti
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE asiakkaan_avainsanat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE asn_sanomat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE avainsana
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE budjetti
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE budjetti_asiakas
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE budjetti_myyja
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE budjetti_toimittaja
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE budjetti_tuote
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE dynaaminen_puu
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE etaisyydet
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE extranet_kayttajan_lisatiedot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE factoring
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE hinnasto
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE hyvityssaannot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kalenteri
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kampanja_ehdot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kampanja_palkinnot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kampanjat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kassalipas
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kerayserat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE keraysvyohyke
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kirjoittimet
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kohde
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE korvaavat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE korvaavat_kiellot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kuka
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE kustannuspaikka
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE lahdot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE lasku
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE laskun_lisatiedot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE liitetiedostot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE maksuehto
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE oikeu
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE pakkaamo
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE pakkaus
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE pakkauskoodit
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE pankkiyhteystiedot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE perusalennus
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE puun_alkio
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE rahdinkuljettajat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE rahtikirjanumero
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE rahtimaksut
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE rahtisopimukset
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE sahkoisen_lahetteen_rivit
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE sanakirja
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE sarjanumeroseuranta
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE suuntalavat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE suuntalavat_saapuminen
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE taso
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tilausrivin_lisatiedot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tili
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tilikaudet
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tiliointisaanto
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE todo
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE toimi
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE toimittajaalennus
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE toimittajahinta
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE toimitustapa
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE toimitustavan_lahdot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tullinimike
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tuote
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tuotepaikat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tuoteperhe
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tuotteen_alv
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tuotteen_avainsanat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tuotteen_toimittajat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE tuotteen_toimittajat_tuotenumerot
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE vaihtoehtoiset_verkkolaskutunnukset
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE vak
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE vak_imdg
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE valuu
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE varaston_hyllypaikat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE varaston_tulostimet
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE varastopaikat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE vastaavat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE yhteyshenkilo
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE yhtio
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE yhtion_parametrit
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE yhtion_toimipaikat
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;

ALTER TABLE yriti
change column luontiaika created_at datetime default null,
change column laatija created_by varchar(50) null default null after created_at,
change column muutospvm updated_at datetime null default null after created_by,
change column muuttaja updated_by varchar(50) default null after updated_at;