Details

      Description

      The extension only has a postgres and mysql schema

        Activity

        Hide
        Chen Xiongjie added a comment -

        fixed in trunk rev.285

        Show
        Chen Xiongjie added a comment - fixed in trunk rev.285
        Hide
        Gaetano Giunta added a comment -

        bad naming of some elements (sequences)

        Show
        Gaetano Giunta added a comment - bad naming of some elements (sequences)
        Hide
        Chen Xiongjie added a comment -

        In reply to comment #051224
        @gg,

        What's the standard of sequence? is it S_tablename or SEQ_tablename?

        Show
        Chen Xiongjie added a comment - In reply to comment #051224 @gg, What's the standard of sequence? is it S_tablename or SEQ_tablename?
        Hide
        Gaetano Giunta added a comment -

        In reply to comment #051224

        • miss an index;
        • NUMBER is not the right type for integers, plz use INTEGER;
        • miss WHEN ID IS NULL in triggers
        • plz use correct newlines/whitespace in triggers or they will not be recognized by ezdbschema
        Show
        Gaetano Giunta added a comment - In reply to comment #051224 miss an index; NUMBER is not the right type for integers, plz use INTEGER; miss WHEN ID IS NULL in triggers plz use correct newlines/whitespace in triggers or they will not be recognized by ezdbschema
        Hide
        Gaetano Giunta added a comment - - edited

        In reply to comment #051225
        You can find a good example of valid sql here: http://svn.projects.ez.no/ezoracle/trunk/extension/ezoracle/update/database/ezpublish/4.1/dbupdate-4.0.0-to-4.1.0.sql

        for sequences, given table ezsomething the correct name is s_something

        Show
        Gaetano Giunta added a comment - - edited In reply to comment #051225 You can find a good example of valid sql here: http://svn.projects.ez.no/ezoracle/trunk/extension/ezoracle/update/database/ezpublish/4.1/dbupdate-4.0.0-to-4.1.0.sql for sequences, given table ezsomething the correct name is s_something
        Hide
        Chen Xiongjie added a comment -

        In reply to comment #051227
        Thanks Gaetano,

        It has been committed on r.287

        Chen

        Show
        Chen Xiongjie added a comment - In reply to comment #051227 Thanks Gaetano, It has been committed on r.287 Chen
        Hide
        Chen Xiongjie added a comment -

        script committed. close issue.

        Show
        Chen Xiongjie added a comment - script committed. close issue.
        Hide
        ezrobot added a comment -

        This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

        Show
        ezrobot added a comment - This issue has been automatically closed due to the lack of activity over a long period of time. It is very likely that it is obsolete, but if you think it is still valid, do not hesitate to reopen it and mention why.

          People

          • Assignee:
            Chen Xiongjie
            Reporter:
            Vidar Langseid
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: