kindly explain more on what you mean
There should be separate login history for what?
if AIKI handle upload there should be aiki_files.
aiki is not a CMS that's why there is no definition for how to upload
files. we can make upload app, and there is one if you looked at new
aiki installation but it shouldn't be core feature to have aiki_files
table.
a default aiki installation have the only needed fields, if you think
something is not needed, please write it down
** Changed in: aikiframework
Status: New => Invalid
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/735470
Title:
Dabase optimization needed
Status in Aiki Framework:
Invalid
Bug description:
There should be separate login history
aiki_login (id INTEGER auto_increment, userid, time datetime,
ip BIGINT)
+--------------+ +------------------+
| aiki_users | 1-----------------M | aiki_logins |
+--------------+ +------------------+
best way to store IP adresses is user Integer and INET_ATON INET_NTOA
functions.
Optimized aiki_users
aiki_users(userid, username, full_name, password, usergroup, email,
avatar, homepage, maillist, randkey, is_active,
exclude_tags, nsfwfilter)
logins_number
select count(*) from aiki_logins, aiki_users
where aiki_logins.userid = aiki_users.userid
users_permistions is redundant there is
select group_permissions from aiki_users_groups, aiki_users where
aiki_users.usergroup = aiki_users_group.id
num_upload — redundant
I don't how about the core but in openclipart.org you can do this:
select count(*) from aiki_users, ocal_files
where aiki_users.userid = ocal_files.upload_user
exclude_tags — (What is this used for?) if aiki need file tags:
aiki_tags (id INTEGER auto_increment, name VARCHAR(100))
aiki_file_tags (id INTEGER auto_increment, fileid INTEGER,
tagid INTEGER REFERENCES aiki_tags(id) )
country, sex and job should should be in aiki_user_fields and
aiki_fields
aiki_fields(id, name)
aiki_user_fields(id INTEGER auto_increment,
fields_id INTEGER REFERENCES aiki_fields(id),
userid INTEGER REFERENCES aiki_users(userid))
aiki_fileds:
0 email
1 sex
2 country
and user be able to add new fileds.
+--------------+ +------------------+
| aiki_users | 1-----------------M | aiki_user_fileds |
+--------------+ +------------------+
M
|
|
|
1
+------------------+
| aiki_fileds |
+------------------+
if AIKI handle upload there should be aiki_files
+--------------+ +------------------+
| aiki_users | 1-----------------M | aiki_files |
+--------------+ +------------------+
1
|
|
|
M
+------------------+
| aiki_file_tags |
+------------------+
M
|
|
|
1
+------------------+
| aiki_tags |
+------------------+
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
