1,143
edits
Project:Inventory system: Difference between revisions
From London Hackspace Wiki
→Database schema
m (moved Projects/Inventory system to Project:Inventory system) |
|||
| Line 103: | Line 103: | ||
resolved BOOLEAN DEFAULT NULL, -- 0 = Ignored, 1 = Done, NULL = Pending | resolved BOOLEAN DEFAULT NULL, -- 0 = Ignored, 1 = Done, NULL = Pending | ||
resolved_date DATETIME DEFAULT NULL | resolved_date DATETIME DEFAULT NULL | ||
); | |||
CREATE TABLE user ( | |||
id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, | |||
email VARCHAR(320) NOT NULL UNIQUE, | |||
password VARCHAR(512) NOT NULL | |||
); | ); | ||
</pre> | </pre> | ||
