import { addColumns, createTable, schemaMigrations } from '@nozbe/watermelondb/Schema/migrations';

export default schemaMigrations({
	migrations: [
		{
			toVersion: 3,
			steps: [
				addColumns({
					table: 'users',
					columns: [{ name: 'statusText', type: 'string', isOptional: true }]
				})
			]
		},
		{
			toVersion: 4,
			steps: [
				addColumns({
					table: 'servers',
					columns: [
						{ name: 'last_local_authenticated_session', type: 'number', isOptional: true },
						{ name: 'auto_lock', type: 'boolean', isOptional: true },
						{ name: 'auto_lock_time', type: 'number', isOptional: true },
						{ name: 'biometry', type: 'boolean', isOptional: true }
					]
				})
			]
		},
		{
			toVersion: 5,
			steps: [
				addColumns({
					table: 'servers',
					columns: [{ name: 'unique_id', type: 'string', isOptional: true }]
				})
			]
		},
		{
			toVersion: 6,
			steps: [
				addColumns({
					table: 'servers',
					columns: [{ name: 'enterprise_modules', type: 'string', isOptional: true }]
				})
			]
		},
		{
			toVersion: 7,
			steps: [
				addColumns({
					table: 'users',
					columns: [{ name: 'login_email_password', type: 'boolean', isOptional: true }]
				})
			]
		},
		{
			toVersion: 8,
			steps: [
				addColumns({
					table: 'servers',
					columns: [{ name: 'e2e_enable', type: 'boolean', isOptional: true }]
				})
			]
		},
		{
			toVersion: 9,
			steps: [
				createTable({
					name: 'servers_history',
					columns: [
						{ name: 'url', type: 'string', isIndexed: true },
						{ name: 'username', type: 'string', isOptional: true },
						{ name: 'updated_at', type: 'number' }
					]
				})
			]
		},
		{
			toVersion: 10,
			steps: [
				addColumns({
					table: 'users',
					columns: [
						{ name: 'show_message_in_main_thread', type: 'boolean', isOptional: true },
						{ name: 'avatar_etag', type: 'string', isOptional: true }
					]
				})
			]
		},
		{
			toVersion: 11,
			steps: [
				addColumns({
					table: 'users',
					columns: [{ name: 'is_from_webview', type: 'boolean', isOptional: true }]
				})
			]
		},
		{
			toVersion: 12,
			steps: [
				addColumns({
					table: 'users',
					columns: [{ name: 'enable_message_parser_early_adoption', type: 'boolean', isOptional: true }]
				})
			]
		},
		{
			toVersion: 13,
			steps: [
				addColumns({
					table: 'users',
					columns: [
						{ name: 'nickname', type: 'string', isOptional: true },
						{ name: 'bio', type: 'string', isOptional: true }
					]
				})
			]
		},
		{
			toVersion: 14,
			steps: [
				addColumns({
					table: 'servers',
					columns: [
						{ name: 'supported_versions', type: 'string', isOptional: true },
						{
							name: 'supported_versions_warning_at',
							type: 'number',
							isOptional: true
						}
					]
				})
			]
		},
		{
			toVersion: 15,
			steps: [
				addColumns({
					table: 'servers',
					columns: [
						{
							name: 'supported_versions_updated_at',
							type: 'number',
							isOptional: true
						}
					]
				})
			]
		},
		{
			toVersion: 16,
			steps: [
				addColumns({
					table: 'users',
					columns: [{ name: 'require_password_change', type: 'string', isOptional: true }]
				})
			]
		},
		{
			toVersion: 17,
			steps: [
				addColumns({
					table: 'servers_history',
					columns: [{ name: 'icon_url', type: 'string', isOptional: true }]
				})
			]
		}
	]
});
