DATETIME NOT NULL DEFAULT GETDATE()
I have a project due for my CSIS class this week, and I would like for someone to check my final work against the instructions.
Â
ER DigramÂ
CREATE DATABASE ExpenseReporting;USE ExpenseReporting;
CREATE TABLE Asset (AssetNo INT PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR asset_seq),AssetDesc VARCHAR(255) NOT NULL);
CREATE TABLE OrgUnit (OrgNo INT PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR orgunit_seq),OrgName VARCHAR(50) NOT NULL,OrgParentNo INT,CONSTRAINT OrgParentNoFk FOREIGN KEY(OrgParentNo) REFERENCES OrgUnit);
CREATE TABLE ExpCat (ECNo INT PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR expcat_seq),ECName VARCHAR(255) NOT NULL,ECLimit DECIMAL(12,2) NOT NULL DEFAULT 0);
CREATE TABLE Users (UserNo INT PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR users_seq),UserFirstName VARCHAR(50) NOT NULL,UserLastName VARCHAR(50) NOT NULL,UserPhone VARCHAR(20),UserEmail VARCHAR(50) NOT NULL,UserOrgNo INT NOT NULL,CONSTRAINT UserEmailUK UNIQUE(UserEmail),CONSTRAINT UserOrgNoFk FOREIGN KEY(UserOrgNo) REFERENCES OrgUnit,CONSTRAINT UserEmailChk CHECK(CHARINDEX('@', UserEmail) > 0));
 CREATE TABLE ExpenseReport (ERNo INT PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR expensereport_seq),ERDesc VARCHAR(255) NOT NULL,ERSubmitDate DATETIME NOT NULL DEFAULT GETDATE(),ERStatusDate DATETIME NOT NULL DEFAULT GETDATE(),ERStatus VARCHAR(8) NOT NULL,SubmitUserNo INT NOT NULL,ApprUserNo INT,CONSTRAINT SubmitUserNoFk FOREIGN KEY(SubmitUserNo) REFERENCES Users,CONSTRAINT ApprUserNoFk FOREIGN KEY(ApprUserNo) REFERENCES Users,CONSTRAINT ERStatusChk CHECK(ERStatus IN ('PENDING', 'APPROVED', 'DENIED')),CONSTRAINT ERSubmitDateChk CHECK(ERStatusDate >= ERSubmitDate),CONSTRAINT ERStatusChk2 CHECK(ApprUserNo IS NOT NULL OR (ERStatus = 'PENDING' AND ApprUserNo IS NULL)));
