← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/trusted.sql

  • Committer: William Grant
  • Date: 2011-10-21 08:40:28 UTC
  • mfrom: (7675.1045.874 db-devel)
  • mto: This revision was merged to the branch mainline in revision 14184.
  • Revision ID: william.grant@canonical.com-20111021084028-5pei54i9mskjlrj1
Merge db-stable r11057.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/trusted.sql
1611
1611
        personal_standing_reason, mail_resumption_date,
1612
1612
        mailing_list_auto_subscribe_policy, mailing_list_receive_duplicates,
1613
1613
        visibility, verbose_bugnotifications, account)
1614
 
        SELECT NEW.*;
 
1614
    VALUES (
 
1615
        NEW.id, NEW.displayname, NEW.teamowner, NULL,
 
1616
        NEW.name, NEW.language, NEW.fti, NEW.defaultmembershipperiod,
 
1617
        NEW.defaultrenewalperiod, NEW.subscriptionpolicy,
 
1618
        NEW.merged, NEW.datecreated, NULL, NEW.icon,
 
1619
        NEW.mugshot, NEW.hide_email_addresses, NEW.creation_rationale,
 
1620
        NEW.creation_comment, NEW.registrant, NEW.logo, NEW.renewal_policy,
 
1621
        NEW.personal_standing, NEW.personal_standing_reason,
 
1622
        NEW.mail_resumption_date, NEW.mailing_list_auto_subscribe_policy,
 
1623
        NEW.mailing_list_receive_duplicates, NEW.visibility,
 
1624
        NEW.verbose_bugnotifications, NEW.account);
1615
1625
    RETURN NULL; -- Ignored for AFTER triggers.
1616
1626
END;
1617
1627
$$;
1689
1699
    SET id = NEW.id,
1690
1700
        displayname = NEW.displayname,
1691
1701
        teamowner = NEW.teamowner,
1692
 
        teamdescription = NEW.teamdescription,
 
1702
        teamdescription = NULL,
1693
1703
        name = NEW.name,
1694
1704
        language = NEW.language,
1695
1705
        fti = NEW.fti,
1698
1708
        subscriptionpolicy = NEW.subscriptionpolicy,
1699
1709
        merged = NEW.merged,
1700
1710
        datecreated = NEW.datecreated,
1701
 
        homepage_content = NEW.homepage_content,
 
1711
        homepage_content = NULL,
1702
1712
        icon = NEW.icon,
1703
1713
        mugshot = NEW.mugshot,
1704
1714
        hide_email_addresses = NEW.hide_email_addresses,