Restructure table
Admin
|
Home
|
Search
|
Search stats
|
Logout
|
Help
Restructure
|
Mailing
|
Categories
Restructuring table "demo_market"
Edit fields structure
Field name
Display label
Type
Max. size
Move
Edit
id
ID
autoinc
12 chars
[
edit
]
_category
Category
text
64 chars
[
move down
]
[
edit
] [
delete
]
product
Product
text
64 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
shortdescription
Short description
text
255 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
price
Price per item
text
15 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
quality
Quality
text
16 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
_expires
Record expiration date
date
10 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
location
Location
text
60 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
phone
Contact phone(s)
text
64 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
_email
Owner's e-mail
email
40 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
_pwd
Password
text
24 chars
[
move up
] [
move down
]
[
edit
] [
delete
]
_add_datetime
Record added
datetime
19 chars
[
move up
]
[
edit
] [
delete
]
New field name
(only letters, digits and underscore):
int
text
float
date
time
datetime
boolean
image
binary
memo
htmlmemo
uploadmemo
autoinc
URL
email
Recreate table
Edit secondary indexes
New secondary index:
Name of index
(only letters, digits and underscore)
Field names to include in index
(comma separated)
Unique
Delete table
demo_market.def
demo_market.tr
delete all corresponding files from binary directory
Empty table
clear data (empty SQL table)
clear categories tree (empty .tr file)
Rename table
New name (only letters and digits):
Edit table parameters
Edit treeview parameters