summaryrefslogtreecommitdiffstats
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/_common/upgrade/3-4/002-convert_users.pl31
-rw-r--r--sql/_source/deploy/4/001-auto-__VERSION.yml91
-rw-r--r--sql/_source/deploy/4/001-auto.yml437
3 files changed, 0 insertions, 559 deletions
diff --git a/sql/_common/upgrade/3-4/002-convert_users.pl b/sql/_common/upgrade/3-4/002-convert_users.pl
deleted file mode 100644
index 9631345..0000000
--- a/sql/_common/upgrade/3-4/002-convert_users.pl
+++ /dev/null
@@ -1,31 +0,0 @@
-#!/usr/bin/env perl
-use v5.20;
-use warnings;
-
-use DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator::ScriptHelpers 'schema_from_schema_loader';
-use Authen::Passphrase::RejectAll;
-
-schema_from_schema_loader({ naming => 'v4' }, sub {
- my ($schema, $versions) = @_;
-
- while (my ($name, $user) = each %{ $::users->{person} }) {
- my %flags;
- for my $flag (split(//, $user->{flags})) {
- $flags{$flag} = 1;
- }
- $schema->resultset('Users')->create({
- name => $name,
- # We don't have the manually adjusted schema, so we need to
- # pass the raw value for the passphrase column
- passphrase => Authen::Passphrase::RejectAll->new->as_rfc2307,
- flag_secret => $flags{s} // 0,
- flag_admin => $flags{a} // 0,
- flag_hilights => $flags{h} // 0,
- flag_debug => $flags{d} // 0,
- flag_plugin => $flags{p} // 0,
- });
- }
-
- say "NOTE: The data from users.json has been moved to the database.\n"
- . "You may remove users.json now, although keeping a backup is strongly recommended.";
- })
diff --git a/sql/_source/deploy/4/001-auto-__VERSION.yml b/sql/_source/deploy/4/001-auto-__VERSION.yml
deleted file mode 100644
index 907f443..0000000
--- a/sql/_source/deploy/4/001-auto-__VERSION.yml
+++ /dev/null
@@ -1,91 +0,0 @@
----
-schema:
- procedures: {}
- tables:
- dbix_class_deploymenthandler_versions:
- 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:
- - version
- match_type: ''
- name: dbix_class_deploymenthandler_versions_version
- on_delete: ''
- on_update: ''
- options: []
- reference_fields: []
- reference_table: ''
- type: UNIQUE
- fields:
- ddl:
- data_type: text
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: ddl
- order: 3
- size:
- - 0
- id:
- data_type: int
- default_value: ~
- is_auto_increment: 1
- is_nullable: 0
- is_primary_key: 1
- is_unique: 0
- name: id
- order: 1
- size:
- - 0
- upgrade_sql:
- data_type: text
- default_value: ~
- is_nullable: 1
- is_primary_key: 0
- is_unique: 0
- name: upgrade_sql
- order: 4
- size:
- - 0
- version:
- data_type: varchar
- default_value: ~
- is_nullable: 0
- is_primary_key: 0
- is_unique: 1
- name: version
- order: 2
- size:
- - 50
- indices: []
- name: dbix_class_deploymenthandler_versions
- options: []
- order: 1
- triggers: {}
- views: {}
-translator:
- add_drop_table: 0
- filename: ~
- no_comments: 0
- parser_args:
- sources:
- - __VERSION
- parser_type: SQL::Translator::Parser::DBIx::Class
- producer_args: {}
- producer_type: SQL::Translator::Producer::YAML
- show_warnings: 0
- trace: 0
- version: 0.11021
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 19:13:19 +0000