View and edit SQL

0 records

CREATE TABLE `twitter_login_ips` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`account_id` integer,`ip` text,`created` datetime,PRIMARY KEY (`id`),CONSTRAINT `fk_twitter_accounts_login_ips` FOREIGN KEY (`account_id`) REFERENCES `twitter_accounts`(`id`));
CREATE UNIQUE INDEX `twitter_login_ips_key` ON `twitter_login_ips`(`account_id`,`ip`,`created`);
CREATE INDEX `idx_twitter_login_ips_deleted_at` ON `twitter_login_ips`(`deleted_at`);