SQL> START /home/oracle/migrate.sql

Table created.


0 rows deleted.


1 row created.


1 row updated.


Table created.

CREATE SEQUENCE business_widget_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE channel_tokens_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE channels_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE contacts_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE conversation_devices_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE conversations_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE devices_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE hibernate_sequence
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE image_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE license_agreement_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE market_items_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE merchant_order_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE merchant_products_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE messages_for_deliveries_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE messages_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE payment_requests_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE payments_history_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE payments_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE product_order_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE tag_relation_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE tag_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE user_token_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE users_conversations_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE users_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE SEQUENCE widgets_seq
                *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE business_widget (id NUMBER(38, 0) NOT NULL, user_id NUMBER(38, 0) NOT NULL, widget_id NUMBER(38, 0) NOT NULL)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE channel_tokens (id NUMBER(38, 0) NOT NULL, token VARCHAR2(255) NOT NULL, user_id NUMBER(38, 0) NOT NULL)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE channels (id NUMBER(38, 0) NOT NULL, chaneable_id NUMBER(38, 0), chaneable_type VARCHAR2(255), name VARCHAR2(255), url_logo VARCHAR2(255))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE contacts (id NUMBER(38, 0) NOT NULL, conversation_id NUMBER(38, 0), email VARCHAR2(255), existed_id NUMBER(38, 0), first_name VARCHAR2(255), last_name VARCHAR2(255), last_updated_at NUMBER(38, 0), phone VARCHAR2(255), user_id NUMBER(38, 0))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE conversation_devices (id NUMBER(38, 0) NOT NULL, conversation_id NUMBER(38, 0), device_id NUMBER(38, 0), last_send_message_id NUMBER(38, 0))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE conversations (id NUMBER(38, 0) NOT NULL, default_image_url VARCHAR2(255), descript VARCHAR2(255), dialog_id NUMBER(38, 0), image_id NUMBER(38, 0), last_message_content VARCHAR2(4000), last_updated_at NUMBER(38, 0), normal_image_url VARCHAR2(255), order_id NUMBER(38, 0), random_id NUMBER(38, 0), ratio FLOAT4, thumb_image_url VARCHAR2(255), title VARCHAR2(255), conversation_type INTEGER)
                                                                                                                                                                                                                                                                                                                            *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE devices (id NUMBER(38, 0) NOT NULL, application_type INTEGER, busy BOOL, connect_status INTEGER, device_type INTEGER, last_activity NUMBER(38, 0), last_synchronised_at NUMBER(38, 0), model VARCHAR2(255), platform VARCHAR2(255), push_token VARCHAR2(255), token VARCHAR2(255), "uid" VARCHAR2(255), unread_push_messages INTEGER, user_id NUMBER(38, 0) NOT NULL)
                                                                                *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE image (id NUMBER(38, 0) NOT NULL, device_id NUMBER(38, 0), name VARCHAR2(255), standart VARCHAR2(255), object_id NUMBER(38, 0), object_type NUMBER(38, 0), ratio FLOAT4, small VARCHAR2(255), user_id NUMBER(38, 0))
                                                                                                                                                                              *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE license_agreement (id NUMBER(38, 0) NOT NULL, agreement_text CLOB, last_updated_at NUMBER(38, 0), license_type INTEGER, version VARCHAR2(255))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE market_items (id NUMBER(38, 0) NOT NULL, cover_default_image_url VARCHAR2(255), cover_image_id NUMBER(38, 0), cover_normal_image_url VARCHAR2(255), cover_ratio FLOAT4, cover_thumb_image_url VARCHAR2(255), descript VARCHAR2(255), last_updated_at NUMBER(38, 0), logo_default_image_url VARCHAR2(255), logo_image_id NUMBER(38, 0), logo_normal_image_url VARCHAR2(255), logo_ratio FLOAT4, logo_thumb_image_url VARCHAR2(255), object_id NUMBER(38, 0), object_type INTEGER, status INTEGER, title VARCHAR2(255))
                                                                                                                                                                             *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE merchant_order (id NUMBER(38, 0) NOT NULL, address VARCHAR2(255), comm VARCHAR2(255), contact_phone VARCHAR2(255), conversation_id NUMBER(38, 0) NOT NULL, delivery_time VARCHAR2(255), descript VARCHAR2(255), last_updated_at NUMBER(38, 0), user_id NUMBER(38, 0), message_id NUMBER(38, 0), price NUMBER(38, 0), purchaser_id NUMBER(38, 0), status INTEGER)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE merchant_products (id NUMBER(38, 0) NOT NULL, actual BOOL, cover_default_image_url VARCHAR2(255), cover_image_id NUMBER(38, 0), cover_normal_image_url VARCHAR2(255), cover_ratio FLOAT4, cover_thumb_image_url VARCHAR2(255), currency VARCHAR2(255), descript VARCHAR2(4000), features VARCHAR2(4000), geo VARCHAR2(255), last_updated_at NUMBER(38, 0), logo_default_image_url VARCHAR2(255), logo_image_id NUMBER(38, 0), logo_normal_image_url VARCHAR2(255), logo_ratio FLOAT4, logo_thumb_image_url VARCHAR2(255), user_id NUMBER(38, 0), native_id VARCHAR2(255), price NUMBER(38, 0), title VARCHAR2(255), url VARCHAR2(255))
                                                                  *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE messages (id NUMBER(38, 0) NOT NULL, client_message_id NUMBER(38, 0), content VARCHAR2(4000), conversation_id NUMBER(38, 0) NOT NULL, last_updated_at NUMBER(38, 0), message_status INTEGER, timestamp NUMBER(38, 0) NOT NULL, type INTEGER, user_id NUMBER(38, 0) NOT NULL)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE messages_for_deliveries (id NUMBER(38, 0) NOT NULL, channel_token_id NUMBER(38, 0) NOT NULL, external_id NUMBER(38, 0) NOT NULL, is_read BOOL NOT NULL, message_type INTEGER NOT NULL)
                                                                                                                                                      *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE payment_requests (id NUMBER(38, 0) NOT NULL, amount FLOAT8 NOT NULL, from_user_id NUMBER(38, 0) NOT NULL, message_id NUMBER(38, 0) NOT NULL, payment_id NUMBER(38, 0), status_id INTEGER NOT NULL, to_user_id NUMBER(38, 0) NOT NULL)
                                                                 *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE payments (id NUMBER(38, 0) NOT NULL, amount FLOAT8 NOT NULL, doc_id NUMBER(38, 0), message_id NUMBER(38, 0), payment_status INTEGER, receiver_user_id NUMBER(38, 0), sender_user_id NUMBER(38, 0))
                                                         *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE payments_history (id NUMBER(38, 0) NOT NULL, payment_id NUMBER(38, 0), payment_status INTEGER, timestamp NUMBER(38, 0))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE product_order (id NUMBER(38, 0) NOT NULL, product_count INTEGER NOT NULL, order_id NUMBER(38, 0) NOT NULL, price NUMBER(38, 0), product_id NUMBER(38, 0) NOT NULL)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE staff (id NUMBER(38, 0) NOT NULL, first_name VARCHAR2(255), last_name VARCHAR2(255), role INTEGER)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE staff_token_records (id NUMBER(38, 0) NOT NULL, login VARCHAR2(255), "password" VARCHAR2(255), staff_id NUMBER(38, 0) NOT NULL, token VARCHAR2(255))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE tag (id NUMBER(38, 0) NOT NULL, default_image_url VARCHAR2(255), image_id NUMBER(38, 0), normal_image_url VARCHAR2(255), ratio FLOAT4, thumb_image_url VARCHAR2(255), title VARCHAR2(255), type INTEGER)
                                                                                                                                            *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE tag_relation (id NUMBER(38, 0) NOT NULL, object_id NUMBER(38, 0) NOT NULL, object_type INTEGER, tag_id NUMBER(38, 0) NOT NULL, tag_weight NUMBER(38, 0))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE user_token (id NUMBER(38, 0) NOT NULL, "password" VARCHAR2(255), token VARCHAR2(255), user_id NUMBER(38, 0))
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE TABLE users (id NUMBER(38, 0) NOT NULL, business_address VARCHAR2(255), business_phone VARCHAR2(255), category_id NUMBER(38, 0), client_id VARCHAR2(255), connect_status INTEGER, contact_email VARCHAR2(255), contact_name VARCHAR2(255), contact_phone VARCHAR2(255), cover_default_image_url VARCHAR2(255), cover_image_id NUMBER(38, 0), cover_normal_image_url VARCHAR2(255), cover_ratio FLOAT4, cover_thumb_image_url VARCHAR2(255), descript VARCHAR2(255), email VARCHAR2(255), first_name VARCHAR2(255), inn VARCHAR2(255), last_name VARCHAR2(255), last_activity NUMBER(38, 0), last_updated_at NUMBER(38, 0), legal_name VARCHAR2(255), logo_default_image_url VARCHAR2(255), logo_image_id NUMBER(38, 0), logo_normal_image_url VARCHAR2(255), logo_ratio FLOAT4, logo_thumb_image_url VARCHAR2(255), merchant_type VARCHAR2(255), money_turnover NUMBER(38, 0), nickname VARCHAR2(255), ogrn VARCHAR2(255), open_date INTEGER, phone VARCHAR2(255), sex INTEGER, site VARCHAR2(255), sms_attempts INTEGER, sms_expiration TIMESTAMP, sms_value VARCHAR2(20), status INTEGER, title VARCHAR2(255), type INTEGER)
                                                                                                                                                                                                                                                                                                                                                                                                      *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE users_conversations (id NUMBER(38, 0) NOT NULL, admin BOOL NOT NULL, bot_muted BOOL NOT NULL, conversation_id NUMBER(38, 0) NOT NULL, dialog_id NUMBER(38, 0), last_read_message_id NUMBER(38, 0), muted BOOL NOT NULL, removed BOOL NOT NULL, title VARCHAR2(255), user_id NUMBER(38, 0) NOT NULL)
                                                                   *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE TABLE widgets (id NUMBER(38, 0) NOT NULL, default_image_url VARCHAR2(255), default_widget BOOL, descript VARCHAR2(255), image_id NUMBER(38, 0), normal_image_url VARCHAR2(255), ratio FLOAT4, thumb_image_url VARCHAR2(255), title VARCHAR2(255), type VARCHAR2(255), user_id NUMBER(38, 0), value VARCHAR2(255))
                                                                                                 *
