Refactor database structure to fit the current model

[Raph1105]

[Raph1105]

USE tecmarket;

-- Table structure for table 'Address' -- CREATE TABLE IF NOT EXISTS Address( AddressID int(5) NOT NULL, Apt varchar(5) DEFAULT NULL, StreetNumber int(6) NOT NULL, Street varchar(30) NOT NULL, City varchar(30) NOT NULL, ZIP varchar(6) NOT NULL, Cojuntry varchar(30) NOT NULL,

PRIMARY KEY (AddressID) );

-- Table structure for table 'Users' -- CREATE TABLE IF NOT EXISTS Users( UserID int(9) NOT NULL, Username varchar(10) NOT NULL, UserPassword varchar(10) NOT NULL, FirstName varchar(20) NOT NULL, LastName varchar(20) NOT NULL, AddressID int(5) NOT NULL, EmailAdress varchar(30) NOT NULL, PhoneNumber long NOT NULL, Administrator boolean NOT NULL, PRIMARY KEY (UserID), FOREIGN KEY (AddressID) REFERENCES Address (AddressID) ON DELETE CASCADE ON UPDATE CASCADE );

-- Table structure for table 'Catalogue' -- CREATE TABLE IF NOT EXISTS Products( SerialNumber int(9) NOT NULL, ModelNumber int(9) NOT NULL, Available boolean, PRIMARY KEY (SerialNumber, ModelNumber), FOREIGN KEY (ModelNumber) REFERENCES Models (ModelNumber) ON UPDATE CASCADE ON DELETE CASCADE );

-- Table structure for table 'Television' -- CREATE TABLE IF NOT EXISTS Models( ModelNumber varchar(10) NOT NULL, ProcessorType varchar(20), RAMSize long, NumberOfCores int(5), HardDriveSize long, TelevisionType varchar(5), Size double, DisplaySize double, HadCamera boolean, TouchScreen boolean, OperatingSystem varchar(20), BatteryInfo varchar(20), Dimensions double NOT NULL, Weight double NOT NULL, BrandName varchar(20) NOT NULL, Price double(10,2) NOT NULL, ProductName varchar(45) NOT NULL, PRIMARY KEY (ModelNumber) );

-- Table structure for table 'UserActivity' -- CREATE TABLE UserActivity( UserID int(9) NOT NULL, LoginTimestamp timestamp, IsActive boolean, PRIMARY KEY (UserID), FOREIGN KEY (UserID) REFERENCES Users (UserID) ON UPDATE CASCADE );

[Raph1105]

see https://github.com/kpamela/SOEN343/pull/65