1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
| Line 42: | Line 42: | ||
<pre> | <pre> | ||
CREATE TABLE category ( | CREATE TABLE category ( | ||
id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY_KEY, | id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY_KEY, | ||
title VARCHAR(255) | title VARCHAR(255) NOT NULL | ||
); | ); | ||
| Line 79: | Line 79: | ||
CREATE TABLE queue ( | CREATE TABLE queue ( | ||
id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | ||
title VARCHAR(255) | title VARCHAR(255) NOT NULL | ||
); | ); | ||