ERROR at line 1:
ORA-00902: invalid datatype



1 row created.

CREATE UNIQUE INDEX contactsUserPhoneIndex ON contacts(user_id, phone)
                    *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE UNIQUE INDEX dc_device_index ON conversation_devices(device_id, conversation_id)
                    *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE UNIQUE INDEX idx_channel_tokens_token ON channel_tokens(token)
                    *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE UNIQUE INDEX ImageIndexTypeId ON image(name, object_type, object_id)
                                        *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE UNIQUE INDEX ISTRLoginPasswordUnq ON staff_token_records(login, "password")
                    *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE UNIQUE INDEX ISTRTokenUnq ON staff_token_records(token)
                    *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE UNIQUE INDEX object_type_id_index ON market_items(object_id, object_type)
                                            *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE UNIQUE INDEX tagTitleIndex ON tag(title, type)
                                     *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE UNIQUE INDEX uc_conversation_user_index ON users_conversations(conversation_id, user_id)
                                                  *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX business_widget_index ON business_widget(user_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX contactlastupdatedatindex ON contacts(last_updated_at)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX contactsphoneindex ON contacts(phone)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX contactsuserexistedindex ON contacts(user_id, existed_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX conversationdialogidindex ON conversations(dialog_id)
                                          *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX conversationlastupdatedatindex ON conversations(last_updated_at)
                                               *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX device_token_index ON devices(token)
                                   *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX device_user_index ON devices(user_id)
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX idx_channel_tokens_user_id ON channel_tokens(user_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX idx_user_id ON merchant_order(user_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX imfdtokenmessageid ON messages_for_deliveries(channel_token_id, external_id)
                                   *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX imfdtokenread ON messages_for_deliveries(channel_token_id, is_read)
                              *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX imoconversationid ON merchant_order(conversation_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX imolastupdatedat ON merchant_order(last_updated_at)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX impidnativeid ON merchant_products(user_id, native_id)
                              *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX implastupdatedat ON merchant_products(last_updated_at)
                                 *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX ipoorderid ON product_order(order_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX ipoproduct_id ON product_order(product_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX istrtokenstaffid ON staff_token_records(staff_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX marketitemslastupdatedatindex ON market_items(last_updated_at)
                                              *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX messageconversationindex ON messages(conversation_id, id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX payamentshistorypaymentidindex ON payments_history(payment_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX paymentrequestsmessageidindex ON payment_requests(message_id)
                                              *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX paymentrequestspaymentidindex ON payment_requests(payment_id)
                                              *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX tagrelationidindex ON tag_relation(tag_id)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX tagrelationobjectindex ON tag_relation(object_id, object_type)
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



1 row created.

CREATE INDEX uc_dialog_id_index ON users_conversations(dialog_id)
                                   *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX uc_user_index ON users_conversations(user_id)
                              *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX userlastupdatedatindex ON users(last_updated_at)
                                       *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

CREATE INDEX widget_user_index ON widgets(user_id)
                                  *
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.

ALTER TABLE conversations ADD CONSTRAINT conversationdialogconstrained UNIQUE (random_id, conversation_type)
*
ERROR at line 1:
ORA-00942: table or view does not exist



1 row created.


1 row updated.