Difference between revisions of "Qoutabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎demo_blog_posts)
Line 440: Line 440:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|recid
+
|id
 
|int
 
|int
−
|25
+
|11
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|Yes
 
|-
 
|-
−
|ARTMU_USER
+
|category_id
−
|varchar
+
|int
−
|25
+
|11
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 +
|-
 +
|author_id
 +
|int
 +
|11
 +
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|ARTMU_FILE
+
|title
 
|varchar
 
|varchar
−
|100
+
|300
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 +
|-
 +
|image_url
 +
|varchar
 +
|300
 +
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|ARTMU_DATE
+
|content_brief
−
|datetime
+
|text
 
|0
 
|0
 
|No
 
|No
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
−
|ARTMU_OFILE
+
|content
−
|varchar
+
|text
−
|100
+
|0
−
|No
+
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|ARTMU_RMARK
+
|publish_time
−
|varchar
+
|timestamp
−
|25
+
|0
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 +
|-
 +
|status
 +
|enum
 +
|draft
 +
|No
 +
|Yes
 
|No
 
|No
 
|}
 
|}

Revision as of 10:46, 8 August 2016

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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Qoutabase&oldid=2631"