vladimirbiro/article-manager

dev-master 2017-11-09 11:24 UTC

Requires

• nette/bootstrap: ^2.4
• nette/database: ^2.4
• nette/di: ^2.4
• nette/robot-loader: ^3.0
• tracy/tracy: ^2.4

Requires (Dev)

• nette/tester: ^2.0

BSD-3-Clause, GPL-2.0, GPL-3.0

• Vladimír Bíro

README

Inštalácia

composer require vladimirbiro/article-manager:dev-master

Vytvorenie tabulky produktov

CREATE TABLE `article` (
  `id_article` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `description` text,
  `id_manufacturer` int(11) DEFAULT NULL,
  `price` float NOT NULL DEFAULT '0' COMMENT 'Cena',
  `q` int(11) DEFAULT NULL COMMENT 'Pocet kusov',
  `time_add` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Cas pridania produktu',
  `is_public` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Verejny / Sukromny',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Vymazany',
  PRIMARY KEY (`id_article`)
);

Tabulka obsahuje iba nevyhnutné údaje. Je možné ju rozšíriť o ďalšie stĺpce.