Skip to content
Snippets Groups Projects
  1. Jul 28, 2014
  2. Jul 07, 2014
  3. Apr 11, 2014
  4. Apr 02, 2014
  5. Mar 25, 2014
  6. Jan 27, 2014
    • Jared Hancock's avatar
      Add PK to %ticket_email_info.`id` · 7f9415ff
      Jared Hancock authored
      This patch partially reverts the previous database migration patch which
      added a primary key to the table on the `thread_id` column. This column
      cannot be used, because there may be multiple entries for thread_id = 0.
      
      This also allows ticket_collaborator.isactive to be negative, as well as
      adds the database portion of regex support for ticket filters.
      7f9415ff
  7. Jan 18, 2014
    • Jared Hancock's avatar
      Rewrite %file table structure · ba781964
      Jared Hancock authored
      Add `attrs` field for backend state information (multi-part migration,
      multi-part upload, etc). Change `size` to be an integer rather than text
      field. (Storage space will be about the same, but int makes more sense).
      Size the `key` and `signature` for ~512 bits. The base64 encoding allows
      6-bits per char. At 86 chars, we have 516 bits maximum space.
      ba781964
    • Jared Hancock's avatar
      Fixup storage of email attachments · 8259ea0f
      Jared Hancock authored
      Fixes the rewriting of the `key` field in the ticket thread body. The
      storage de-duplication system may replace the `key` value with an existing
      one. The ticket thread system will use the `key` value assigned when the
      file is committed to the database or the existing key of the duplicate file.
      
      Also fixup installation issues with the attachment storage plugin
      architecture
      8259ea0f
    • Jared Hancock's avatar
      Migrate file metadata table · d5305279
      Jared Hancock authored
        * Include a `bk` column to store the storage backend
        * Include a `signature` column which represents a repeatable hash of the
          file contents
        * Rename `hash` to `key` since it isn't a real hash
      d5305279
  8. Jan 17, 2014
  9. Jan 15, 2014
  10. Nov 27, 2013
  11. Nov 14, 2013
  12. Oct 14, 2013
  13. Oct 10, 2013
  14. Oct 09, 2013
    • Jared Hancock's avatar
      Fixup the installer · e055cc21
      Jared Hancock authored
      Fixup several minor bugs concerning initial experience
      e055cc21
    • Jared Hancock's avatar
      Dynamic data for osTicket · 9e75169e
      Jared Hancock authored
      *This is a major redesign / rework of the osTicket base*
      
      This patch drops the concept of static ticket metadata and allows for an
      admin-configurable arbitrary data that is attachable to tickets
      
      The system is architected such that the base osTicket install now comes with
      a "default" form that has fields for subject, name, email, and phone number.
      This form is editable to allow for the addition of arbitrary other fields;
      however, the basic fields must remain in order to be associated with a
      help-topic and attached to a ticket.
      
      This concept can be expanded to allow for arbitrary data associated with
      registered clients or ticket thread items.
      
      Forms are comprised of sections. Sections have a title and instructions
      properties and a list of fields. Fields have various implementations to
      represent different data such as text, long answer, phone number, datetime,
      yes/no, and selections, and are configurable to define the look and feel and
      interpretation of the respective form field.
      
      Dropdown lists are represented as "Dynamic Lists", which are
      admin-configurable lists of items. Dropdowns can be optionally represented
      as Bootstrap typeahead fields.
      
      This also adds the start of a simple ORM which will hopefully be expanded in
      the future to support multiple database platforms. Currently, only MySQL is
      implemented.
      9e75169e
    • Jared Hancock's avatar
      Enable attachments by default · 484d2ef1
      Jared Hancock authored
      484d2ef1
    • Jared Hancock's avatar
      HTML ticket thread, inline images and draft support · 864d3539
      Jared Hancock authored
      Process inline attachments in thread entry and support inline images in
      piped emails
      
      Support inline images across the system, with draft support
      
      Migrate to a single attachment table
          That way we don't need a new table for everything we need to attach an
          inline image to (like a signature, for instance)
      
      Add richtext support for internal notes
      
      Implement images on site pages
      
      * Image paste in Redactor
      * Make non-local images optional
      * Placeholder for non-local images
      * Fix local image download hover
      * Don't re-attach inline images
      864d3539
  15. Aug 20, 2013
  16. Aug 12, 2013
    • Jared Hancock's avatar
      Make default data translatable · 20f3e62a
      Jared Hancock authored
      This is one of the last major hurdles to make osTicket fully translatable.
      With the advent of 1.7.0, database migration is based on the MD5 hash of the
      install SQL file. Therefore, the install SQL script cannot be modified (ie.
      translated) or else the system cannot be migrated, since the MD5 hash will
      no longer match up.
      
      This patch pulls initial data out of the install file so that it can be
      translatable. Eventually the install worksheet can allow a drop-down box of
      the default system language. The default data from that language will be
      loaded into the system.
      20f3e62a
  17. Aug 09, 2013
  18. Jul 11, 2013
  19. Jul 04, 2013
    • Jared Hancock's avatar
      Add start of documentation for database migration · df5d2cbb
      Jared Hancock authored
      Allow `streams.cfg` to be implied as 'core', which will default to only
      upgrading the core osTicket stream.
      
      Use signature to describe snapshots rather than md5
      df5d2cbb
    • Jared Hancock's avatar
      Support multiple update streams · b02778cd
      Jared Hancock authored
      This patch allows the upgrader to upgrade multiple database update
      'streams'. The main stream is renamed to 'core' to reflect changes made
      to the config class. This will significantly ease customizations
      requiring database customizations, and will make plugins requiring
      database changes possible.
      b02778cd
  20. Jul 03, 2013
  21. May 28, 2013
    • Jared Hancock's avatar
      Various bug-fixes for the upgrader · 0e0f6dcb
      Jared Hancock authored
      - timezone_offset was dropped from the config table at 1.7-dpr1
      - upgrader: only apply five patches in one request
      - upgrader: fix readPatchInfo to work correctly
      - session: support migrating from 1.6 (again)
      - config: support migrating from 1.6 (fallback)
      - config: no default for 'isonline' setting
      - config: fix SQL whitespace issue for schema signature fallbacks
      - config: hash 1.6 versions in the schema signature lookup
      - upgrader: fix logging bug in attachment migration
      0e0f6dcb
    • Jared Hancock's avatar
      Federate configuration settings · db81f071
      Jared Hancock authored
      Change the config table from a column-based table to a key-value table
      with namespacing. This allows several parts of osTicket to store their
      respective configurations in the same table without requiring database
      structure updates
      
      'namespace' is reserved in PHP
      db81f071
  22. May 23, 2013
    • Jared Hancock's avatar
      Use ticket default department=0 · 3e206b68
      Jared Hancock authored
      Since the first department id cannot be assumed
      3e206b68
    • Jared Hancock's avatar
      Use database default storage engine · 55e1c8ec
      Jared Hancock authored
      Drop required usage of MyISAM tables, and drop fulltext indexes as they
      are not used in the code currently anyway. Also, use a blob to store
      session data so as not to waste space with UTF-8 encoding. Lastly, fix
      session_id storage to use VARCHAR(255) which is required for versions
      of MySQL < 5.0.3, and use ascii for the storage model for the
      session_id as it will contain simple characters only.
      55e1c8ec
  23. May 22, 2013
    • Jared Hancock's avatar
      Allow osTicket to install on a database cluster · c83248ce
      Jared Hancock authored
      The problem stems from assumed MySQL insert ids. In MySQL clusters, the id
      numbers will not necessarily be consecutive. This patch causes the install
      and upgrade patches to lookup the assumed values for the linked id numbers.
      c83248ce
  24. Feb 14, 2013
  25. Jan 21, 2013
  26. Jan 18, 2013
  27. Dec 17, 2012
  28. Nov 16, 2012
  29. Oct 19, 2012
  30. Oct 02, 2012
Loading