Forum PHP.pl

[PHP] pobierz, plaintext 
/**
 * DaneSprzedawcy
 *
 * @ORM\Table(name="dane_sprzedawcy")
 * @ORM\Entity
 */
class DaneSprzedawcy
{
    /**
     * @var string
     *
     * @ORM\Column(name="nazwa", type="string", length=45, nullable=true)
     */
    private $nazwa;
 
    /**
     * @var string
     *
     * @ORM\Column(name="ulica", type="string", length=45, nullable=true)
     */
    private $ulica;
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 * @ORM\Table(name="pracownik", indexes={@ORM\Index(name="idLogin_idx", columns={"idLogin"})})
 */
class Pracownik
{
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 * @ORM\Table(name="employee", indexes={@ORM\Index(name="idLogin_idx", columns={"idLogin"})})
 */
class Employee
{
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
CREATE TABLE book (isbn VARCHAR(45) NOT NULL, idcategory INT DEFAULT NULL, created DATETIME NOT NULL, updated DATETIME NOT NULL, title VARCHAR(45) DEFAULT NULL, author VARCHAR(45) DEFAULT NULL, description TEXT DEFAULT NULL, cena NUMERIC(10, 2) DEFAULT NULL, picture VARCHAR(45) DEFAULT NULL, print VARCHAR(45) DEFAULT NULL, publishYear INT DEFAULT NULL, quantity INT NOT NULL, INDEX idCategory_idx (idCategory), PRIMARY KEY(isbn)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE category (name VARCHAR(45) DEFAULT NULL, idCategory INT AUTO_INCREMENT NOT NULL, UNIQUE INDEX UNIQ_64C19C15E237E06 (name), PRIMARY KEY(idCategory)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE client (idlogin INT DEFAULT NULL, name VARCHAR(45) NOT NULL, surname VARCHAR(45) NOT NULL, email VARCHAR(45) DEFAULT NULL, street VARCHAR(45) NOT NULL, houseNumber VARCHAR(10) NOT NULL, apartmentNumber VARCHAR(10) DEFAULT NULL, postalCode VARCHAR(6) DEFAULT NULL, city VARCHAR(45) NOT NULL, nip VARCHAR(10) DEFAULT NULL, phoneNumber VARCHAR(45) DEFAULT NULL, idClient INT AUTO_INCREMENT NOT NULL, UNIQUE INDEX UNIQ_C74404557C0DA709 (idlogin), INDEX idLogin_idx (idLogin), PRIMARY KEY(idClient)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE invoice (invoiceDate DATE DEFAULT NULL, invoiceNumber VARCHAR(45) NOT NULL, idMerchant INT DEFAULT NULL, idOrder INT DEFAULT NULL, INDEX idOrder_idx (idOrder), INDEX idMerchant_idx (idMerchant), PRIMARY KEY(invoiceNumber)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE merchant (name VARCHAR(45) DEFAULT NULL, street VARCHAR(45) DEFAULT NULL, houseNumber VARCHAR(45) DEFAULT NULL, apartmentNumber VARCHAR(45) DEFAULT NULL, postalCode VARCHAR(45) DEFAULT NULL, city VARCHAR(45) DEFAULT NULL, nip VARCHAR(45) DEFAULT NULL, phoneNumber VARCHAR(45) DEFAULT NULL, idMerchant INT AUTO_INCREMENT NOT NULL, PRIMARY KEY(idMerchant)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE `order` (orderDate DATETIME DEFAULT NULL, idOrder INT AUTO_INCREMENT NOT NULL, idClient INT DEFAULT NULL, idStatus INT DEFAULT NULL, INDEX idClient_idx (idClient), INDEX idStatus_idx (idStatus), PRIMARY KEY(idOrder)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE order_product (isbn VARCHAR(45) DEFAULT NULL, quantity INT DEFAULT NULL, productPrice NUMERIC(10, 2) DEFAULT NULL, publishYear VARCHAR(45) DEFAULT NULL, title VARCHAR(45) DEFAULT NULL, author VARCHAR(45) DEFAULT NULL, idOrderProduct INT AUTO_INCREMENT NOT NULL, idOrder INT DEFAULT NULL, INDEX idOrder_idx (idOrder), INDEX isbn_idx (isbn), PRIMARY KEY(idOrderProduct)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE shipment (cost NUMERIC(10, 2) DEFAULT NULL, nrShipments VARCHAR(45) DEFAULT NULL, invoiceNumber VARCHAR(45) DEFAULT NULL, shipmentDate DATE DEFAULT NULL, delivererPhone VARCHAR(45) DEFAULT NULL, idShipment INT AUTO_INCREMENT NOT NULL, idOrder INT DEFAULT NULL, INDEX idOrder_idx (idOrder), PRIMARY KEY(idShipment)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE book ADD CONSTRAINT FK_CBE5A331AC9951CC FOREIGN KEY (idcategory) REFERENCES category (idCategory);
ALTER TABLE client ADD CONSTRAINT FK_C74404557C0DA709 FOREIGN KEY (idlogin) REFERENCES fos_user (id);
ALTER TABLE invoice ADD CONSTRAINT FK_9065174427080FBA FOREIGN KEY (idMerchant) REFERENCES merchant (idMerchant);
ALTER TABLE invoice ADD CONSTRAINT FK_90651744E2EDD085 FOREIGN KEY (idOrder) REFERENCES `order` (idOrder);
ALTER TABLE `order` ADD CONSTRAINT FK_F5299398A455ACCF FOREIGN KEY (idClient) REFERENCES client (idClient);
ALTER TABLE `order` ADD CONSTRAINT FK_F52993981811CD86 FOREIGN KEY (idStatus) REFERENCES STATUS (idStatus);
ALTER TABLE order_product ADD CONSTRAINT FK_2530ADE6CC1CF4E6 FOREIGN KEY (isbn) REFERENCES book (isbn);
ALTER TABLE order_product ADD CONSTRAINT FK_2530ADE6E2EDD085 FOREIGN KEY (idOrder) REFERENCES `order` (idOrder);
ALTER TABLE shipment ADD CONSTRAINT FK_2CB20DCE2EDD085 FOREIGN KEY (idOrder) REFERENCES `order` (idOrder);
ALTER TABLE fos_user CHANGE username username VARCHAR(180) NOT NULL, CHANGE username_canonical username_canonical VARCHAR(180) NOT NULL, CHANGE email email VARCHAR(180) NOT NULL, CHANGE email_canonical email_canonical VARCHAR(180) NOT NULL, CHANGE confirmation_token confirmation_token VARCHAR(180) DEFAULT NULL;
CREATE UNIQUE INDEX UNIQ_957A6479C05FB297 ON fos_user (confirmation_token);
[SQL] pobierz, plaintext