All pastes #591972 Raw Edit

Anonymous

public sql v1 · immutable
#591972 ·published 2007-06-27 14:46 UTC
rendered paste body
CREATE TABLE GLRN_Categories (	CatID int not null primary key auto_increment,	CatIsChildOf int DEFAULT 0, #( References GLRN_Categories.CatID if it is a subcategory )	CatName varchar(128),	CatDesc tinytext,	CatNumImages int,	CatLeadinImage int # ( First picture associated is the "lead-in" image, can be changed. Refs GLRN_Images.ImageID ));CREATE TABLE GLRN_Images(	ImageID int not null primary key auto_increment,	CatID int # ( References GLRN_Categories.CatID )	ImageFileName varchar(128),);CREATE TABLE GLRN_ImageMeta(	ImageMetaID int not null primary key auto_increment,	ImageID int, #( References GLRN_Images.ImageID )	ImageFileSize int,	ImageWidth int,	ImageHeight int # ( Lots to add to this table.. ));