You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
cartodb/db/migrate/20140818144705_create_searc...

20 lines
770 B

Sequel.migration do
up do
SequelRails::connection.run 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp"'
create_table :search_tweets do
Uuid :id, primary_key: true, null: false, unique: false, default: Sequel.lit('uuid_generate_v4()')
Uuid :user_id, null: false
Uuid :table_id, null: true
Uuid :data_import_id, null: false
Text :service_item_id, null: false
Integer :retrieved_items, null: false, default: 0
Text :state, null: false
DateTime :created_at, default: Sequel::CURRENT_TIMESTAMP
DateTime :updated_at, default: Sequel::CURRENT_TIMESTAMP
end
end
down do
drop_table :search_tweets
end
end