I need help fixing my Database I have a link to my code If y

I need help fixing my Database! I have a link to my code If you could fix the code and post it that would save my life.

It fails everytime I try to alter a table!

http://ideone.com/R8noTi

Solution

It was working fine... Dont use online sql / ORACLE online editors.

This ALTER CONSTRAINT syntax wont work on online compilers. Please install database on your machine and try it.

CREATE TABLE Bid
(
Condition CHAR (10) NOT NULL CHECK ( Condition IN (\'\', \'New\', \'New in Box\', \'Used\')) ,
MinBid INTEGER NOT NULL ,
NumBids INTEGER NOT NULL ,
Item_ID VARCHAR2 (100) NOT NULL ,
Title VARCHAR2 (100) NOT NULL ,
CurrentPrice INTEGER NOT NULL ,
BuyorAuction VARCHAR2 (10) CHECK ( \'BuyorAuction\' IN (\'Auction\', \'Buy\')) ,
ShippingCost INTEGER NOT NULL ,
AuctionEnd VARCHAR2 (14) NOT NULL ,
AuctionStart VARCHAR2 (14) NOT NULL ,
Seller_ID2 VARCHAR2 (100) NOT NULL ,
Username VARCHAR2 (100) NOT NULL ,
Email VARCHAR2 (100) NOT NULL ,
Screenname VARCHAR2 (100) NOT NULL ,
Buyer_ID VARCHAR2 (100) NOT NULL ,
Username1 VARCHAR2 (100) NOT NULL ,
Screenname1 VARCHAR2 (100) NOT NULL ,
Email1 VARCHAR2 (100) NOT NULL
) ;
CREATE UNIQUE INDEX Bid__IDX ON Bid
(
Buyer_ID ASC , Username1 ASC , Screenname1 ASC , Email1 ASC
)
;
ALTER TABLE Bid ADD CONSTRAINT Bid_PK PRIMARY KEY ( Item_ID ) ;

CREATE TABLE Bid_History
(
DateofBid VARCHAR2 (14) NOT NULL ,
AmountofBid FLOAT NOT NULL ,
Win_loss VARCHAR2 (5) CHECK ( Win_loss IN (\'N\', \'No\', \'Y\', \'Yes\')) ,
HistoryBid_ID VARCHAR2 (100) NOT NULL
) ;
ALTER TABLE Bid_History ADD CONSTRAINT Bid_History_PK PRIMARY KEY ( HistoryBid_ID ) ;

CREATE TABLE Buy_History
(
dateofpurchase VARCHAR2 (14) NOT NULL ,
amountpurchase INTEGER ,
HistoryBuy_ID VARCHAR2 (100) NOT NULL
) ;
ALTER TABLE Buy_History ADD CONSTRAINT Buy_History_PK PRIMARY KEY ( HistoryBuy_ID ) ;

CREATE TABLE Buy_it_Now
(
NumofItems INTEGER ,
NumSold INTEGER NOT NULL ,
Condition CHAR (10) NOT NULL CHECK ( Condition IN (\'\', \'New\', \'New in Box\', \'Used\')) ,
Item_ID VARCHAR2 (100) NOT NULL ,
Title VARCHAR2 (100) NOT NULL ,
CurrentPrice INTEGER NOT NULL ,
BuyorAuction VARCHAR2 (10) NOT NULL CHECK ( \'BuyorAuction\' IN (\'Auction\', \'Buy it now\')) ,
ShippingCost INTEGER NOT NULL ,
Buyer_ID VARCHAR2 (100) NOT NULL ,
Username VARCHAR2 (100) NOT NULL ,
Screenname VARCHAR2 (100) NOT NULL ,
Email VARCHAR2 (100) NOT NULL
) ;
CREATE UNIQUE INDEX Buy_it_Now__IDX ON Buy_it_Now
(
Buyer_ID ASC , Username ASC , Screenname ASC , Email ASC
)
;
ALTER TABLE Buy_it_Now ADD CONSTRAINT Buy_it_Now_PK PRIMARY KEY ( Item_ID ) ;

CREATE TABLE Buyer
(
Buyer_ID VARCHAR2 (100) NOT NULL ,
Username VARCHAR2 (100) NOT NULL ,
Password VARCHAR2 (100) NOT NULL ,
FirstName VARCHAR2 (100) ,
Lastname VARCHAR2 (100) NOT NULL ,
Screenname VARCHAR2 (100) NOT NULL ,
Email VARCHAR2 (100) NOT NULL ,
Address VARCHAR2 (100) NOT NULL ,
City VARCHAR2 (100) NOT NULL ,
State CHAR (2) NOT NULL ,
Zipcode INTEGER NOT NULL ,
PhoneNum INTEGER NOT NULL ,
DateJoined VARCHAR2 (14) NOT NULL ,
BuyerRating INTEGER NOT NULL ,
NumPurchased INTEGER ,
Balance INTEGER NOT NULL ,
Payment INTEGER ,
Typeof INTEGER NOT NULL
) ;
ALTER TABLE Buyer ADD CONSTRAINT Buyer_PK PRIMARY KEY ( Buyer_ID, Username, Screenname, Email ) ;

CREATE TABLE Feedback
(
Typeof INTEGER NOT NULL ,
Both_ID VARCHAR2 (100) NOT NULL ,
Comments VARCHAR2 (100) ,
Dateof VARCHAR2 (14)
) ;
ALTER TABLE Feedback ADD CONSTRAINT Feedback_PK PRIMARY KEY ( Both_ID ) ;

CREATE TABLE Relation_10
(
Feedback_Both_ID VARCHAR2 (100) NOT NULL ,
Buyer_Buyer_ID VARCHAR2 (100) NOT NULL ,
Buyer_Username VARCHAR2 (100) NOT NULL ,
Buyer_Screenname VARCHAR2 (100) NOT NULL ,
Buyer_Email VARCHAR2 (100) NOT NULL
) ;
ALTER TABLE Relation_10 ADD CONSTRAINT Relation_10_PK PRIMARY KEY ( Feedback_Both_ID, Buyer_Buyer_ID, Buyer_Username, Buyer_Screenname, Buyer_Email ) ;

CREATE TABLE Relation_13
(
Feedback_Both_ID VARCHAR2 (100) NOT NULL ,
Sellers_Seller_ID VARCHAR2 (100) NOT NULL ,
Sellers_Username VARCHAR2 (100) NOT NULL ,
Sellers_Email VARCHAR2 (100) NOT NULL ,
Sellers_Screenname VARCHAR2 (100) NOT NULL
) ;
ALTER TABLE Relation_13 ADD CONSTRAINT Relation_13_PK PRIMARY KEY ( Feedback_Both_ID, Sellers_Seller_ID, Sellers_Username, Sellers_Email, Sellers_Screenname ) ;

CREATE TABLE Relation_20
(
Buy_it_Now_Item_ID VARCHAR2 (100) NOT NULL ,
Buy_History_HistoryBuy_ID VARCHAR2 (100) NOT NULL
) ;
ALTER TABLE Relation_20 ADD CONSTRAINT Relation_20_PK PRIMARY KEY ( Buy_it_Now_Item_ID, Buy_History_HistoryBuy_ID ) ;

CREATE TABLE Relation_21
(
Bid_Item_ID VARCHAR2 (100) NOT NULL ,
Bid_History_HistoryBid_ID VARCHAR2 (100) NOT NULL
) ;
ALTER TABLE Relation_21 ADD CONSTRAINT Relation_21_PK PRIMARY KEY ( Bid_Item_ID, Bid_History_HistoryBid_ID ) ;

CREATE TABLE Sellers
(
Seller_ID VARCHAR2 (100) NOT NULL ,
Username VARCHAR2 (100) NOT NULL ,
Password VARCHAR2 (100) NOT NULL ,
FirstName VARCHAR2 (100) NOT NULL ,
Lastname VARCHAR2 (100) NOT NULL ,
Screenname VARCHAR2 (100) NOT NULL ,
Email VARCHAR2 (100) NOT NULL ,
Address VARCHAR2 (100) NOT NULL ,
City VARCHAR2 (100) NOT NULL ,
State CHAR (2) NOT NULL ,
Zipcode INTEGER NOT NULL ,
PhoneNum INTEGER NOT NULL ,
DateJoined VARCHAR2 (14) NOT NULL ,
Seller_rating INTEGER NOT NULL ,
PostiveFeedback INTEGER ,
Numofitemssold INTEGER ,
views INTEGER ,
location VARCHAR2 (100) NOT NULL ,
Typeof INTEGER NOT NULL
) ;
ALTER TABLE Sellers ADD CONSTRAINT Sellers_PK PRIMARY KEY ( Seller_ID, Username, Email, Screenname ) ;

ALTER TABLE Bid ADD CONSTRAINT Bid_Buyer_FK FOREIGN KEY ( Buyer_ID, Username1, Screenname1, Email1 ) REFERENCES Buyer ( Buyer_ID, Username, Screenname, Email ) ;

ALTER TABLE Buy_it_Now ADD CONSTRAINT Buy_it_Now_Buyer_FK FOREIGN KEY ( Buyer_ID, Username, Screenname, Email ) REFERENCES Buyer ( Buyer_ID, Username, Screenname, Email ) ;

ALTER TABLE Relation_10 ADD CONSTRAINT FK_ASS_1 FOREIGN KEY ( Feedback_Both_ID ) REFERENCES Feedback ( Both_ID ) ;

ALTER TABLE Relation_21 ADD CONSTRAINT FK_ASS_10 FOREIGN KEY ( Bid_History_HistoryBid_ID ) REFERENCES Bid_History ( HistoryBid_ID ) ;

ALTER TABLE Relation_10 ADD CONSTRAINT FK_ASS_2 FOREIGN KEY ( Buyer_Buyer_ID, Buyer_Username, Buyer_Screenname, Buyer_Email ) REFERENCES Buyer ( Buyer_ID, Username, Screenname, Email ) ;

ALTER TABLE Relation_13 ADD CONSTRAINT FK_ASS_3 FOREIGN KEY ( Feedback_Both_ID ) REFERENCES Feedback ( Both_ID ) ;

ALTER TABLE Relation_13 ADD CONSTRAINT FK_ASS_4 FOREIGN KEY ( Sellers_Seller_ID, Sellers_Username, Sellers_Email, Sellers_Screenname ) REFERENCES Sellers ( Seller_ID, Username, Email, Screenname ) ;

ALTER TABLE Relation_20 ADD CONSTRAINT FK_ASS_7 FOREIGN KEY ( Buy_it_Now_Item_ID ) REFERENCES Buy_it_Now ( Item_ID ) ;

ALTER TABLE Relation_20 ADD CONSTRAINT FK_ASS_8 FOREIGN KEY ( Buy_History_HistoryBuy_ID ) REFERENCES Buy_History ( HistoryBuy_ID ) ;

ALTER TABLE Relation_21 ADD CONSTRAINT FK_ASS_9 FOREIGN KEY ( Bid_Item_ID ) REFERENCES Bid ( Item_ID ) ;