Super market数据库文件.sql
Upload User: nbcygd
Upload Date: 2008-07-25
Package Size: 2566k
Code Size: 2k
Category:

SQL Server

Development Platform:

C#

  1. use master
  2. go
  3. if exists(select * from sysdatabases where name='wkdl')
  4. begin
  5. drop database wkdl
  6. create database wkdl
  7. on primary
  8. (
  9. name='wkdl_data',
  10. filename='D:wkdl.mdf',
  11. size=3,
  12. filegrowth=15%
  13. )
  14. log on
  15. (
  16. name='wkdl_log',
  17. filename='D:wkdl.ldf',
  18. size=3,
  19. filegrowth=15%
  20. )
  21. end
  22. else
  23. begin
  24. create database wkdl
  25. on primary
  26. (
  27. name='wkdl_data',
  28. filename='D:wkdl.mdf',
  29. size=3,
  30. filegrowth=15%
  31. )
  32. log on
  33. (
  34. name='MyQQ_log',
  35. filename='D:wkdl.ldf',
  36. size=3,
  37. filegrowth=15%
  38. )
  39. end
  40. go
  41. use wkdl
  42. go
  43. create table userlogin
  44. (
  45. uid int identity(1,1),
  46. uName varchar(50) not null,
  47. uPassword varchar(50) not null,
  48. usa varchar(50) not null
  49. )
  50. go
  51. alter table userlogin
  52. add constraint pk_id primary key (uName)
  53. go
  54. create table ware
  55. (
  56. [Id] int identity(1,1),
  57. wareName varchar(20) not null,
  58. price decimal(18,2) not null,
  59. entries int not null,
  60. [keep] int not null
  61. )
  62. go
  63. alter table ware
  64. add constraint qk_id primary key (wareName)
  65. go
  66. --添加数据
  67. insert into userlogin (uName,uPassword,usa) values('wdxg','ayjl','管理员')
  68. insert into userlogin (uName,uPassword,usa) values('sa','.','管理员')
  69. insert into userlogin (uName,uPassword,usa) values('test','test','员工')
  70. insert into userlogin (uName,uPassword,usa) values('super','super','员工')
  71. go
  72. insert into ware (wareName,price,entries,[keep]) values('火龙果',1.22,120,12)
  73. insert into ware (wareName,price,entries,[keep]) values('黄瓜',2.22,22,1)
  74. insert into ware (wareName,price,entries,[keep]) values('土豆',3.33,0,2)
  75. insert into ware (wareName,price,entries,[keep]) values('番茄',4.44,2,3)
  76. insert into ware (wareName,price,entries,[keep]) values('西瓜',5.55,14,4)
  77. insert into ware (wareName,price,entries,[keep]) values('胡萝卜',6.66,52,5)
  78. insert into ware (wareName,price,entries,[keep]) values('苦瓜',7.77,9,6)
  79. insert into ware (wareName,price,entries,[keep]) values('葡萄',8.88,0,8)
  80. go