WorkFerret/tables/project

From Woozle Writes Code
< WorkFerret‎ | tables
Revision as of 00:22, 29 January 2010 by Woozle (talk | contribs) (Created page with '==About== * '''History''': ** '''2010-01-28''' Adapted from MS Access version ==SQL== <mysql>DROP TABLE IF EXISTS `project`; CREATE TABLE `project` ( `ID` INT(4) NO…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • History:
    • 2010-01-28 Adapted from MS Access version

SQL

<mysql>DROP TABLE IF EXISTS `project`; CREATE TABLE `project` (

 `ID`       INT(4)      NOT NULL AUTO_INCREMENT,
 `ID_Client INT(4)  DEFAULT NULL COMMENT "Client who owns this project",
 `Name`     VARCHAR(63) NOT NULL COMMENT "Name of project",
 PRIMARY KEY(`ID`)

) ENGINE=MyISAM;</mysql>