Log message #536672

# At Username Text
# Feb 19th 2009, 13:54 alkemann this way you only access the other versions when you need to
# Feb 19th 2009, 13:53 alkemann AD7six: u could off course have it all in one table. that would just create a big one..
# Feb 19th 2009, 13:53 AD7six alkemann: I don't follow why that necessitates 3 tables
# Feb 19th 2009, 13:52 alkemann AD7six: 3 sets of data. revision table holds previews versions of the article. live table holds current live version, draft table holds users latest edit that has not yet been made live (and will become a revision when a new editition is pushed live)
# Feb 19th 2009, 13:52 gwoo so pages
# Feb 19th 2009, 13:52 AD7six articles have a status flag for draft, pending, published, rejected
# Feb 19th 2009, 13:51 AD7six I'm only talking about the data in the db
# Feb 19th 2009, 13:51 gwoo yes
# Feb 19th 2009, 13:51 AD7six gwoo: when you say revision - are you attaching additioanl meaning such as "revisions are visible to others"?
# Feb 19th 2009, 13:51 gwoo and that would be a revision
# Feb 19th 2009, 13:51 gwoo otherwise its just on hold for moderation
# Feb 19th 2009, 13:51 gwoo if we are to have true drafts
# Feb 19th 2009, 13:50 AD7six gwoo: I don't understand what you mean
# Feb 19th 2009, 13:50 alkemann AD7six: yes. maybe the name is wrong. we are not making drafts. author is publishing it, but we are moderating that publishing
# Feb 19th 2009, 13:50 gwoo it does not become a revision until its out of draft status
# Feb 19th 2009, 13:50 AD7six is featured superceeded by the vote up/down logic?
# Feb 19th 2009, 13:50 gwoo AD7six: no
# Feb 19th 2009, 13:49 AD7six a draft is a revision
# Feb 19th 2009, 13:49 AD7six what's the difference between a draft and a revision
# Feb 19th 2009, 13:49 AD7six naturally, I disagree
# Feb 19th 2009, 13:49 alkemann AD7six: because you are basically "hacking" a revision behavior to fulfill another function. and the publishing of a version gets in the way of having actual revisions
# Feb 19th 2009, 13:48 alkemann hasnt been a topic yet. but jperras pointed out that it has been very little used. maybe we can just give hottest stuff more realestate now that jperras is making the system better :)
# Feb 19th 2009, 13:48 AD7six alkemann: hence I ask about the two behaviors because the book's logic covers both.
# Feb 19th 2009, 13:46 AD7six what about featured - is that not going to be used anymore?
# Feb 19th 2009, 13:45 AD7six are we missing any tables though, I would expectc for fields to me missed atm.
# Feb 19th 2009, 13:44 AD7six so there's only ever 1
# Feb 19th 2009, 13:44 AD7six the act of making as current marks the 'current' revision as previous
# Feb 19th 2009, 13:44 AD7six the book revision logic is user submits a pending revision (draft), admin marks it as current or rejected.
# Feb 19th 2009, 13:44 alkemann AD7six: how does the book do drafts (ie keep old version online)
# Feb 19th 2009, 13:43 jperras AD7six: I don't think we will have much use for deleting ratings
# Feb 19th 2009, 13:43 alkemann we may decide against using revision, but we agreed that it was better to create a drafted behavior, than use revision for something it was not intended
# Feb 19th 2009, 13:43 AD7six maybe not needed, it the bakery got spammed it'd be handy to not delete the info you can use to investigate with
# Feb 19th 2009, 13:42 AD7six jperras: to be able to remove without deleting a rating.
# Feb 19th 2009, 13:42 ADmad yeah dont think we are gonna approve ratings too
# Feb 19th 2009, 13:42 jperras what is the 'status' field in the rating supposed to be
# Feb 19th 2009, 13:42 ADmad heh
# Feb 19th 2009, 13:41 AD7six ADmad: yes :)
# Feb 19th 2009, 13:41 alkemann AD7six: revision and drafts are very different creatures
# Feb 19th 2009, 13:41 alkemann it's not in use cause the code is barely baked.
# Feb 19th 2009, 13:41 ADmad AD7six: isnt the ratings table missing a filed for storing the rating ?
# Feb 19th 2009, 13:40 AD7six why do you need both revision and drafted behaviors