mirror of
https://github.com/alexgo-io/stacks-blockchain-api.git
synced 2026-01-12 08:34:40 +08:00
53 lines
958 B
JavaScript
53 lines
958 B
JavaScript
/** @param { import("node-pg-migrate").MigrationBuilder } pgm */
|
|
exports.up = pgm => {
|
|
pgm.createTable('ft_metadata', {
|
|
id: {
|
|
type: 'serial',
|
|
primaryKey: true,
|
|
},
|
|
name: {
|
|
type: 'string',
|
|
notNull: true,
|
|
},
|
|
token_uri: {
|
|
type: 'string',
|
|
notNull: true,
|
|
},
|
|
description: {
|
|
type: 'string',
|
|
notNull: true,
|
|
},
|
|
image_uri: {
|
|
type: 'string',
|
|
notNull: true,
|
|
},
|
|
image_canonical_uri: {
|
|
type: 'string',
|
|
notNull: true,
|
|
},
|
|
contract_id: {
|
|
type: 'string',
|
|
notNull: true,
|
|
unique: true,
|
|
},
|
|
symbol: {
|
|
type: 'string',
|
|
notNull: true,
|
|
},
|
|
decimals: {
|
|
type: 'integer',
|
|
notNull: true,
|
|
},
|
|
tx_id: {
|
|
type: 'bytea',
|
|
notNull: true,
|
|
},
|
|
sender_address: {
|
|
type: 'string',
|
|
notNull: true,
|
|
}
|
|
});
|
|
|
|
pgm.createIndex('ft_metadata', 'contract_id', { method: 'hash' });
|
|
}
|