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
| if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_MATERIEL_CATEGORIE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[MATERIEL] DROP CONSTRAINT FK_MATERIEL_CATEGORIE
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_LIGNE_COMMANDE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[LIGNE] DROP CONSTRAINT FK_LIGNE_COMMANDE
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_COMMANDE_COMPTE]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[COMMANDE] DROP CONSTRAINT FK_COMMANDE_COMPTE
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_LIGNE_MATERIEL]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
ALTER TABLE [dbo].[LIGNE] DROP CONSTRAINT FK_LIGNE_MATERIEL
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CATEGORIE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CATEGORIE]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[COMMANDE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[COMMANDE]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[COMPTE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[COMPTE]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LIGNE]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LIGNE]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MATERIEL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MATERIEL]
GO
CREATE TABLE [dbo].[CATEGORIE] (
[IdCateg] [varchar] (2) COLLATE French_CI_AS NOT NULL ,
[nomcateg] [varchar] (50) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[COMMANDE] (
[numcom] [varchar] (50) COLLATE French_CI_AS NOT NULL ,
[email] [varchar] (50) COLLATE French_CI_AS NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[COMPTE] (
[email] [varchar] (50) COLLATE French_CI_AS NOT NULL ,
[nom] [varchar] (50) COLLATE French_CI_AS NULL ,
[mdp] [varchar] (20) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[LIGNE] (
[numcom] [varchar] (50) COLLATE French_CI_AS NOT NULL ,
[refmat] [varchar] (2) COLLATE French_CI_AS NOT NULL ,
[quant] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[MATERIEL] (
[refmat] [varchar] (2) COLLATE French_CI_AS NOT NULL ,
[des] [varchar] (50) COLLATE French_CI_AS NULL ,
[prix] [decimal](18, 0) NULL ,
[photo] [varchar] (50) COLLATE French_CI_AS NULL ,
[idCateg] [varchar] (2) COLLATE French_CI_AS NULL
) ON [PRIMARY]
GO |
Partager