Qoutabase

admin_groups

admin_groups
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	mediumint	8	Yes	Yes	Yes
name	varchar	20	No	Yes	No
description	varchar	100	No	Yes	No

admin_login_attempts

admin_login_attempts
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
ip_address	varchar	15	No	Yes	No
login	varchar	100	No	Yes	No
time	int	30	No	No	No

admin_users

admin_users
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
ip_address	varchar	15	No	Yes	No
username	varchar	100	No	No	No
password	varchar	255	No	Yes	No
salt	varchar	255	No	No	No
activation_code	varchar	40	No	No	No
forgotten_password_code	varchar	40	No	No	No
forgotten_password_time	int	11	No	No	No
remember_code	varchar	40	No	No	No
created_on	int	11	No	Yes	No
last_login	int	11	No	No	No
active	tinyint	1	No	Yes	No
first_name	varchar	50	No	No	No
last_name	varchar	50	No	No	No
themes	varchar	15	No	No	No
menu	varchar	100	No	No	No
hmenu	varchar	100	No	No	No
location	varchar	50	No	No	No

admin_users_groups

admin_users_groups
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
user_id	int	11	No	Yes	No
group_id	mediumint	8	No	Yes	No

artmaster_filetemp

artmaster_filetemp
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
mcontent	varchar	150	No	No	No

artmaster_logs_upld

artmaster_logs_upld
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
recid	int	25	Yes	Yes	Yes
ARTMU_USER	varchar	25	No	No	No
ARTMU_FILE	varchar	100	No	No	No
ARTMU_DATE	datetime	0	No	No	No
ARTMU_OFILE	varchar	100	No	No	No
ARTMU_RMARK	varchar	25	No	No	No

ccback

ccback
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
mymodule	varchar	20	No	No	No
myremark	varchar	1	No	No	No
myuser	varchar	10	No	No	No
mydate	datetime	0	No	No	No

ccbak

ccbak
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
mymodule	varchar	20	No	No	No
myremark	varchar	1	No	No	No
myuser	varchar	10	No	No	No
mydate	datetime	0	No	No	No

demo_blog_categories

demo_blog_categories
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
pos	int	11	No	Yes	No
title	varchar	100	No	Yes	No

demo_blog_posts

demo_blog_posts
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
category_id	int	11	No	Yes	No
author_id	int	11	No	Yes	No
title	varchar	300	No	Yes	No
image_url	varchar	300	No	Yes	No
content_brief	text	0	No	Yes	No
content	text	0	No	Yes	No
publish_time	timestamp	0	No	Yes	No
status	enum	draft	No	Yes	No

demo_blog_posts_tags

demo_blog_posts_tags
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
post_id	int	11	No	Yes	No
tag_id	int	11	No	Yes	No

demo_blog_tags

demo_blog_tags
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
title	varchar	100	No	Yes	No

demo_cover_photos

demo_cover_photos
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
pos	int	11	No	Yes	No
image_url	varchar	300	No	Yes	No
status	enum	0	active	Yes	No

groups

groups
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
name	varchar	20	No	Yes	No
description	varchar	100	No	Yes	No

hst2016

hst2016
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
HSTNUMB	varchar	15	No	No	No
HSTCDTE	datetime	0	No	No	No
HSTMPAY	double	15,2	No	No	No
HSTMALL	double	15,2	No	No	No
HSTBPAY	double	15,2	No	No	No
HSTBALL	double	15,2	No	No	No
HSTGPAY	double	15,2	No	No	No
HSTSSSR	double	15,2	No	No	No
HSTSSSE	double	15,2	No	No	No
HSTTAXC	double	15,2	No	No	No
HSTECCM	double	15,2	No	No	No
HSTPIBE	double	15,2	No	No	No
HSTPIBR	double	15,2	No	No	No
HSTMEDE	double	15,2	No	No	No
HSTMEDR	double	15,2	No	No	No
HSTTDED	double	15,2	No	No	No
HSTADON	double	15,2	No	No	No
HSTNSPY	double	15,2	No	No	No
HSTOTNS	double	15,2	No	No	No
HSTOTPY	double	15,2	No	No	No
HSTSLPY	double	15,2	No	No	No
HSTVLPY	double	15,2	No	No	No
HSTDOPY	double	15,2	No	No	No
HSTLHPY	double	15,2	No	No	No
HSTSHPY	double	15,2	No	No	No
HSTCOFF	varchar	3	No	No	No
HSTCOCD	varchar	1	No	No	No
HSTPCCD	varchar	1	No	No	No
HSTHOLD	varchar	1	No	No	No
HSTPYNO	varchar	9	No	No	No
HSTDPCD	varchar	10	No	No	No
HSTLCCD	varchar	3	No	No	No
HSTPMCD	varchar	1	No	No	No
HSTPSNO	varchar	1	No	No	No
HSTBKCD	varchar	5	No	No	No
HSTESCD	varchar	1	No	No	No
HSTFLPY	double	15,2	No	No	No
HSTTDPD	varchar	1	No	No	No

login_attempts

login_attempts
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
ip_address	varchar	15	No	Yes	No
login	varchar	100	No	Yes	No
time	int	11	No	No	No

menu_child

menu_child
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
name	varchar	25	No	No	No
label	varchar	25	No	No	No
mmenu	int	10	No	Yes	No
url	varchar	25	No	No	No
description	varchar	25	No	No	No
orderby	int	10	No	No	No

menu_main

menu_main
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
name	varchar	25	No	No	No
label	varchar	25	No	No	No
group	varchar	25	No	No	No
url	varchar	25	No	No	No
icon	varchar	15	No	No	No
description	varchar	25	No	No	No
orderby	int	10	No	No	No

menu_sub

menu_sub
Column Name	Data Type	Length	Is PrimaryKey	Is Not Null	Auto Increment
id	int	11	Yes	Yes	Yes
name	varchar	25	No	No	No
label	varchar	25	No	No	No
group	varchar	25	No	No	No
url	varchar	25	No	No	No
icon	varchar	15	No	No	No
description	varchar	25	No	No	No
orderby	int	10	No	No	No