Ignore:
Timestamp:
Oct 7, 2012, 8:37:15 PM (12 years ago)
Author:
chronos
Message:
  • Upraveno: Optimalizace kontroly oprávnění operací.
  • Upraveno: Načítání skupin odkazů na hlavní stránce.
Location:
trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk

    • Property svn:ignore

      •  

        old new  
        66postfixadmin
        77backup
         8.project
         9.buildpath
         10.settings

  • trunk/sql/updates/410.sql

    r410 r415  
    99
    1010ALTER TABLE `UserCustomerRel`
    11   ADD CONSTRAINT `usercustomerrel_ibfk_2` FOREIGN KEY (`User`) REFERENCES `user` (`Id`),
    12   ADD CONSTRAINT `usercustomerrel_ibfk_1` FOREIGN KEY (`Customer`) REFERENCES `member` (`Id`);
     11  ADD CONSTRAINT `usercustomerrel_ibfk_2` FOREIGN KEY (`User`) REFERENCES `User` (`Id`),
     12  ADD CONSTRAINT `usercustomerrel_ibfk_1` FOREIGN KEY (`Customer`) REFERENCES `Member` (`Id`);
    1313
    1414INSERT INTO `UserCustomerRel` (SELECT NULL as Id, Member as Customer, Id AS User FROM User WHERE Member IS NOT NULL);
Note: See TracChangeset for help on using the changeset viewer.