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
|
CREATE TABLE Tservices (
pkservices INTEGER IDENTITY(0,1) NOT NULL,
nomservice VARCHAR(30) NOT NULL,
fksites INTEGER,
PRIMARY KEY (pkservices)
)
GO
CREATE TABLE Tpersonnes (
pkpersonnes INTEGER IDENTITY(0,1) NOT NULL,
nom VARCHAR(40) NOT NULL,
prenom VARCHAR(40) NOT NULL,
mdp VARCHAR(20) NOT NULL,
mail VARCHAR(50),
bip VARCHAR(10),
telephone VARCHAR(20),
photo VARCHAR(40),
persvues INTEGER DEFAULT 0 NOT NULL,
statut BIT DEFAULT 1 NOT NULL,
fkservices INTEGER,
fkcivilite INTEGER,
fkroles INTEGER,
PRIMARY KEY (pkpersonnes)
)
GO
CREATE TABLE Tnews (
pknews INTEGER IDENTITY(0,1) NOT NULL,
titrenews VARCHAR(40) NOT NULL,
description VARCHAR(3000) NOT NULL,
datenews DATETIME NOT NULL,
nbvues INTEGER DEFAULT 0 NOT NULL,
fkpersonnes INTEGER,
fkdescriptions INTEGER,
PRIMARY KEY (pknews)
)
GO |
Partager