Imscp Table Schema (imscp)


Description

each record is one imscp resource

imscp table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
course bigint 10 0
name varchar 255
intro longtext 2147483647 null
introformat smallint 4 0
revision bigint 10 0

incremented when after each file changes, solves browser caching issues

keepold bigint 10 -1

incremented when after each file changes, solves browser caching issues

structure longtext 2147483647 null
timemodified bigint 10 0

Table contained -1 rows

imscp table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
imsc_cou_ix Performance Asc course