Displaying 1 result from an estimated 1 matches for "lastdelivery".
2006 Jan 11
1
Composite primary key
...key referencing Cookie.
Also: Thanks to Nic and Adam for helping with the Cookie -> Cooky problem.
/Hugo
--SQL
*
CREATE* *TABLE* `Raw_Materials`*
(*
id *INT* AUTO_INCREMENT*,*
`name` *VARCHAR**(*30*),*
quantity *INT**,*
lastDelivery DATETIME*,*
*PRIMARY* *KEY* *(*id*)**
);*
*CREATE* *TABLE* `Cookies`
*(*
id *INT* AUTO_INCREMENT*,*
`name` *VARCHAR**(*30*),*
*primary* *key* *(*id*)*
*);*
*CREATE* *TABLE* `Recipes`
*(*
`version` *INT**,*
co...