From 9fa591cb0696bfc8f8af284bac9c4cd312fe293e Mon Sep 17 00:00:00 2001 From: Janik Kleinhoff Date: Mon, 8 May 2017 02:59:19 +0000 Subject: Revert "Move users to DB" This reverts commit 7342c7f0e19e15ab3c7ba2133a56393c15989f08. Turns out there are still issues after all. --- sql/_source/deploy/4/001-auto-__VERSION.yml | 91 ------ sql/_source/deploy/4/001-auto.yml | 437 ---------------------------- 2 files changed, 528 deletions(-) delete mode 100644 sql/_source/deploy/4/001-auto-__VERSION.yml delete mode 100644 sql/_source/deploy/4/001-auto.yml (limited to 'sql/_source/deploy') 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 -- cgit v1.2.3