相关代码 |
|
CREATE TABLE recordings( recordingid INT NOT NULL , recordingtitle VARCHAR(50), publisherid INT, catalognumber VARCHAR(20), recordingformatid INT DEFAULT 1 NOT NULL, releasedate DATE, languageid INT DEFAULT 1 NOT NULL, listprice DOUBLE PRECISION, coverimagefilespec VARCHAR(50) );