Loading...
 
Skip to main content

Spreadsheet History: TIKI_TRANSITIONS

TIKI_TRANSITIONS table (testing if sheets are usable for DB table specification)
No Tabs

View

Revision: November 5th 2010 06:15:53
Revision: November 5th 2010 06:07:24
NameTypeCollationNULLDefaultConstraintsComment
transitionIdint(11)NoPK
preserveint(1)
namevarchar(50)utf8_general_ciUnique?NOT NULL, maybe UNIQUE?
typevarchar(20)utf8_general_ciNOT NULL, constrainted to a typeId
fromvarchar(255)utf8_general_ciFKshould be INT, FK constraint to TIKI_CATEGORIES.categID, NOT NULL
tovarchar(255)utf8_general_ciFKshould be INT, FK constraint to TIKI_CATEGORIES.categId, NOT NULL
guardstextutf8_general_ci
Name of object:TIKI_TRANSITION_EVENTS
Type of database object:TABLE
Order of fieldsField nameTypeDefaultConstraintsComments
Name
NameTypeCollationNULLDefaultConstraintsComment
transitionIdint(11)No-PK
preserveint(1)
namevarchar(50)utf8_general_ci-Unique?-NOT NULL, maybe UNIQUE?
typevarchar(20)utf8_general_ci-NOT NULL, constrainted to a typeId
fromvarchar(255)utf8_general_ci-FK-should be INT, FK constraint to TIKI_CATEGORIES.categID, NOT NULL
tovarchar(255)utf8_general_ci-FK-should be INT, FK constraint to TIKI_CATEGORIES.categId, NOT NULL
guardstextutf8_general_ci
Name of object:TIKI_TRANSITION_EVENTS
Type of database object:TABLE
Order of fieldsField nameTypeDefaultConstraintsComments
-Name
View Clone
View Clone
Toggle Full Screen

Date Selection

Edit Date User Actions
November 5th 2010 08:36:42 gezza View | Clone | Roll back
November 5th 2010 08:09:05 gezza View | Clone | Roll back
November 5th 2010 08:08:52 gezza View | Clone | Roll back
November 5th 2010 08:02:35 gezza View | Clone | Roll back
November 5th 2010 08:01:43 gezza View | Clone | Roll back
November 5th 2010 07:52:51 gezza View | Clone | Roll back
November 5th 2010 06:15:53 gezza View | Clone | Roll back
November 5th 2010 06:13:14 gezza View | Clone | Roll back
November 5th 2010 06:07:24 gezza View | Clone | Roll back
November 5th 2010 06:01:31 gezza View | Clone | Roll back
November 3rd 2010 08:59:59 gezza View | Clone | Roll back
November 3rd 2010 07:48:39 gezza View | Clone | Roll back
Show PHP error messages