duynv9x
Tổng số bài gửi : 62 Points : 182 Reputation : 2 Join date : 07/04/2011 Age : 33 Đến từ : Nam Định
| | Code tao csdl_môn họ Hệ quản trị cơ sở dữ liệu | |
Link download:[You must be registered and logged in to see this link.]
Create database qlvattu on primary (Name=qlvattu_data, Filename='G:\qlvattu.MDF', Size=50MB, Maxsize=200MB, FileGrowth=10%) Log on (Name=qlvattu_Log, Filename='G:\qlvattu.LDF', Size=10MB, Maxsize=Unlimited, Filegrowth=5MB) go use qlvattu if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTDONDH_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[CTDONDH] DROP CONSTRAINT FK_CTDONDH_VATTU GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPNHAP_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[CTPNHAP] DROP CONSTRAINT FK_CTPNHAP_VATTU GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPxuat_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[CTPxuat] DROP CONSTRAINT FK_CTPxuat_VATTU GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Ton Kho_VATTU]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[TonKho] DROP CONSTRAINT FK_Ton Kho_VATTU GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_DONDH_NHACC]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[DONDH] DROP CONSTRAINT FK_DONDH_NHACC GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPxuat_PXUAT]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[CTPxuat] DROP CONSTRAINT FK_CTPxuat_PXUAT GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTDONDH_DONDH]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[CTDONDH] DROP CONSTRAINT FK_CTDONDH_DONDH GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_PNHAP_DONDH]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[PNHAP] DROP CONSTRAINT FK_PNHAP_DONDH GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_CTPNHAP_PNHAP]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[CTPNHAP] DROP CONSTRAINT FK_CTPNHAP_PNHAP GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CTPNHAP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CTPNHAP] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CTDONDH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CTDONDH] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PNHAP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PNHAP] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CTPxuat]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[CTPxuat] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DONDH]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[DONDH] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TonKho]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TonKho] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VATTU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[VATTU] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NHACC]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[NHACC] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PXUAT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[PXUAT] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[temp1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[temp1] GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[vattu_temp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[vattu_temp] GO
CREATE TABLE [dbo].[VATTU] ( [mavtu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [tenvtu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [dvtinh] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [phantram] [real] NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[NHACC] ( [MANHCC] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [TENNHACC] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DIACHI] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [DIENTHOAI] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[PXUAT] ( [SoPx] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Ngayxuat] [datetime] NULL , [TenKh] [char] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[temp1] ( [tenvtu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [mavtu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [sopx] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [dgxuat] [money] NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[vattu_temp] ( [mavtu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [tenvtu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[CTPxuat] ( [SoPx] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [MaVTu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [Slxuat] [int] NULL , [Dgxuat] [money] NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[DONDH] ( [SODH] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [NGAYDH] [datetime] NULL , [MANHACC] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[TonKho] ( [NamThang] [char] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [MaVTu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SLDau] [int] NULL , [TongSLN] [int] NULL , [TongSLX] [int] NULL , [SLCuoi] [int] NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[CTDONDH] ( [SODH] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [MAVTU] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SLDAT] [int] NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[PNHAP] ( [SOPN] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [NGAYNHAP] [datetime] NULL , [SODH] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY] GO
CREATE TABLE [dbo].[CTPNHAP] ( [SoPn] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [MavTu] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [SlNhap] [int] NULL , [DgNhap] [money] NULL ) ON [PRIMARY] GO
ALTER TABLE [dbo].[VATTU] WITH NOCHECK ADD CONSTRAINT [PK_VATTU] PRIMARY KEY CLUSTERED ( [mavtu] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[NHACC] WITH NOCHECK ADD CONSTRAINT [PK__NHACC__1A14E395] PRIMARY KEY CLUSTERED ( [MANHCC] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[PXUAT] WITH NOCHECK ADD CONSTRAINT [PK_PXUAT] PRIMARY KEY CLUSTERED ( [SoPx] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[CTPxuat] WITH NOCHECK ADD CONSTRAINT [PK_CTPxuat] PRIMARY KEY CLUSTERED ( [SoPx], [MaVTu] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[DONDH] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [SODH] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[TonKho] WITH NOCHECK ADD CONSTRAINT [PK_Ton Kho] PRIMARY KEY CLUSTERED ( [NamThang], [MaVTu] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[CTDONDH] WITH NOCHECK ADD CONSTRAINT [PK_CTDONDH] PRIMARY KEY CLUSTERED ( [SODH], [MAVTU] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[PNHAP] WITH NOCHECK ADD PRIMARY KEY CLUSTERED ( [SOPN] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[CTPNHAP] WITH NOCHECK ADD CONSTRAINT [PK_CTPNHAP] PRIMARY KEY CLUSTERED ( [SoPn], [MavTu] ) ON [PRIMARY] GO
ALTER TABLE [dbo].[CTPxuat] ADD CONSTRAINT [FK_CTPxuat_PXUAT] FOREIGN KEY ( [SoPx] ) REFERENCES [dbo].[PXUAT] ( [SoPx] ), CONSTRAINT [FK_CTPxuat_VATTU] FOREIGN KEY ( [MaVTu] ) REFERENCES [dbo].[VATTU] ( [mavtu] ) GO
ALTER TABLE [dbo].[DONDH] ADD CONSTRAINT [FK_DONDH_NHACC] FOREIGN KEY ( [MANHACC] ) REFERENCES [dbo].[NHACC] ( [MANHCC] ) GO
ALTER TABLE [dbo].[TonKho] ADD CONSTRAINT [FK_Ton Kho_VATTU] FOREIGN KEY ( [MaVTu] ) REFERENCES [dbo].[VATTU] ( [mavtu] ) GO
ALTER TABLE [dbo].[CTDONDH] ADD CONSTRAINT [FK_CTDONDH_DONDH] FOREIGN KEY ( [SODH] ) REFERENCES [dbo].[DONDH] ( [SODH] ), CONSTRAINT [FK_CTDONDH_VATTU] FOREIGN KEY ( [MAVTU] ) REFERENCES [dbo].[VATTU] ( [mavtu] ) GO
ALTER TABLE [dbo].[PNHAP] ADD CONSTRAINT [FK_PNHAP_DONDH] FOREIGN KEY ( [SODH] ) REFERENCES [dbo].[DONDH] ( [SODH] ) GO
ALTER TABLE [dbo].[CTPNHAP] ADD CONSTRAINT [FK_CTPNHAP_PNHAP] FOREIGN KEY ( [SoPn] ) REFERENCES [dbo].[PNHAP] ( [SOPN] ), CONSTRAINT [FK_CTPNHAP_VATTU] FOREIGN KEY ( [MavTu] ) REFERENCES [dbo].[VATTU] ( [mavtu] ) GO
| |
|