1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
| -- ----------------------------
-- Table structure for GPSDevice
-- ----------------------------
DROP TABLE [dbo].[GPSDevice]
GO
CREATE TABLE [dbo].[GPSDevice] (
[pkId] int NOT NULL IDENTITY(1,1) ,
[DeviceSN] varchar(32) NOT NULL ,
[DeviceName] varchar(50) NULL ,
[Comment] varchar(200) NULL ,
[M2MCardID] int NULL
)
GO
DBCC CHECKIDENT(N'[dbo].[GPSDevice]', RESEED, 59)
GO
-- ----------------------------
-- Indexes structure for table GPSDevice
-- ----------------------------
CREATE UNIQUE INDEX [IX_UniqueM2M] ON [dbo].[GPSDevice]
([M2MCardID] ASC)
WHERE ([M2MCardID] IS NOT NULL)
WITH (IGNORE_DUP_KEY = ON)
GO
CREATE UNIQUE INDEX [IX_DeviceSN] ON [dbo].[GPSDevice]
([DeviceSN] ASC)
WITH (IGNORE_DUP_KEY = ON)
GO
-- ----------------------------
-- Primary Key structure for table GPSDevice
-- ----------------------------
ALTER TABLE [dbo].[GPSDevice] ADD PRIMARY KEY ([pkId])
GO
-- ----------------------------
-- Table structure for Vehicle
-- ----------------------------
DROP TABLE [dbo].[Vehicle]
GO
CREATE TABLE [dbo].[Vehicle] (
[pkId] int NOT NULL IDENTITY(1,1) ,
[VehicleNum] int NULL ,
[DeviceID] int NULL ,
[Matriculation] varchar(50) NOT NULL ,
[ChauffeurPkID] int NULL ,
[Model] varchar(200) NULL ,
[TraceColor] int NULL ,
[M3] decimal(8,2) NULL ,
[MTM] int NULL ,
[Chassis] varchar(32) NULL ,
[Motor] varchar(32) NULL ,
[Brand] varchar(32) NULL ,
[Olie] varchar(16) NULL ,
[Euronorm] varchar(24) NULL ,
[DateConstruction] datetime NULL ,
[DateBatterie] datetime NULL ,
[DateNextKeuring] datetime NULL ,
[TotKm] int NULL ,
[KmNextMaintenance] int NULL ,
[nbKeys] int NULL ,
[DateEurovignet] datetime NULL ,
[DateAssurance] datetime NULL ,
[DateTax] datetime NULL ,
[TankKaartRef] varchar(50) NULL ,
[TankKaartCode] varchar(50) NULL
)
GO
DBCC CHECKIDENT(N'[dbo].[Vehicle]', RESEED, 51)
GO
-- ----------------------------
-- Indexes structure for table Vehicle
-- ----------------------------
CREATE UNIQUE INDEX [IX_DeviceID] ON [dbo].[Vehicle]
([DeviceID] ASC)
WHERE ([deviceId]>=(0))
WITH (IGNORE_DUP_KEY = ON)
GO
CREATE INDEX [IX_ChauffeurID] ON [dbo].[Vehicle]
([ChauffeurPkID] ASC)
GO |
Partager