browse tables
create new table
db tools
manually enter SQL
version
gus_demo
:
altering table definition for lifeform
Table Name:
[
view 6 records of existing table data
] [
view SQL table definition
] [
new table
]
select
column
type
size
default
nullable
PK
auto++
more
+field
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
-none-
bit
tinyint
mediumint
int
bigint
double
decimal
float
date
datetime
timestamp
time
char
varchar
text
+
here
display name
help text
Validation Type:
none
must always fit pattern
must fit pattern if field not empty
must never fit pattern
must never fit pattern if field not...
no validation
Validation Pattern:
none
American phone
American postal code
email
five digit zipcode
URL
zip+4 zipcode
Is Invisible
true
false
Force WYSWG Editor
true
false
Force Simple Editor
true
false
Force Binary
true
false
Force Integer
true
false
Is a File Upload
true
false
Is a Password
true
false
width:
height:
move selected:
up
|
down
|
delete selected
Tables to which This Table is Foreign
critter