sergiotarxz/LasTres
1
0
Fork 0
Code Issues 18 Pull Requests Releases Wiki Activity
main
LasTres/dbicdh/_source/deploy/4/001-auto.yml

1283 lines
29 KiB
YAML
Raw Permalink Normal View History

Adding pj selection.
2023-06-08 09:02:32 +02:00
---
schema:
procedures: {}
tables:
equipment:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
fields:
uuid:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices: []
name: equipment
options: []
order: 1
equipment_items:
constraints:
- deferrable: 1
expression: ''
fields:
- kind
- equipment
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
- deferrable: 1
expression: ''
fields:
- equipment
match_type: ''
name: equipment_items_fk_equipment
on_delete: CASCADE
on_update: CASCADE
options: []
reference_fields:
- uuid
reference_table: equipment
type: FOREIGN KEY
fields:
equipment:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: equipment
order: 2
size:
- 0
identifier:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: identifier
order: 3
size:
- 0
kind:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: kind
order: 1
size:
- 0
quantity:
data_type: Integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: quantity
order: 4
size:
- 0
indices:
- fields:
- equipment
name: equipment_items_idx_equipment
options: []
type: NORMAL
name: equipment_items
options: []
order: 6
inventories:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
fields:
uuid:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices: []
name: inventories
options: []
order: 2
inventory_items:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
- deferrable: 1
expression: ''
fields:
- inventory
match_type: ''
name: inventory_items_fk_inventory
on_delete: CASCADE
on_update: CASCADE
options: []
reference_fields:
- uuid
reference_table: inventories
type: FOREIGN KEY
fields:
identifier:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: identifier
order: 3
size:
- 0
inventory:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: inventory
order: 2
size:
- 0
quantity:
data_type: Integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: quantity
order: 4
size:
- 0
uuid:
data_type: uuid
default_value: !!perl/ref
=: uuid_generate_v4()
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices:
- fields:
- inventory
name: inventory_items_idx_inventory
options: []
type: NORMAL
name: inventory_items
options: []
order: 7
player_companion_npcs:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
- deferrable: 1
expression: ''
fields:
- equipment
match_type: ''
name: player_companion_npcs_fk_equipment
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: equipment
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- inventory
match_type: ''
name: player_companion_npcs_fk_inventory
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: inventories
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- owner
match_type: ''
name: player_companion_npcs_fk_owner
on_delete: CASCADE
on_update: CASCADE
options: []
reference_fields:
- uuid
reference_table: player_pjs
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- skills
match_type: ''
name: player_companion_npcs_fk_skills
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: skill_like_lists
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- spells
match_type: ''
name: player_companion_npcs_fk_spells
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: skill_like_lists
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- stats
match_type: ''
name: player_companion_npcs_fk_stats
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: stats
type: FOREIGN KEY
fields:
equipment:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: equipment
order: 8
size:
- 0
exp:
data_type: integer
default_value: !!perl/ref
=: 1
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: exp
order: 7
size:
- 0
identifier:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: identifier
order: 3
size:
- 0
inventory:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: inventory
order: 12
size:
- 0
level:
data_type: integer
default_value: !!perl/ref
=: 1
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: level
order: 6
size:
- 0
nick:
data_type: text
default_value: ~
is_nullable: 1
is_primary_key: 0
is_unique: 0
name: nick
order: 4
size:
- 0
owner:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: owner
order: 2
size:
- 0
race:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: race
order: 5
size:
- 0
skills:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: skills
order: 10
size:
- 0
spells:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: spells
order: 11
size:
- 0
stats:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: stats
order: 9
size:
- 0
uuid:
data_type: uuid
default_value: !!perl/ref
=: uuid_generate_v4()
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices:
- fields:
- equipment
name: player_companion_npcs_idx_equipment
options: []
type: NORMAL
- fields:
- inventory
name: player_companion_npcs_idx_inventory
options: []
type: NORMAL
- fields:
- owner
name: player_companion_npcs_idx_owner
options: []
type: NORMAL
- fields:
- skills
name: player_companion_npcs_idx_skills
options: []
type: NORMAL
- fields:
- spells
name: player_companion_npcs_idx_spells
options: []
type: NORMAL
- fields:
- stats
name: player_companion_npcs_idx_stats
options: []
type: NORMAL
name: player_companion_npcs
options: []
order: 11
player_pjs:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
- deferrable: 1
expression: ''
fields:
- born_stats
match_type: ''
name: player_pjs_fk_born_stats
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: stats
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- equipment
match_type: ''
name: player_pjs_fk_equipment
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: equipment
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- inventory
match_type: ''
name: player_pjs_fk_inventory
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: inventories
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- owner
match_type: ''
name: player_pjs_fk_owner
on_delete: CASCADE
on_update: CASCADE
options: []
reference_fields:
- uuid
reference_table: players
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- skills
match_type: ''
name: player_pjs_fk_skills
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: skill_like_lists
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- spells
match_type: ''
name: player_pjs_fk_spells
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: skill_like_lists
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- team
match_type: ''
name: player_pjs_fk_team
on_delete: CASCADE
on_update: CASCADE
options: []
reference_fields:
- uuid
reference_table: teams
type: FOREIGN KEY
- deferrable: 1
expression: ''
fields:
- training_stats
match_type: ''
name: player_pjs_fk_training_stats
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: stats
type: FOREIGN KEY
fields:
born_stats:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: born_stats
order: 12
size:
- 0
creation_date:
data_type: timestamp
default_value: !!perl/ref
=: NOW()
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: creation_date
order: 8
size:
- 0
equipment:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: equipment
order: 11
size:
- 0
experience:
data_type: integer
default_value: !!perl/ref
=: 1
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: experience
order: 10
size:
- 0
full_name:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: full_name
order: 3
size:
- 0
health:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: health
order: 17
size:
- 0
inventory:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: inventory
order: 16
size:
- 0
last_activity:
data_type: timestamp
default_value: !!perl/ref
=: NOW()
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: last_activity
order: 9
size:
- 0
mana:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: mana
order: 18
size:
- 0
nick:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: nick
order: 5
size:
- 0
owner:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: owner
order: 2
size:
- 0
race:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: race
order: 6
size:
- 0
short_name:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: short_name
order: 4
size:
- 0
skills:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: skills
order: 14
size:
- 0
spells:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: spells
order: 15
size:
- 0
team:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: team
order: 7
size:
- 0
training_stats:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: training_stats
order: 13
size:
- 0
uuid:
data_type: uuid
default_value: !!perl/ref
=: uuid_generate_v4()
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices:
- fields:
- born_stats
name: player_pjs_idx_born_stats
options: []
type: NORMAL
- fields:
- equipment
name: player_pjs_idx_equipment
options: []
type: NORMAL
- fields:
- inventory
name: player_pjs_idx_inventory
options: []
type: NORMAL
- fields:
- owner
name: player_pjs_idx_owner
options: []
type: NORMAL
- fields:
- skills
name: player_pjs_idx_skills
options: []
type: NORMAL
- fields:
- spells
name: player_pjs_idx_spells
options: []
type: NORMAL
- fields:
- team
name: player_pjs_idx_team
options: []
type: NORMAL
- fields:
- training_stats
name: player_pjs_idx_training_stats
options: []
type: NORMAL
name: player_pjs
options: []
order: 10
players:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
- deferrable: 1
expression: ''
fields:
- email
match_type: ''
name: unique_constraint_email
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: UNIQUE
- deferrable: 1
expression: ''
fields:
- username
match_type: ''
name: unique_constraint_username
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: UNIQUE
fields:
email:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 1
name: email
order: 4
size:
- 0
encrypted_password:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: encrypted_password
order: 3
size:
- 0
last_activity:
data_type: timestamp
default_value: !!perl/ref
=: NOW()
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: last_activity
order: 8
size:
- 0
register_date:
data_type: timestamp
default_value: !!perl/ref
=: NOW()
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: register_date
order: 7
size:
- 0
username:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 1
name: username
order: 2
size:
- 0
uuid:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
verification_token:
data_type: text
default_value: ~
is_nullable: 1
is_primary_key: 0
is_unique: 0
name: verification_token
order: 6
size:
- 0
verified:
data_type: boolean
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: verified
order: 5
size:
- 0
indices: []
name: players
options: []
order: 3
skill_like_items:
constraints:
- deferrable: 1
expression: ''
fields:
- identifier
- owner_list
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
- deferrable: 1
expression: ''
fields:
- owner_list
match_type: ''
name: skill_like_items_fk_owner_list
on_delete: CASCADE
on_update: CASCADE
options: []
reference_fields:
- uuid
reference_table: skill_like_lists
type: FOREIGN KEY
fields:
identifier:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: identifier
order: 1
size:
- 0
level:
data_type: integer
default_value: !!perl/ref
=: 1
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: level
order: 3
size:
- 0
owner_list:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: owner_list
order: 2
size:
- 0
indices:
- fields:
- owner_list
name: skill_like_items_idx_owner_list
options: []
type: NORMAL
name: skill_like_items
options: []
order: 8
skill_like_lists:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
fields:
uuid:
data_type: uuid
default_value: !!perl/ref
=: uuid_generate_v4()
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices: []
name: skill_like_lists
options: []
order: 4
stats:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
fields:
health:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: health
order: 2
size:
- 0
intelligence:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: intelligence
order: 8
size:
- 0
magic:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: magic
order: 6
size:
- 0
mana:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: mana
order: 3
size:
- 0
resistance:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: resistance
order: 5
size:
- 0
speed:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: speed
order: 7
size:
- 0
strength:
data_type: integer
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: strength
order: 4
size:
- 0
uuid:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices: []
name: stats
options: []
order: 5
teams:
constraints:
- deferrable: 1
expression: ''
fields:
- uuid
match_type: ''
name: ''
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: PRIMARY KEY
- deferrable: 1
expression: ''
fields:
- name
match_type: ''
name: u_name
on_delete: ''
on_update: ''
options: []
reference_fields: []
reference_table: ''
type: UNIQUE
- deferrable: 1
expression: ''
fields:
- leader
match_type: ''
name: teams_fk_leader
on_delete: ''
on_update: ''
options: []
reference_fields:
- uuid
reference_table: player_pjs
type: FOREIGN KEY
fields:
area:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: area
order: 6
size:
- 0
leader:
data_type: uuid
default_value: ~
is_nullable: 1
is_primary_key: 0
is_unique: 0
name: leader
order: 2
size:
- 0
location:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: location
order: 7
size:
- 0
name:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 1
name: name
order: 3
size:
- 0
planet:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: planet
order: 4
size:
- 0
super_area:
data_type: text
default_value: ~
is_nullable: 0
is_primary_key: 0
is_unique: 0
name: super_area
order: 5
size:
- 0
uuid:
data_type: uuid
default_value: ~
is_nullable: 0
is_primary_key: 1
is_unique: 0
name: uuid
order: 1
size:
- 0
indices:
- fields:
- leader
name: teams_idx_leader
options: []
type: NORMAL
name: teams
options: []
order: 9
triggers: {}
views: {}
translator:
add_drop_table: 0
filename: ~
no_comments: 0
parser_args:
sources:
- CompanionNPC
- Equipment
- EquipmentItem
- Inventory
- InventoryItem
- PJ
- Player
- SkillLikeItem
- SkillLikeList
- Stats
- Team
parser_type: SQL::Translator::Parser::DBIx::Class
producer_args: {}
producer_type: SQL::Translator::Producer::YAML
show_warnings: 0
trace: 0
version: 1.63
Reference in New Issue Copy Permalink