CREATE TABLE wallet_options (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    walletId INT NOT NULL,
    wallet_address VARCHAR(255) NOT NULL,
    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);


ALTER TABLE users 
ADD COLUMN subscription_slot VARCHAR(10) NULL AFTER phone;
ADD COLUMN lock_period VARCHAR(10) NULL AFTER subscription_slot;


ALTER TABLE applications 
ADD COLUMN daily_limit VARCHAR(10) NULL AFTER paymentOptions;
ADD COLUMN monthly_limit VARCHAR(10) NULL AFTER daily_limit;


CREATE TABLE cryptocurrencies (
    $table->id();
    $table->string('name'); // Unique name for createOrUpdate logic
    $table->string('symbol');
    $table->string('image')->nullable();
    $table->string('network')->nullable();
    $table->decimal('price', 16, 4)->default(0.0000);
    $table->timestamp('createdAt')->default(DB::raw('CURRENT_TIMESTAMP'));
    $table->timestamp('updatedAt')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
);



CREATE TABLE crypto_balances (
    $table->id();
    $table->string('currency_id')->nullable();
    $table->string('user_id')->nullable();
    $table->decimal('balance', 16, 8)->default(0.00);
    $table->timestamp('createdAt')->default(DB::raw('CURRENT_TIMESTAMP'));
    $table->timestamp('updatedAt')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
);


CREATE TABLE crypto_options (
    $table->id();
    $table->integer("network_id");
    $table->string("network_address");
    $table->timestamp('createdAt')->default(DB::raw('CURRENT_TIMESTAMP'));
    $table->timestamp('updatedAt')->default(DB::raw('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'));
);