Map.sql 991 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. /*
  2. Navicat SQL Server Data Transfer
  3. Source Server : 9000
  4. Source Server Version : 105000
  5. Source Host : .\sqlexpress:1433
  6. Source Database : LHBMS
  7. Source Schema : dbo
  8. Target Server Type : SQL Server
  9. Target Server Version : 105000
  10. File Encoding : 65001
  11. Date: 2021-05-11 15:33:19
  12. */
  13. -- ----------------------------
  14. -- Table structure for Map
  15. -- ----------------------------
  16. DROP TABLE [dbo].[Map]
  17. GO
  18. CREATE TABLE [dbo].[Map] (
  19. [ID] uniqueidentifier NOT NULL DEFAULT (newid()) ROWGUIDCOL ,
  20. [Name] nvarchar(50) NOT NULL ,
  21. [FileName] nvarchar(200) NULL ,
  22. [Remark] nvarchar(100) NULL ,
  23. [imgData] image NULL
  24. )
  25. GO
  26. -- ----------------------------
  27. -- Records of Map
  28. -- ----------------------------
  29. -- ----------------------------
  30. -- Indexes structure for table Map
  31. -- ----------------------------
  32. -- ----------------------------
  33. -- Primary Key structure for table Map
  34. -- ----------------------------
  35. ALTER TABLE [dbo].[Map] ADD PRIMARY KEY ([ID])
  36. GO