view release on metacpan or  search on metacpan

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

    - default: nextval('user_permissions_number_seq'::regclass)
      name: number
      type: bigint
    - default: now()
      name: flag
      type: timestamp
    - length: 255
      name: name
      type: varchar
    - name: description
      type: text
    name: user_permissions
    type: createtable
  id: 002-62-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('user_roles_number_seq'::regclass)
      name: number
      type: bigint
    - default: now()
      name: flag
      type: timestamp
    - length: 255
      name: name
      type: varchar
    - name: description
      type: text
    - name: parent
      type: uuid
    name: user_roles
    type: createtable
  id: 002-63-maz
- author: Mario Zieschang
  entries:
  - columns:
    - name: user_role
      type: uuid
    - name: user_permission
      type: uuid
    name: user_role_has_permissions
    type: createtable
  id: 002-64-maz
- author: Mario Zieschang
  entries:
  - columns:
    - name: msg_session
      type: uuid
    - name: msg_user
      type: uuid
    - default: 0
      length: 1
      name: locked
      type: bit
    - default: now()
      name: last_read
      type: timestamp
    name: msg_session_members
    type: createtable
  id: 002-65-maz
- author: Mario Zieschang
  entries:
  - columns:
    - default: now()
      name: flag
      type: timestamp
    - name: dbuser
      type: uuid
    - name: friend
      type: uuid
    - default: (md5(((((current_database())::text || ("current_user"())::text) ||
        now()) || random())))::uuid
      name: id
      type: uuid
    name: user_friends
    type: createtable
  id: 002-66-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
    - name: number
      type: bigint
    - default: now()
      name: flag
      type: timestamp
    - default: '''''::character varying'
      length: 255
      name: name
      type: varchar
    - name: description
      type: text
    - name: topic
      type: uuid
    - name: dbuser
      type: uuid
    - default: (date_part('epoch'::text, now()))::integer
      name: last_post_time
      type: bigint
    name: forum_post
    type: createtable
  id: 002-67-maz
- author: Mario Zieschang
  entries:
  - columns:
    - name: dbuser