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
|
/* ------------------------------------ */
/* Base: eData_Rev1-5 */
/* SGBD: Mysql */
/* Writer: Freddy */
/* Date: 23/04/2013 */
/* ------------------------------------ */
DROP DATABASE ebase5;
CREATE DATABASE ebase5;
CREATE TABLE ebase5.eDataStatusEnum (
DsId integer NOT NUll AUTO_INCREMENT,
DsName varchar(64) NOT NULL,
DsEnumList varchar(400) NOT NULL,
PRIMARY KEY (DsId),
UNIQUE (DsId)
);
CREATE TABLE ebase5.eDatas (
DaId integer NOT NUll AUTO_INCREMENT,
DaName varchar(64) NOT NULL,
DaSizeInByte integer,
DaSizeInBit boolean,
DaStatusEnumId integer,
DaGatewayId integer,
DaDescription varchar(256),
PRIMARY KEY (DaId),
UNIQUE (DaId),
FOREIGN KEY (DaStatusEnumId) REFERENCES ebase5.eDataStatusEnum(DsId)
);
CREATE TABLE ebase5.eDataPackets (
DpId integer NOT NUll AUTO_INCREMENT,
DpName varchar(64) NOT NULL,
DpPacketHdr integer,
DpA429Label integer(3),
DpSize integer(5),
DpRate integer(5),
PRIMARY KEY (DpId),
UNIQUE (DpId)
);
CREATE TABLE ebase5.Lru (
LruId integer NOT NULL,
LruName varchar(32) NOT NULL,
LruSide int(1) NOT NULL,
LruDescription varchar(64),
PRIMARY KEY (LruId),
UNIQUE (LruId)
); |
Partager