summaryrefslogtreecommitdiffstats
path: root/sql/_source/deploy/4/001-auto.yml
diff options
context:
space:
mode:
Diffstat (limited to 'sql/_source/deploy/4/001-auto.yml')
-rw-r--r--sql/_source/deploy/4/001-auto.yml437
1 files changed, 0 insertions, 437 deletions
diff --git a/sql/_source/deploy/4/001-auto.yml b/sql/_source/deploy/4/001-auto.yml
deleted file mode 100644
index 8ae9ddc..0000000
--- a/sql/_source/deploy/4/001-auto.yml
+++ /dev/null
@@ -1,437 +0,0 @@
----
-schema:
- procedures: {}
- tables:
- actionlog:
- constraints:
- - deferrable: 1
- expression: ''
- fields:
- - index
- match_type: ''
- name: ''
- on_delete: ''
- on_update: ''
- options: []
- reference_fields: []
- reference_table: ''
- type: PRIMARY KEY
- fields:
- account:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: account
- order: 11
- size:
- - 17
- action:
- data_type: varchar
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: action
- order: 3
- size:
- - 20
- byaccount:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: byaccount
- order: 16
- size:
- - 17
- bygecos:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: bygecos
- order: 15
- size:
- - 512
- byhost:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: byhost
- order: 14
- size:
- - 64
- bynick:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: bynick
- order: 12
- size:
- - 17
- byuser:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: byuser
- order: 13
- size:
- - 11
- channel:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: channel
- order: 5
- size:
- - 51
- gecos:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: gecos
- order: 10
- size:
- - 512
- host:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: host
- order: 8
- size:
- - 64
- index:
- data_type: bigint
- default_value: ~
- is_auto_increment: 1
- is_nullable: 0
- is_primary_key: 1
- is_unique: 0
- name: index
- order: 1
- size:
- - 0
- ip:
- data_type: integer
- default_value: ~
- extra:
- unsigned: 1
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: ip
- order: 9
- size:
- - 0
- nick:
- data_type: varchar
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: nick
- order: 6
- size:
- - 17
- reason:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: reason
- order: 4
- size:
- - 512
- time:
- data_type: timestamp
- default_value: !!perl/ref
- =: current_timestamp
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: time
- order: 2
- size:
- - 0
- user:
- data_type: varchar
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: user
- order: 7
- size:
- - 11
- indices: []
- name: actionlog
- options: []
- order: 1
- alertlog:
- constraints:
- - deferrable: 1
- expression: ''
- fields:
- - sqlid
- match_type: ''
- name: ''
- on_delete: ''
- on_update: ''
- options: []
- reference_fields: []
- reference_table: ''
- type: PRIMARY KEY
- fields:
- channel:
- data_type: text
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: channel
- order: 2
- size:
- - 0
- gecos:
- data_type: text
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: gecos
- order: 6
- size:
- - 0
- host:
- data_type: text
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: host
- order: 5
- size:
- - 0
- id:
- data_type: tinytext
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: id
- order: 8
- size:
- - 0
- level:
- data_type: tinytext
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: level
- order: 7
- size:
- - 0
- nick:
- data_type: text
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: nick
- order: 3
- size:
- - 0
- reason:
- data_type: text
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: reason
- order: 9
- size:
- - 0
- sqlid:
- data_type: bigint
- default_value: ~
- is_auto_increment: 1
- is_nullable: 0
- is_primary_key: 1
- is_unique: 0
- name: sqlid
- order: 10
- size:
- - 0
- time:
- data_type: timestamp
- default_value: !!perl/ref
- =: current_timestamp
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: time
- order: 1
- size:
- - 0
- user:
- data_type: text
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: user
- order: 4
- size:
- - 0
- indices: []
- name: alertlog
- options: []
- order: 2
- users:
- constraints:
- - deferrable: 1
- expression: ''
- fields:
- - id
- match_type: ''
- name: ''
- on_delete: ''
- on_update: ''
- options: []
- reference_fields: []
- reference_table: ''
- type: PRIMARY KEY
- - deferrable: 1
- expression: ''
- fields:
- - name
- match_type: ''
- name: uniq_user_name
- on_delete: ''
- on_update: ''
- options: []
- reference_fields: []
- reference_table: ''
- type: UNIQUE
- fields:
- flag_admin:
- data_type: boolean
- default_value: 0
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: flag_admin
- order: 6
- size:
- - 0
- flag_debug:
- data_type: boolean
- default_value: 0
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: flag_debug
- order: 8
- size:
- - 0
- flag_hilights:
- data_type: boolean
- default_value: 0
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: flag_hilights
- order: 5
- size:
- - 0
- flag_plugin:
- data_type: boolean
- default_value: 0
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: flag_plugin
- order: 7
- size:
- - 0
- flag_secret:
- data_type: boolean
- default_value: 0
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: flag_secret
- order: 4
- size:
- - 0
- id:
- data_type: bigint
- default_value: ~
- is_auto_increment: 1
- is_nullable: 0
- is_primary_key: 1
- is_unique: 0
- name: id
- order: 1
- size:
- - 0
- name:
- data_type: varchar
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 1
- name: name
- order: 2
- size:
- - 20
- passphrase:
- data_type: text
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 0
- name: passphrase
- order: 3
- size:
- - 0
- indices: []
- name: users
- options: []
- order: 3
- triggers: {}
- views: {}
-translator:
- add_drop_table: 0
- filename: ~
- no_comments: 0
- parser_args:
- sources:
- - Actionlog
- - Alertlog
- - User
- parser_type: SQL::Translator::Parser::DBIx::Class
- producer_args: {}
- producer_type: SQL::Translator::Producer::YAML
- show_warnings: 0
- trace: 0
- version: 0.11021
generated by cgit v1.2.3 (git 2.46.0) at 2026-01-26 23:51:29 +0000