You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
16 lines
416 B
MySQL
16 lines
416 B
MySQL
|
10 years ago
|
CREATE TABLE IF NOT EXISTS `relay` (
|
||
|
|
`id` bigint(20) NOT NULL,
|
||
|
|
`user_id` bigint(20) NOT NULL,
|
||
|
|
`source_node_id` bigint(20) NOT NULL,
|
||
|
|
`dist_node_id` bigint(20) NOT NULL,
|
||
|
|
`dist_ip` text NOT NULL,
|
||
|
|
`port` int(11) NOT NULL,
|
||
|
|
`priority` int(11) NOT NULL
|
||
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
||
|
|
|
||
|
|
ALTER TABLE `relay`
|
||
|
|
ADD PRIMARY KEY (`id`);
|
||
|
|
|
||
|
|
ALTER TABLE `relay`
|
||
|
|
MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
|