summaryrefslogblamecommitdiff
path: root/migrations/20231009123228_devices.sql
blob: d36946cdd05612e97a5a7af8889c3aafa65906e6 (plain) (tree)
1
2
3
4
5
6
7
8
9
                            
                                    
 


                                                          

                                             
 
-- Add migration script here
CREATE TABLE IF NOT EXISTS "devices"
(
    "id"                VARCHAR(255) PRIMARY KEY NOT NULL,
    "mac"               VARCHAR(17) NOT NULL,
    "broadcast_addr"    VARCHAR(39) NOT NULL,
    "ip"                VARCHAR(39) NOT NULL,
    "times"             BIGINT[]
)