CREATE TABLE ExpenseItem (EINo INT PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR expenseitem_seq),ExpDesc VARCHAR(255) NOT NULL,ExpenseDate DATETIME NOT NULL DEFAULT GETDATE(),ExpAmt DECIMAL(12,2) NOT NULL DEFAULT 0,ExpApprAmt DECIMAL(12,2) DEFAULT 0,ERNo INT NOT NULL,ECNo INT NOT NULL,AssetNo INT,CONSTRAINT ERNoFk FOREIGN KEY(ERNo) REFERENCES ExpenseReport ON DELETE CASCADE,CONSTRAINT ECNoFk FOREIGN KEY(ECNo) REFERENCES ExpCat,CONSTRAINT AssetNoFk FOREIGN KEY(AssetNo) REFERENCES Asset,CONSTRAINT ExpApprAmtChk CHECK(ExpApprAmt <= ExpAmt));CREATE TABLE BudgetItem (BINo INT PRIMARY KEY NOT NULL DEFAULT (NEXT VALUE FOR budgetitem_seq),BIYear INT NOT NULL DEFAULT 2005,BIAmt DECIMAL(12,2) NOT NULL DEFAULT 0,BIActual DECIMAL(12,2) DEFAULT 0,OrgNo INT NOT NULL,ECNo INT NOT NULL,CONSTRAINT OrgNoFk FOREIGN KEY(OrgNo) REFERENCES OrgUnit,CONSTRAINT BECNoFk FOREIGN KEY(ECNo) REFERENCES ExpCat,CONSTRAINT BIYearChk CHECK(BIYear >= 1900),CONSTRAINT BudgetItemUK UNIQUE(BIYear, OrgNo, ECNo));
ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY HH:MI:SS';
INSERT INTO Asset (AssetNo, AssetDesc) VALUES (1,'Company Car');
INSERT INTO Asset (AssetNo, AssetDesc) VALUES (2,'Company Jet');
INSERT INTO Asset (AssetNo, AssetDesc) VALUES (3,'Company Van');
INSERT INTO Asset (AssetNo, AssetDesc) VALUES (4,'Company Truck');INSERT INTO OrgUnit (OrgNo, OrgName, OrgParentNo) VALUES (1,'Accounting', NULL );
INSERT INTO OrgUnit (OrgNo, OrgName, OrgParentNo) VALUES (2,'Sales', NULL);
INSERT INTO OrgUnit (OrgNo, OrgName, OrgParentNo) VALUES (3,'IT', NULL);
INSERT INTO OrgUnit (OrgNo, OrgName, OrgParentNo) VALUES (4,'IT Development',3);
INSERT INTO OrgUnit (OrgNo, OrgName, OrgParentNo) VALUES (5,'Accounts Receivable',1);
INSERT INTO OrgUnit (OrgNo, OrgName, OrgParentNo) VALUES (6,'IT Support',3);
INSERT INTO OrgUnit (OrgNo, OrgName, OrgParentNo) VALUES (7,'Accounts Payable',1);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (1,'Dinner',50.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (2,'Car Rental',100.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (3,'Breakfast',25.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (4,'Local Transportation',100.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (5,'Airfare',5000.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (6,'Lunch',25.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (7,'Lodging',300.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (8,'Admission Fee',2000.00);
INSERT INTO ExpCat (ECNo, ECName, ECLimit) VALUES (9,'Gas',35.00);
INSERT INTO Users (UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo) VALUES (1,'Sue','Herdon','(206) 339-3312','sherdon@org.com',3);
INSERT INTO Users (UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo) VALUES (2,'Bill','Jones','(303) 205-8833','bjones@org.com',6);
INSERT INTO Users (UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo) VALUES (3,'Joe','Smith','(303) 443-9943','jsmith@org.com',4);
INSERT INTO Users (UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo) VALUES (4,'William','Freed','(303) 445-3355','wfreed@org.com',1);
INSERT INTO Users (UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo) VALUES (5,'Sara','Jonson','(303) 445-3321','sjonson@org.com',7);
INSERT INTO Users (UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo) VALUES (6,'Tom','Sanchez','(303) 445-3322','tsanchez@org.com',5);
INSERT INTO Users (UserNo, UserFirstName, UserLastName, UserPhone, UserEmail, UserOrgNo) VALUES (7,'Marry','Blake','(303) 445-3333','mblake@org.com',2);
INSERT INTO ExpenseReport (ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo) VALUES (1,'Sales Presentation','8/10/2006','8/26/2006','APPROVED',3,4);
INSERT INTO ExpenseReport (ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo) VALUES (2,'Conference','8/16/2006','8/17/2006','APPROVED',4,4);
INSERT INTO ExpenseReport (ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo) VALUES (3,'Training Course','9/23/2006','9/25/2006','APPROVED',2,1);
INSERT INTO ExpenseReport (ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo) VALUES (4,'IT Group Lunch','9/29/2006','9/29/2006' ,'APPROVED',1,4);
INSERT INTO ExpenseReport (ERNo, ERDesc, ERSubmitDate, ERStatusDate, ERStatus, SubmitUserNo, ApprUSerNo) VALUES (5,'Sales Presentation','9/30/2006','10/1/2006','APPROVED',7,4);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES (1,'Car','8/9/2006',150.00,150.00,1,7,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES (2,'Hilton','8/9/2006',99.00,99.00,1,7,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(3,'Gas','8/9/2006',35.00,20.00,1,9,1);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(4,'Breakfast','8/10/2006',10.00,10.00,1,3,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(5,'Comfort Inn','8/16/2006',225.00,225.00,2,7,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(6,'Airfare','8/13/2006',325.00,325.00,2,5,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(7,'Dinner','8/15/2006',23.94,23.94,2,1,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(8,'Dinner','8/14/2006',32.50,32.50,2,1,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(9,'Dinner','8/13/2006',19.64,19.64,2,1,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(10,'Lunch','8/15/2006',25.00,25.00,2,6,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(11,'Breakfast','8/15/2006',10.32,10.32,2,3,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(12,'Motel 6','9/23/2006',57.95,57.95,3,7,NULL);
INSERT INTO ExpenseItem (EINo, ExpDesc, ExpenseDate,ExpAmt, ExpApprAmt, ERNo, ECNo, AssetNo) VALUES(13,'Gas','9/23/2006',15.94,15.94,3,9,3);
INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (1,2006,1,1,4000.00,76.08);
INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (2,2006,1,2,3000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (3,2006,1,3,2000.00,10.32);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (4,2006,1,4,500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (5,2006,1,5,10000.00,325.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (6,2006,1,6,2000.00,25.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (7,2006,1,7,10000.00,225.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (8,2006,1,8,6000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (9,2006,1,9,5000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (10,2006,2,1,10000.00,167.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (11,2006,2,2,7500.00,98.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (12,2006,2,3,4000.00,10.75);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (13,2006,2,4,1500.00,5.50);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (14,2006,2,5,15000.00,650.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (15,2006,2,6,5000.00,6.79);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (16,2006,2,7,12000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (17,2006,2,8,7500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (18,2006,2,9,7500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (19,2006,3,1,4000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (20,2006,3,2,3000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (21,2006,3,3,2000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (22,2006,3,4,500.00,24.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (23,2006,3,5,10000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (24,2006,3,6,2000.00,75.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (25,2006,3,7,10000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (26,2006,3,8,10000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (27,2006,3,9,5000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (28,2006,4,1,1500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (29,2006,4,2,1200.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (30,2006,4,3,1000.00,10.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (31,2006,4,4,250.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (32,2006,4,5,4000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (33,2006,4,6,1500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (34,2006,4,7,2000.00,99.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (35,2006,4,8,8000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (36,2006,4,9,650.00,35.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (37,2006,5,1,1500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (38,2006,5,2,1200.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (39,2006,5,3,1000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (40,2006,5,4,250.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (41,2006,5,5,4000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (42,2006,5,6,1500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (43,2006,5,7,2000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (44,2006,5,8,5500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (45,2006,5,9,350.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (46,2006,6,1,1500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (47,2006,6,2,1200.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (48,2006,6,3,1000.00,2.99);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (49,2006,6,4,250.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (50,2006,6,5,4000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (51,2006,6,6,1500.00,5.95);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (52,2006,6,7,2000.00,57.95);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (53,2006,6,8,5500.00,1000.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (54,2006,6,9,350.00,15.94);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (55,2006,7,1,1500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (56,2006,7,2,1200.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (57,2006,7,3,1000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (58,2006,7,4,250.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (59,2006,7,5,4000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (60,2006,7,6,1500.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (61,2006,7,7,2000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (62,2006,7,8,8000.00,0.00);INSERT INTO BudgetItem (BINo, BIYear, OrgNo, ECNo, BIAmt, BIActual) VALUES (63,2006,7,9,650.00,0.00);
DROP SEQUENCE expenseitem_seq;DROP SEQUENCE expensereport_seq;DROP SEQUENCE users_seq;DROP SEQUENCE asset_seq;Â DROP SEQUENCE orgunit_seq;DROP SEQUENCE expcat_seq;DROP SEQUENCE budgetitem_seq;
CREATE SEQUENCE asset_seq START WITH 100 INCREMENT BYÂ 1;CREATE SEQUENCE orgunit_seq START WITH 100 INCREMENT BYÂ 1;CREATE SEQUENCE expcat_seq START WITH 100 INCREMENT BYÂ 1;CREATE SEQUENCE users_seq START WITH 100 INCREMENT BYÂ 1;CREATE SEQUENCE expensereport_seq START WITH 100 INCREMENT BYÂ 1;CREATE SEQUENCE expenseitem_seq START WITH 100 INCREMENT BYÂ 1;CREATE SEQUENCE budgetitem_seq START WITH 100 INCREMENT BYÂ 1;
   Â
          Â
Attachments:
Answers
Status NEW
Posted 26 Mar 2018 01:03 PM
My Price 10.00
 ----------- He-----------llo----------- Si-----------r/M-----------ada-----------m ----------- ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------
Not Rated(0)