Node SDK: "createTable" does not create columns

[ddenev]

👟 Reproduction steps

Here is my node.js createTable function:

  await db.createTable({
    databaseId,
    tableId: 'months',
    name: 'Months',
    permissions: [Permission.read(Role.user(userId)), Permission.write(Role.user(userId))],
    columns: [
      { key: 'budget_id', type: 'string', size: 255, required: true },
      { key: 'month', type: 'integer', required: true, min: 1, max: 12 },
      { key: 'year', type: 'integer', required: true, min: 1970, max: 9999 },
      { key: 'category_id', type: 'string', size: 255, required: true },
      { key: 'rollover', type: 'float', default: 0 },
      { key: 'assigned', type: 'float', default: 0 },
      { key: 'activity', type: 'float', default: 0 },
      { key: 'available', type: 'float', default: 0 },
      { key: 'deleted_at', type: 'datetime', required: false }
    ],
    indexes: []
  })

and it does not create the provided columns:

👍 Expected behavior

the columns are created as specified

👎 Actual Behavior

no columns created

🎲 Appwrite version

Version 1.8.x

💻 Operating system

Linux

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[divyansharma001]

Can I work on this if this is not assigned to anyone? Can you please assign this to me

[stnguyen90]

@ddenev can you confirm what version of the node SDK you have?

[ddenev]

@stnguyen90, this code runs as an Appwrite function, so whichever gets installed during function deploy but here is my dependencies section in my package.json file in my functions project folder:

"dependencies": {
  "big.js": "^7.0.1",
  "node-appwrite": "^21.1.0"
}

I think this means it will run with v21.1.0 SDK when the function is executed and it seems that version supports creating columns/indexes while creating a table: https://github.com/appwrite/sdk-for-node/releases/tag/21.1.0