ubuntu安装php5出现问题
代码:
-- 厂家表
CREATE TABLE Vender (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name CHAR( 32 ) NOT NULL
UNIQUE,
Show BOOLEAN NOT NULL
DEFAULT ( TRUE )
);
-- 产品类型表
CREATE TABLE ProductType (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name CHAR( 32 ) NOT NULL
UNIQUE
);
-- 产品表
CREATE TABLE Product (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
V_Id INTEGER NOT NULL
REFERENCES Vender ( Id ) ON DELETE NO ACTION
ON UPDATE CASCADE,
PT_Id INTEGER NOT NULL
REFERENCES ProductType ( Id ) ON DELETE NO ACTION
ON UPDATE CASCADE,
Show BOOLEAN NOT NULL
DEFAULT ( TRUE ),
UNIQUE ( V_Id, PT_Id )
);
-- 产品价格表
CREATE TABLE ProductValue (
P_Id INTEGER NOT NULL
REFERENCES Product ( Id ) ON DELETE NO ACTION
ON UPDATE CASCADE,
Value NUMERIC NOT NULL,
VDate DATE NOT NULL,
UNIQUE ( P_Id, VDate )
);
CREATE TABLE Vender (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name CHAR( 32 ) NOT NULL
UNIQUE,
Show BOOLEAN NOT NULL
DEFAULT ( TRUE )
);
-- 产品类型表
CREATE TABLE ProductType (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
Name CHAR( 32 ) NOT NULL
UNIQUE
);
-- 产品表
CREATE TABLE Product (
Id INTEGER PRIMARY KEY AUTOINCREMENT,
V_Id INTEGER NOT NULL
REFERENCES Vender ( Id ) ON DELETE NO ACTION
ON UPDATE CASCADE,
PT_Id INTEGER NOT NULL
REFERENCES ProductType ( Id ) ON DELETE NO ACTION
ON UPDATE CASCADE,
Show BOOLEAN NOT NULL
DEFAULT ( TRUE ),
UNIQUE ( V_Id, PT_Id )
);
-- 产品价格表
CREATE TABLE ProductValue (
P_Id INTEGER NOT NULL
REFERENCES Product ( Id ) ON DELETE NO ACTION
ON UPDATE CASCADE,
Value NUMERIC NOT NULL,
VDate DATE NOT NULL,
UNIQUE ( P_Id, VDate )
);
厂家名,产品类型名,最新报价,定价日期
代码:
SELECT Vender.Name,
ProductType.Name,
ProductValue.Value,
ProductValue.VDate
FROM ……此处该如何写?
ProductType.Name,
ProductValue.Value,
ProductValue.VDate
FROM ……此处该如何写?
作者: 自由建客 发布时间: 2011-06-07