X-Git-Url: http://shamusworld.gotdns.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=database-schema.txt;fp=database-schema.txt;h=7bfb70953ab31d1d28db97791570a7c876b20a5f;hb=6df1a447a1fa1b9e51fd177a806f910813657b09;hp=3b5a34bafb70a1671cf2d6f6cd77f2d35f746cbb;hpb=f3116511d09acfd5b32d3412c82c4337d89f2ad9;p=schematic diff --git a/database-schema.txt b/database-schema.txt index 3b5a34b..7bfb709 100644 --- a/database-schema.txt +++ b/database-schema.txt @@ -8,7 +8,7 @@ VID (P-key) | VLID | signedNDA | Name CREATE TABLE Vendor (vid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, vlid INT, signedNDA TINYINT(1) NOT NULL DEFAULT 0, name VARCHAR(100), FOREIGN KEY (vlid) REFERENCES VendorLevel(vlid)) ENGINE=INNODB; VendorLevel -VLID (P-key) | VendorUseable | Color | Description +VLID (P-key) | VendorUsable | Color | Description CREATE TABLE VendorLevel (vlid INT NOT NULL PRIMARY KEY AUTO_INCREMENT, vendorUsable TINYINT(1) NOT NULL DEFAULT 0, color INT(4), description VARCHAR(100)) ENGINE=INNODB; VendorType