view release on metacpan or  search on metacpan

examples/changelog/changelog-002-tables.yml  view on Meta::CPAN

    - name: created_by
      type: uuid
    name: msg_sessions
    type: createtable
  id: 002-29-maz
- author: Mario Zieschang
  entries:
  - columns:
    - name: session
      type: uuid
    - name: dbuser
      type: uuid
    - default: (date_part('epoch'::text, now()))::integer
      name: last_read
      type: bigint
    - default: (date_part('epoch'::text, now()))::integer
      name: last_message
      type: bigint
    name: message_session_members
    type: createtable
  id: 002-30-maz
- author: Mario Zieschang
  entries:
  - columns:
    - default: (md5(((((current_database())::text || ("current_user"())::text) ||
        now()) || random())))::uuid
      name: id
      type: uuid
    - name: dbuser
      type: uuid
    - default: 1
      length: 1
      name: mail_inbox
      type: bit
    - default: 1
      length: 1
      name: new_friends_blog_entry
      type: bit
    - default: 1
      length: 1
      name: new_forum_threads
      type: bit
    - default: 1
      length: 1
      name: new_friends_pics
      type: bit
    - default: 1
      length: 1
      name: friends_online
      type: bit
    - default: 1
      length: 1
      name: current_subscriptions
      type: bit
    - default: 1
      length: 1
      name: system_news
      type: bit
    - default: 0
      length: 1
      name: calendar
      type: bit
    - default: 0
      length: 1
      name: meta_datas
      type: bit
    - default: 1
      length: 1
      name: friends_onnline
      type: bit
    name: profile_dashboard_widgets
    type: createtable
  id: 002-31-maz
- author: Mario Zieschang
  entries:
  - columns:
    - default: (md5(((((current_database())::text || ("current_user"())::text) ||
        now()) || random())))::uuid
      name: id
      type: uuid
    - default: 1
      length: 1
      name: active
      type: bit
    - default: now()
      name: flag
      type: timestamp
    - name: dbuser
      type: uuid
    - default: 0
      length: 1
      name: read
      type: bit
    - length: 1024
      name: name
      type: varchar
    - length: 15
      name: category
      type: varchar
    name: messages_system
    type: createtable
  id: 002-32-maz
- author: Mario Zieschang
  entries:
  - columns:
    - default: (md5(((((current_database())::text || ("current_user"())::text) ||
        now()) || random())))::uuid
      name: id
      type: uuid
    - default: 1
      length: 1
      name: active
      type: bit
    - default: nextval('message_system_seq'::regclass)
      name: number
      type: bigint
    - default: now()
      name: flag
      type: timestamp
    - length: 255
      name: name