1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
| Line 43: | Line 43: | ||
<pre> | <pre> | ||
CREATE TABLE category ( | CREATE TABLE category ( | ||
id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT | id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | ||
title VARCHAR(255) NOT NULL | title VARCHAR(255) NOT NULL, | ||
parent TINYINT UNSIGNED | parent TINYINT UNSIGNED | ||
); | ); | ||
| Line 100: | Line 100: | ||
item MEDIUMINT UNSIGNED NOT NULL, -- item.id | item MEDIUMINT UNSIGNED NOT NULL, -- item.id | ||
resolved BOOLEAN DEFAULT NULL, -- 0 = Ignored, 1 = Done, NULL = Pending | resolved BOOLEAN DEFAULT NULL, -- 0 = Ignored, 1 = Done, NULL = Pending | ||
resolved_date | resolved_date DATETIME DEFAULT NULL | ||
); | ); | ||
</pre> | </pre> | ||
