migrate

package
v0.0.0-...-c1ffc38 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Nov 2, 2023 License: Apache-2.0 Imports: 7 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

View Source 
var (
	// WithGlobalUniqueID sets the universal ids options to the migration.
	// If this option is enabled, ent migration will allocate a 1<<32 range
	// for the ids of each entity (table).
	// Note that this option cannot be applied on tables that already exist.
	WithGlobalUniqueID = schema.WithGlobalUniqueID
	// WithDropColumn sets the drop column option to the migration.
	// If this option is enabled, ent migration will drop old columns
	// that were used for both fields and edges. This defaults to false.
	WithDropColumn = schema.WithDropColumn
	// WithDropIndex sets the drop index option to the migration.
	// If this option is enabled, ent migration will drop old indexes
	// that were defined in the schema. This defaults to false.
	// Note that unique constraints are defined using `UNIQUE INDEX`,
	// and therefore, it's recommended to enable this option to get more
	// flexibility in the schema changes.
	WithDropIndex = schema.WithDropIndex
	// WithForeignKeys enables creating foreign-key in schema DDL. This defaults to true.
	WithForeignKeys = schema.WithForeignKeys
)
View Source 
var (
	// AppColumns holds the columns for the "app" table.
	AppColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "name", Type: field.TypeString, Unique: true, Size: 45},
		{Name: "code", Type: field.TypeString, Unique: true, Size: 10},
		{Name: "kind", Type: field.TypeEnum, Enums: []string{"web", "native", "server"}},
		{Name: "redirect_uri", Type: field.TypeString, Nullable: true, Size: 255},
		{Name: "app_key", Type: field.TypeString, Nullable: true},
		{Name: "app_secret", Type: field.TypeString, Nullable: true, Size: 255},
		{Name: "scopes", Type: field.TypeString, Nullable: true, Size: 500},
		{Name: "token_validity", Type: field.TypeInt32, Nullable: true},
		{Name: "refresh_token_validity", Type: field.TypeInt32, Nullable: true},
		{Name: "logo_file_id", Type: field.TypeInt, Nullable: true},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}, Default: "active"},
		{Name: "private", Type: field.TypeBool, Nullable: true, Default: false},
		{Name: "owner_org_id", Type: field.TypeInt, Nullable: true},
	}
	// AppTable holds the schema information for the "app" table.
	AppTable = &schema.Table{
		Name:       "app",
		Columns:    AppColumns,
		PrimaryKey: []*schema.Column{AppColumns[0]},
	}
	// AppActionColumns holds the columns for the "app_action" table.
	AppActionColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "name", Type: field.TypeString},
		{Name: "kind", Type: field.TypeEnum, Enums: []string{"restful", "graphql", "rpc", "function", "route"}},
		{Name: "method", Type: field.TypeEnum, Enums: []string{"read", "write", "list"}},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "app_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppActionTable holds the schema information for the "app_action" table.
	AppActionTable = &schema.Table{
		Name:       "app_action",
		Columns:    AppActionColumns,
		PrimaryKey: []*schema.Column{AppActionColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_action_app_actions",
				Columns:    []*schema.Column{AppActionColumns[9]},
				RefColumns: []*schema.Column{AppColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "appaction_app_id_name",
				Unique:  true,
				Columns: []*schema.Column{AppActionColumns[9], AppActionColumns[5]},
			},
		},
	}
	// AppDictColumns holds the columns for the "app_dict" table.
	AppDictColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "code", Type: field.TypeString, Size: 20},
		{Name: "name", Type: field.TypeString, Size: 45},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "app_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppDictTable holds the schema information for the "app_dict" table.
	AppDictTable = &schema.Table{
		Name:       "app_dict",
		Columns:    AppDictColumns,
		PrimaryKey: []*schema.Column{AppDictColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_dict_app_dicts",
				Columns:    []*schema.Column{AppDictColumns[8]},
				RefColumns: []*schema.Column{AppColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "appdict_app_id_code",
				Unique:  true,
				Columns: []*schema.Column{AppDictColumns[8], AppDictColumns[5]},
			},
		},
	}
	// AppDictItemColumns holds the columns for the "app_dict_item" table.
	AppDictItemColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "ref_code", Type: field.TypeString},
		{Name: "code", Type: field.TypeString, Size: 20},
		{Name: "name", Type: field.TypeString, Size: 45},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "display_sort", Type: field.TypeInt32, Nullable: true},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}, Default: "inactive"},
		{Name: "dict_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "org_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppDictItemTable holds the schema information for the "app_dict_item" table.
	AppDictItemTable = &schema.Table{
		Name:       "app_dict_item",
		Columns:    AppDictItemColumns,
		PrimaryKey: []*schema.Column{AppDictItemColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_dict_item_app_dict_items",
				Columns:    []*schema.Column{AppDictItemColumns[11]},
				RefColumns: []*schema.Column{AppDictColumns[0]},
				OnDelete:   schema.SetNull,
			},
			{
				Symbol:     "app_dict_item_org_org",
				Columns:    []*schema.Column{AppDictItemColumns[12]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "appdictitem_ref_code",
				Unique:  false,
				Columns: []*schema.Column{AppDictItemColumns[5]},
			},
		},
	}
	// AppMenuColumns holds the columns for the "app_menu" table.
	AppMenuColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "parent_id", Type: field.TypeInt},
		{Name: "kind", Type: field.TypeEnum, Enums: []string{"dir", "menu"}},
		{Name: "name", Type: field.TypeString},
		{Name: "icon", Type: field.TypeString, Nullable: true},
		{Name: "route", Type: field.TypeString, Nullable: true},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "display_sort", Type: field.TypeInt32, Nullable: true},
		{Name: "app_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "action_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppMenuTable holds the schema information for the "app_menu" table.
	AppMenuTable = &schema.Table{
		Name:       "app_menu",
		Columns:    AppMenuColumns,
		PrimaryKey: []*schema.Column{AppMenuColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_menu_app_menus",
				Columns:    []*schema.Column{AppMenuColumns[12]},
				RefColumns: []*schema.Column{AppColumns[0]},
				OnDelete:   schema.SetNull,
			},
			{
				Symbol:     "app_menu_app_action_menus",
				Columns:    []*schema.Column{AppMenuColumns[13]},
				RefColumns: []*schema.Column{AppActionColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// AppPolicyColumns holds the columns for the "app_policy" table.
	AppPolicyColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "name", Type: field.TypeString},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "rules", Type: field.TypeJSON},
		{Name: "version", Type: field.TypeString, Default: "1"},
		{Name: "auto_grant", Type: field.TypeBool, Default: false},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}, Default: "active"},
		{Name: "app_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppPolicyTable holds the schema information for the "app_policy" table.
	AppPolicyTable = &schema.Table{
		Name:       "app_policy",
		Columns:    AppPolicyColumns,
		PrimaryKey: []*schema.Column{AppPolicyColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_policy_app_policies",
				Columns:    []*schema.Column{AppPolicyColumns[11]},
				RefColumns: []*schema.Column{AppColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// AppResColumns holds the columns for the "app_res" table.
	AppResColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "name", Type: field.TypeString},
		{Name: "type_name", Type: field.TypeString},
		{Name: "arn_pattern", Type: field.TypeString},
		{Name: "app_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppResTable holds the schema information for the "app_res" table.
	AppResTable = &schema.Table{
		Name:       "app_res",
		Columns:    AppResColumns,
		PrimaryKey: []*schema.Column{AppResColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_res_app_resources",
				Columns:    []*schema.Column{AppResColumns[8]},
				RefColumns: []*schema.Column{AppColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// AppRoleColumns holds the columns for the "app_role" table.
	AppRoleColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "name", Type: field.TypeString, Unique: true},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "auto_grant", Type: field.TypeBool, Default: false},
		{Name: "editable", Type: field.TypeBool, Default: false},
		{Name: "app_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppRoleTable holds the schema information for the "app_role" table.
	AppRoleTable = &schema.Table{
		Name:       "app_role",
		Columns:    AppRoleColumns,
		PrimaryKey: []*schema.Column{AppRoleColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_role_app_roles",
				Columns:    []*schema.Column{AppRoleColumns[9]},
				RefColumns: []*schema.Column{AppColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// AppRolePolicyColumns holds the columns for the "app_role_policy" table.
	AppRolePolicyColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "app_id", Type: field.TypeInt},
		{Name: "app_role_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "app_policy_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// AppRolePolicyTable holds the schema information for the "app_role_policy" table.
	AppRolePolicyTable = &schema.Table{
		Name:       "app_role_policy",
		Columns:    AppRolePolicyColumns,
		PrimaryKey: []*schema.Column{AppRolePolicyColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "app_role_policy_app_role_role",
				Columns:    []*schema.Column{AppRolePolicyColumns[6]},
				RefColumns: []*schema.Column{AppRoleColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "app_role_policy_app_policy_policy",
				Columns:    []*schema.Column{AppRolePolicyColumns[7]},
				RefColumns: []*schema.Column{AppPolicyColumns[0]},
				OnDelete:   schema.NoAction,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "approlepolicy_app_role_id_app_policy_id",
				Unique:  true,
				Columns: []*schema.Column{AppRolePolicyColumns[6], AppRolePolicyColumns[7]},
			},
		},
	}
	// FileColumns holds the columns for the "file" table.
	FileColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "name", Type: field.TypeString},
		{Name: "tenant_id", Type: field.TypeInt},
		{Name: "ref_count", Type: field.TypeInt, Nullable: true},
		{Name: "path", Type: field.TypeString},
		{Name: "size", Type: field.TypeInt, Nullable: true},
		{Name: "mine_type", Type: field.TypeString, Nullable: true, Size: 100},
		{Name: "md5", Type: field.TypeString, Nullable: true, Size: 100},
		{Name: "source_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "int"}},
	}
	// FileTable holds the schema information for the "file" table.
	FileTable = &schema.Table{
		Name:       "file",
		Columns:    FileColumns,
		PrimaryKey: []*schema.Column{FileColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "file_file_source_files",
				Columns:    []*schema.Column{FileColumns[12]},
				RefColumns: []*schema.Column{FileSourceColumns[0]},
				OnDelete:   schema.NoAction,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "file_tenant_id_source_id_path",
				Unique:  true,
				Columns: []*schema.Column{FileColumns[6], FileColumns[12], FileColumns[8]},
			},
		},
	}
	// FileSourceColumns holds the columns for the "file_source" table.
	FileSourceColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "kind", Type: field.TypeEnum, Enums: []string{"local", "alioss"}},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "endpoint", Type: field.TypeString, Nullable: true},
		{Name: "region", Type: field.TypeString, Nullable: true, Size: 100},
		{Name: "bucket", Type: field.TypeString, Nullable: true, Size: 100},
	}
	// FileSourceTable holds the schema information for the "file_source" table.
	FileSourceTable = &schema.Table{
		Name:       "file_source",
		Columns:    FileSourceColumns,
		PrimaryKey: []*schema.Column{FileSourceColumns[0]},
		Indexes: []*schema.Index{
			{
				Name:    "filesource_kind_endpoint_region_bucket",
				Unique:  true,
				Columns: []*schema.Column{FileSourceColumns[5], FileSourceColumns[7], FileSourceColumns[8], FileSourceColumns[9]},
			},
		},
	}
	// OauthClientColumns holds the columns for the "oauth_client" table.
	OauthClientColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "name", Type: field.TypeString, Size: 100},
		{Name: "client_id", Type: field.TypeString, Unique: true, Size: 40},
		{Name: "client_secret", Type: field.TypeString, Size: 40},
		{Name: "grant_types", Type: field.TypeEnum, Enums: []string{"client_credentials"}},
		{Name: "last_auth_at", Type: field.TypeTime, Nullable: true},
		{Name: "status", Type: field.TypeEnum, Enums: []string{"active", "inactive", "processing", "disabled"}, Default: "active"},
		{Name: "user_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OauthClientTable holds the schema information for the "oauth_client" table.
	OauthClientTable = &schema.Table{
		Name:       "oauth_client",
		Columns:    OauthClientColumns,
		PrimaryKey: []*schema.Column{OauthClientColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "oauth_client_user_oauth_clients",
				Columns:    []*schema.Column{OauthClientColumns[11]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.NoAction,
			},
		},
	}
	// OrgColumns holds the columns for the "org" table.
	OrgColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "deleted_at", Type: field.TypeTime, Nullable: true},
		{Name: "kind", Type: field.TypeEnum, Enums: []string{"root", "org"}, Default: "org"},
		{Name: "domain", Type: field.TypeString, Unique: true, Nullable: true},
		{Name: "code", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "name", Type: field.TypeString, Size: 100},
		{Name: "profile", Type: field.TypeString, Nullable: true},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}, Default: "active"},
		{Name: "path", Type: field.TypeString, Nullable: true, Size: 2147483647},
		{Name: "display_sort", Type: field.TypeInt32, Nullable: true},
		{Name: "country_code", Type: field.TypeString, Nullable: true, Size: 10},
		{Name: "timezone", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "parent_id", Type: field.TypeInt, Nullable: true, Default: 0, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "owner_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OrgTable holds the schema information for the "org" table.
	OrgTable = &schema.Table{
		Name:       "org",
		Columns:    OrgColumns,
		PrimaryKey: []*schema.Column{OrgColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "org_org_children",
				Columns:    []*schema.Column{OrgColumns[16]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.SetNull,
			},
			{
				Symbol:     "org_user_owner",
				Columns:    []*schema.Column{OrgColumns[17]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// OrgAppColumns holds the columns for the "org_app" table.
	OrgAppColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "app_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "org_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OrgAppTable holds the schema information for the "org_app" table.
	OrgAppTable = &schema.Table{
		Name:       "org_app",
		Columns:    OrgAppColumns,
		PrimaryKey: []*schema.Column{OrgAppColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "org_app_app_app",
				Columns:    []*schema.Column{OrgAppColumns[5]},
				RefColumns: []*schema.Column{AppColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "org_app_org_org",
				Columns:    []*schema.Column{OrgAppColumns[6]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.NoAction,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "orgapp_org_id_app_id",
				Unique:  true,
				Columns: []*schema.Column{OrgAppColumns[6], OrgAppColumns[5]},
			},
		},
	}
	// OrgPolicyColumns holds the columns for the "org_policy" table.
	OrgPolicyColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "app_id", Type: field.TypeInt, Nullable: true},
		{Name: "app_policy_id", Type: field.TypeInt, Nullable: true},
		{Name: "name", Type: field.TypeString},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "rules", Type: field.TypeJSON},
		{Name: "org_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OrgPolicyTable holds the schema information for the "org_policy" table.
	OrgPolicyTable = &schema.Table{
		Name:       "org_policy",
		Columns:    OrgPolicyColumns,
		PrimaryKey: []*schema.Column{OrgPolicyColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "org_policy_org_policies",
				Columns:    []*schema.Column{OrgPolicyColumns[10]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// OrgRoleColumns holds the columns for the "org_role" table.
	OrgRoleColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "kind", Type: field.TypeEnum, Enums: []string{"group", "role"}},
		{Name: "name", Type: field.TypeString},
		{Name: "app_role_id", Type: field.TypeInt, Nullable: true},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "org_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OrgRoleTable holds the schema information for the "org_role" table.
	OrgRoleTable = &schema.Table{
		Name:       "org_role",
		Columns:    OrgRoleColumns,
		PrimaryKey: []*schema.Column{OrgRoleColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "org_role_org_roles_and_groups",
				Columns:    []*schema.Column{OrgRoleColumns[9]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "orgrole_org_id_name",
				Unique:  true,
				Columns: []*schema.Column{OrgRoleColumns[9], OrgRoleColumns[6]},
			},
		},
	}
	// OrgRoleUserColumns holds the columns for the "org_role_user" table.
	OrgRoleUserColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "org_role_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "org_user_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "user_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "org_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OrgRoleUserTable holds the schema information for the "org_role_user" table.
	OrgRoleUserTable = &schema.Table{
		Name:       "org_role_user",
		Columns:    OrgRoleUserColumns,
		PrimaryKey: []*schema.Column{OrgRoleUserColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "org_role_user_org_role_org_role",
				Columns:    []*schema.Column{OrgRoleUserColumns[5]},
				RefColumns: []*schema.Column{OrgRoleColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "org_role_user_org_user_org_user",
				Columns:    []*schema.Column{OrgRoleUserColumns[6]},
				RefColumns: []*schema.Column{OrgUserColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "org_role_user_user_user",
				Columns:    []*schema.Column{OrgRoleUserColumns[7]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "org_role_user_org_org",
				Columns:    []*schema.Column{OrgRoleUserColumns[8]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.NoAction,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "orgroleuser_org_role_id_org_user_id",
				Unique:  true,
				Columns: []*schema.Column{OrgRoleUserColumns[5], OrgRoleUserColumns[6]},
			},
		},
	}
	// OrgUserColumns holds the columns for the "org_user" table.
	OrgUserColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "joined_at", Type: field.TypeTime},
		{Name: "display_name", Type: field.TypeString},
		{Name: "org_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "user_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OrgUserTable holds the schema information for the "org_user" table.
	OrgUserTable = &schema.Table{
		Name:       "org_user",
		Columns:    OrgUserColumns,
		PrimaryKey: []*schema.Column{OrgUserColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "org_user_org_org",
				Columns:    []*schema.Column{OrgUserColumns[7]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "org_user_user_user",
				Columns:    []*schema.Column{OrgUserColumns[8]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.NoAction,
			},
		},
		Indexes: []*schema.Index{
			{
				Name:    "orguser_org_id_user_id",
				Unique:  true,
				Columns: []*schema.Column{OrgUserColumns[7], OrgUserColumns[8]},
			},
		},
	}
	// OrgUserPreferenceColumns holds the columns for the "org_user_preference" table.
	OrgUserPreferenceColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "menu_favorite", Type: field.TypeJSON, Nullable: true},
		{Name: "menu_recent", Type: field.TypeJSON, Nullable: true},
		{Name: "user_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "org_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// OrgUserPreferenceTable holds the schema information for the "org_user_preference" table.
	OrgUserPreferenceTable = &schema.Table{
		Name:       "org_user_preference",
		Columns:    OrgUserPreferenceColumns,
		PrimaryKey: []*schema.Column{OrgUserPreferenceColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "org_user_preference_user_user",
				Columns:    []*schema.Column{OrgUserPreferenceColumns[7]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "org_user_preference_org_org",
				Columns:    []*schema.Column{OrgUserPreferenceColumns[8]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.NoAction,
			},
		},
	}
	// PermissionColumns holds the columns for the "permission" table.
	PermissionColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "principal_kind", Type: field.TypeEnum, Enums: []string{"user", "role"}},
		{Name: "start_at", Type: field.TypeTime, Nullable: true},
		{Name: "end_at", Type: field.TypeTime, Nullable: true},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}},
		{Name: "org_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "org_policy_id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "user_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "role_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "int"}},
	}
	// PermissionTable holds the schema information for the "permission" table.
	PermissionTable = &schema.Table{
		Name:       "permission",
		Columns:    PermissionColumns,
		PrimaryKey: []*schema.Column{PermissionColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "permission_org_permissions",
				Columns:    []*schema.Column{PermissionColumns[9]},
				RefColumns: []*schema.Column{OrgColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "permission_org_policy_permissions",
				Columns:    []*schema.Column{PermissionColumns[10]},
				RefColumns: []*schema.Column{OrgPolicyColumns[0]},
				OnDelete:   schema.NoAction,
			},
			{
				Symbol:     "permission_user_user",
				Columns:    []*schema.Column{PermissionColumns[11]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.SetNull,
			},
			{
				Symbol:     "permission_org_role_role",
				Columns:    []*schema.Column{PermissionColumns[12]},
				RefColumns: []*schema.Column{OrgRoleColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// UserColumns holds the columns for the "user" table.
	UserColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, SchemaType: map[string]string{"mysql": "bigint"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "deleted_at", Type: field.TypeTime, Nullable: true},
		{Name: "principal_name", Type: field.TypeString, Unique: true},
		{Name: "display_name", Type: field.TypeString},
		{Name: "email", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "mobile", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "user_type", Type: field.TypeEnum, Enums: []string{"account", "member"}},
		{Name: "creation_type", Type: field.TypeEnum, Enums: []string{"invitation", "register", "manual"}},
		{Name: "register_ip", Type: field.TypeString, Size: 45},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "avatar_file_id", Type: field.TypeInt, Nullable: true},
	}
	// UserTable holds the schema information for the "user" table.
	UserTable = &schema.Table{
		Name:       "user",
		Columns:    UserColumns,
		PrimaryKey: []*schema.Column{UserColumns[0]},
	}
	// UserDeviceColumns holds the columns for the "user_device" table.
	UserDeviceColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "device_uid", Type: field.TypeString, Size: 64},
		{Name: "device_name", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "system_name", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "system_version", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "app_version", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "device_model", Type: field.TypeString, Nullable: true, Size: 45},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}},
		{Name: "comments", Type: field.TypeString, Nullable: true},
		{Name: "user_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// UserDeviceTable holds the schema information for the "user_device" table.
	UserDeviceTable = &schema.Table{
		Name:       "user_device",
		Columns:    UserDeviceColumns,
		PrimaryKey: []*schema.Column{UserDeviceColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "user_device_user_devices",
				Columns:    []*schema.Column{UserDeviceColumns[13]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// UserIdentityColumns holds the columns for the "user_identity" table.
	UserIdentityColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "kind", Type: field.TypeEnum, Enums: []string{"name", "email", "phone", "wechat", "qq"}},
		{Name: "code", Type: field.TypeString, Nullable: true},
		{Name: "code_extend", Type: field.TypeString, Nullable: true},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}},
		{Name: "user_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// UserIdentityTable holds the schema information for the "user_identity" table.
	UserIdentityTable = &schema.Table{
		Name:       "user_identity",
		Columns:    UserIdentityColumns,
		PrimaryKey: []*schema.Column{UserIdentityColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "user_identity_user_identities",
				Columns:    []*schema.Column{UserIdentityColumns[9]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// UserLoginProfileColumns holds the columns for the "user_login_profile" table.
	UserLoginProfileColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "last_login_ip", Type: field.TypeString, Nullable: true},
		{Name: "last_login_at", Type: field.TypeTime, Nullable: true},
		{Name: "can_login", Type: field.TypeBool, Nullable: true},
		{Name: "set_kind", Type: field.TypeEnum, Enums: []string{"keep", "customer", "auto"}},
		{Name: "password_reset", Type: field.TypeBool, Nullable: true},
		{Name: "verify_device", Type: field.TypeBool},
		{Name: "mfa_enabled", Type: field.TypeBool, Nullable: true},
		{Name: "mfa_secret", Type: field.TypeString, Nullable: true, Size: 100},
		{Name: "mfa_status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}},
		{Name: "user_id", Type: field.TypeInt, Unique: true, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// UserLoginProfileTable holds the schema information for the "user_login_profile" table.
	UserLoginProfileTable = &schema.Table{
		Name:       "user_login_profile",
		Columns:    UserLoginProfileColumns,
		PrimaryKey: []*schema.Column{UserLoginProfileColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "user_login_profile_user_login_profile",
				Columns:    []*schema.Column{UserLoginProfileColumns[14]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// UserPasswordColumns holds the columns for the "user_password" table.
	UserPasswordColumns = []*schema.Column{
		{Name: "id", Type: field.TypeInt, Increment: true, SchemaType: map[string]string{"mysql": "int"}},
		{Name: "created_by", Type: field.TypeInt},
		{Name: "created_at", Type: field.TypeTime},
		{Name: "updated_by", Type: field.TypeInt, Nullable: true},
		{Name: "updated_at", Type: field.TypeTime, Nullable: true},
		{Name: "scene", Type: field.TypeEnum, Enums: []string{"login"}},
		{Name: "password", Type: field.TypeString, Nullable: true},
		{Name: "salt", Type: field.TypeString, Size: 45},
		{Name: "status", Type: field.TypeEnum, Nullable: true, Enums: []string{"active", "inactive", "processing", "disabled"}, Default: "active"},
		{Name: "user_id", Type: field.TypeInt, Nullable: true, SchemaType: map[string]string{"mysql": "bigint"}},
	}
	// UserPasswordTable holds the schema information for the "user_password" table.
	UserPasswordTable = &schema.Table{
		Name:       "user_password",
		Columns:    UserPasswordColumns,
		PrimaryKey: []*schema.Column{UserPasswordColumns[0]},
		ForeignKeys: []*schema.ForeignKey{
			{
				Symbol:     "user_password_user_passwords",
				Columns:    []*schema.Column{UserPasswordColumns[9]},
				RefColumns: []*schema.Column{UserColumns[0]},
				OnDelete:   schema.SetNull,
			},
		},
	}
	// Tables holds all the tables in the schema.
	Tables = []*schema.Table{
		AppTable,
		AppActionTable,
		AppDictTable,
		AppDictItemTable,
		AppMenuTable,
		AppPolicyTable,
		AppResTable,
		AppRoleTable,
		AppRolePolicyTable,
		FileTable,
		FileSourceTable,
		OauthClientTable,
		OrgTable,
		OrgAppTable,
		OrgPolicyTable,
		OrgRoleTable,
		OrgRoleUserTable,
		OrgUserTable,
		OrgUserPreferenceTable,
		PermissionTable,
		UserTable,
		UserDeviceTable,
		UserIdentityTable,
		UserLoginProfileTable,
		UserPasswordTable,
	}
)

Functions

func Create 

func Create(ctx context.Context, s *Schema, tables []*schema.Table, opts ...schema.MigrateOption) error

Create creates all table resources using the given schema driver.

func Diff 

func Diff(ctx context.Context, url string, opts ...schema.MigrateOption) error

Diff compares the state read from a database connection or migration directory with the state defined by the Ent schema. Changes will be written to new migration files.

func NamedDiff 

func NamedDiff(ctx context.Context, url, name string, opts ...schema.MigrateOption) error

NamedDiff compares the state read from a database connection or migration directory with the state defined by the Ent schema. Changes will be written to new named migration files.

Types

type Schema 

type Schema struct {
	// contains filtered or unexported fields
}

Schema is the API for creating, migrating and dropping a schema.

func NewSchema 

func NewSchema(drv dialect.Driver) *Schema

NewSchema creates a new schema client.

func (*Schema) Create 

func (s *Schema) Create(ctx context.Context, opts ...schema.MigrateOption) error

Create creates all schema resources.

func (*Schema) Diff 

func (s *Schema) Diff(ctx context.Context, opts ...schema.MigrateOption) error

Diff creates a migration file containing the statements to resolve the diff between the Ent schema and the connected database.

func (*Schema) NamedDiff 

func (s *Schema) NamedDiff(ctx context.Context, name string, opts ...schema.MigrateOption) error

NamedDiff creates a named migration file containing the statements to resolve the diff between the Ent schema and the connected database.

func (*Schema) WriteTo 

func (s *Schema) WriteTo(ctx context.Context, w io.Writer, opts ...schema.MigrateOption) error

WriteTo writes the schema changes to w instead of running them against the database. 

if err := client.Schema.WriteTo(context.Background(), os.Stdout); err != nil {
	log.Fatal(err)
}

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.