lab_local.sqlce


CREATE TABLE [task] (
  [local_id] int IDENTITY (1,1) NOT NULL
, [task] ntext NULL
, [state] nchar(20) NULL
, [result_loc] ntext NULL
, [start] datetime NULL
, [finish] datetime NULL
, [series] ntext NULL
, [server_id] int NULL
, [result_ids] ntext NULL
, [is_update] nchar(10) NULL
, [ap] ntext NULL
);
GO
CREATE TABLE [pwr] (
  [Id] int IDENTITY (1,1) NOT NULL
, [action] ntext NOT NULL
, [state] int NOT NULL
, [task_id] int NOT NULL
, [task] ntext NOT NULL
, [time] datetime NOT NULL
);
GO
CREATE TABLE [info] (
  [Id] int IDENTITY (1,1) NOT NULL
, [platform] ntext NULL
, [os] nchar(100) NULL
, [image] nchar(100) NULL
, [bios] nchar(100) NULL
, [wlan_hwid] ntext NULL
, [wlan_driver] nchar(20) NULL
, [lan_hwid] ntext NULL
, [lan_driver] nchar(20) NULL
, [nfc_hwid] ntext NULL
, [nfc_driver] nchar(20) NULL
, [rfid_hwid] ntext NULL
, [rfid_driver] nchar(20) NULL
, [bt_hwid] ntext NULL
, [bt_driver] nchar(20) NULL
, [wwan_hwid] ntext NULL
, [wwan_ude] ntext NULL
, [wwan_gnss] ntext NULL
, [wwan_firmware] ntext NULL
, [wwan_driver] nchar(20) NULL
, [change] datetime NULL
);
GO
ALTER TABLE [task] ADD CONSTRAINT [PK_task] PRIMARY KEY ([local_id]);
GO
ALTER TABLE [pwr] ADD CONSTRAINT [PK_pwr] PRIMARY KEY ([Id]);
GO
ALTER TABLE [info] ADD CONSTRAINT [PK_info] PRIMARY KEY ([Id]);
GO