Woozle: more

2015-06-28T16:40:40Z

← Older revision		Revision as of 16:40, 28 June 2015
Line 6:		Line 6:
	CREATE TABLE `snorp_story` (		CREATE TABLE `snorp_story` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
			ID_USER INT NOT NULL COMMENT "every Story is owned by a User; Users can have zero or more Stories",
			Title VARCHAR(64) NOT NULL COMMENT "title for use in lists and page headers",
			Summary // currently arguing with myself about how this should work
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;		ENGINE = MYISAM;
	</mysql>		</mysql>

Woozle: starting to sketch this out

2015-06-28T16:01:40Z

starting to sketch this out

New page

==About==
* '''Purpose''': each record is the root node for a {{l/same|Story}}.
==SQL==

<mysql>
CREATE TABLE `snorp_story` (
`ID` INT NOT NULL AUTO_INCREMENT,

PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;
</mysql>

User:Woozle/Snorp/design/snorp story - Revision history

Woozle: more

Woozle: starting to sketch this out