line breaks ** Description changed:
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. + + 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) - + 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 + 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 + 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 whre - aiki_users.userid = ocal_files.upload_user + 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_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_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 | +------------------+ -- 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: New 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 : aikiframework.admins@lists.launchpad.net Unsubscribe : https://launchpad.net/~aikiframework.admins More help : https://help.launchpad.net/ListHelp
