ALIYUN::GPDB::Database

更新时间:
复制为 MD 格式

ALIYUN::GPDB::Database类型用于创建数据库。

语法

{
  "Type": "ALIYUN::GPDB::Database",
  "Properties": {
    "DBInstanceId": String,
    "DatabaseName": String,
    "Owner": String,
    "CharacterSetName": String,
    "Collate": String,
    "Ctype": String,
    "Description": String
  }
}

属性

属性名称

类型

必须

允许更新

描述

约束

DatabaseName

String

数据库名称。

DBInstanceId

String

实例ID。

Owner

String

数据表所有者。

CharacterSetName

String

字符集.

默认值为UTF8。

Collate

String

数据库区域设置参数,

指定字符串比较/排序规则。

Ctype

String

数据库区域设置参数。

指定字符分类/大小写转换规则。

Description

String

数据库描述。

返回值

Fn::GetAtt

  • ConnLimit:最大连接限制,-1表示无限制。

  • CharacterSetName:字符集,默认值为UTF8。

  • TableSpace:数据库表空间。

  • Owner:数据表所有者。

  • Description:数据库描述。

  • DBInstanceId:实例ID。

  • Size:数据库大小。

  • DatabaseName:数据库名称。

  • Collate:数据库区域设置参数,指定字符串比较/排序规则。

  • Ctype:数据库区域设置参数,指定字符分类/大小写转换规则。

  • AccessPrivilege:权限控制信息。

示例

ROSTemplateFormatVersion: '2015-09-01'
Parameters:
  CharacterSetName:
    Type: String
    Description:
      en: Character set, default value is UTF8.
    Required: false
  Owner:
    Type: String
    Description:
      en: Data Sheet owner.
    Required: true
  Description:
    Type: String
    AssociationProperty: TextArea
    Description:
      en: Database Description.
    Required: false
  DBInstanceId:
    Type: String
    Description:
      en: Instance ID.
    Required: true
  DatabaseName:
    Type: String
    Description:
      en: Database Name.
    Required: true
  Collate:
    Type: String
    Description:
      en: Database locale parameters, specifying string comparison/collation.
    Required: false
  Ctype:
    Type: String
    Description:
      en: Database locale parameters, specifying character classification/case conversion rules.
    Required: false
Resources:
  ExtensionResource:
    Type: ALIYUN::GPDB::Database
    Properties:
      CharacterSetName:
        Ref: CharacterSetName
      Owner:
        Ref: Owner
      Description:
        Ref: Description
      DBInstanceId:
        Ref: DBInstanceId
      DatabaseName:
        Ref: DatabaseName
      Collate:
        Ref: Collate
      Ctype:
        Ref: Ctype
Outputs:
  ConnLimit:
    Description: Maximum connection limit,-1 means unrestricted.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - ConnLimit
  CharacterSetName:
    Description: Character set, default value is UTF8.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - CharacterSetName
  TableSpace:
    Description: Database table space.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - TableSpace
  Owner:
    Description: Data Sheet owner.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - Owner
  Description:
    Description: Database Description.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - Description
  DBInstanceId:
    Description: Instance ID.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - DBInstanceId
  Size:
    Description: Database size.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - Size
  DatabaseName:
    Description: Database Name.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - DatabaseName
  Collate:
    Description: Database locale parameters, specifying string comparison/collation.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - Collate
  Ctype:
    Description: Database locale parameters, specifying character classification/case conversion rules.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - Ctype
  AccessPrivilege:
    Description: Permission Control Information.
    Value:
      Fn::GetAtt:
        - ExtensionResource
        - AccessPrivilege
{
  "ROSTemplateFormatVersion": "2015-09-01",
  "Parameters": {
    "CharacterSetName": {
      "Type": "String",
      "Description": {
        "en": "Character set, default value is UTF8."
      },
      "Required": false
    },
    "Owner": {
      "Type": "String",
      "Description": {
        "en": "Data Sheet owner."
      },
      "Required": true
    },
    "Description": {
      "Type": "String",
      "AssociationProperty": "TextArea",
      "Description": {
        "en": "Database Description."
      },
      "Required": false
    },
    "DBInstanceId": {
      "Type": "String",
      "Description": {
        "en": "Instance ID."
      },
      "Required": true
    },
    "DatabaseName": {
      "Type": "String",
      "Description": {
        "en": "Database Name."
      },
      "Required": true
    },
    "Collate": {
      "Type": "String",
      "Description": {
        "en": "Database locale parameters, specifying string comparison/collation."
      },
      "Required": false
    },
    "Ctype": {
      "Type": "String",
      "Description": {
        "en": "Database locale parameters, specifying character classification/case conversion rules."
      },
      "Required": false
    }
  },
  "Resources": {
    "ExtensionResource": {
      "Type": "ALIYUN::GPDB::Database",
      "Properties": {
        "CharacterSetName": {
          "Ref": "CharacterSetName"
        },
        "Owner": {
          "Ref": "Owner"
        },
        "Description": {
          "Ref": "Description"
        },
        "DBInstanceId": {
          "Ref": "DBInstanceId"
        },
        "DatabaseName": {
          "Ref": "DatabaseName"
        },
        "Collate": {
          "Ref": "Collate"
        },
        "Ctype": {
          "Ref": "Ctype"
        }
      }
    }
  },
  "Outputs": {
    "ConnLimit": {
      "Description": "Maximum connection limit,-1 means unrestricted.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "ConnLimit"
        ]
      }
    },
    "CharacterSetName": {
      "Description": "Character set, default value is UTF8.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "CharacterSetName"
        ]
      }
    },
    "TableSpace": {
      "Description": "Database table space.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "TableSpace"
        ]
      }
    },
    "Owner": {
      "Description": "Data Sheet owner.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "Owner"
        ]
      }
    },
    "Description": {
      "Description": "Database Description.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "Description"
        ]
      }
    },
    "DBInstanceId": {
      "Description": "Instance ID.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "DBInstanceId"
        ]
      }
    },
    "Size": {
      "Description": "Database size.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "Size"
        ]
      }
    },
    "DatabaseName": {
      "Description": "Database Name.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "DatabaseName"
        ]
      }
    },
    "Collate": {
      "Description": "Database locale parameters, specifying string comparison/collation.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "Collate"
        ]
      }
    },
    "Ctype": {
      "Description": "Database locale parameters, specifying character classification/case conversion rules.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "Ctype"
        ]
      }
    },
    "AccessPrivilege": {
      "Description": "Permission Control Information.",
      "Value": {
        "Fn::GetAtt": [
          "ExtensionResource",
          "AccessPrivilege"
        ]
      }
    }
  }
}