Changeset 415 for trunk/sql


Ignore:
Timestamp:
Oct 7, 2012, 8:37:15 PM (13 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:
3 edited

Legend:

Unmodified
Added
Removed

  • trunk

    • Property svn:ignore

      •  

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

  • trunk/sql/updates/409.sql

    r409 r415  
    66CHANGE `pos` `Pos` INT( 11 ) NOT NULL DEFAULT '0',
    77CHANGE `first` `First` INT( 11 ) NOT NULL DEFAULT '0',
    8 CHANGE `last` `Last` INT( 11 ) NOT NULL DEFAULT '0'
     8CHANGE `last` `Last` INT( 11 ) NOT NULL DEFAULT '0';
    99
    1010

  • 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.