Differences from version 23 to 32



@@ -5,10 +5,6 @@

 * How to verify hours data for each day in BitYellowPages
 ** loop through for days 0-6 ?
 ** require edit cycle for each day ? <-- easiest to build
-* What to do about people listings
-** where to store first and last names? does not match nicely to tiki_content.
-** how to tether to registration system
-* How to create groups? do groups need a title or perhaps join on pigeonhole
 
 !Tables Schema
 This is the data tables schema for the yellowpages package. This does not include some things like id_seqs which will be derived as appropriate.

@@ -24,22 +20,17 @@

 * __categorization__
 + will rely on pigeonholes or a duplicate of pigeonholes that is exclusive for listings use.
 !!YellowpagesPackage Tables
-* __yellowpages_groups__
-**group_id
+* __yellowpages_group_kings__
+**group_id (keyed to a pigeonhole)
 **king_content_id (a primary listing of a group of listings keyed to a content_id)
 * __yellowpages__
 ** content_id (keyed to same on liberty_content)
 **yellowpages_id (pretty)
-**group_id (optional)
 **parent_id (optional - a content_id)
 **description
 ** url
-** url_title
-** phone_main
-** phone_mobile
-** fax
 ** email
-** im (chat id)
+** im_id (chat id)
 ** im_type (chat network)
 ** address
 ** city

@@ -49,8 +40,12 @@

 ** postal code (this is a universal term)
 ***international
 ***index for fast search
+*__yellowpages_persons__
+**yellowpages_id
+**firstname
+**lastname
 * __yellowpages_hours__
-**content_id
+**yellowpages_id
 **day_id (0-n joins on yellowpages_days
 **start_time
 **end_time

@@ -60,6 +55,10 @@

 **day_id
 **day_title
 ++defaults: 0:Monday - 6:Sunday, 7:Holidays (generic), 8:Christmas, etc
+* __yellowpages_phones__
+** yellowpages_id
+** phone_type
+** phone_number
 
 
 !Brainstorm Discussion:

@@ -99,6 +98,8 @@

 *** end date
 *** more... (possibly a way to admin-define these fields?)
 
-
-
-
+!Feature requests
+*filtering of search results by geo locations and the possibility of browsing the entries based on geo locations (mainly for entries that can have a location associated - companies, institutions etc.)
+*possibility of fulltext switching to global internet fulltext search (read: fulltext via google for instance)
+*the ability of setting any entry "Featured", which would bring it up in the browsing listings and searches
+*item rating and comments
Page History
Date/CommentUserIPVersion
03 May 2007 (00:59 UTC)
schema tweak - move phones to new table
Will68.174.111.4732
Current • Source
Kozuch194.108.143.10831
View • Compare • Difference • Source
Kozuch194.108.143.10830
View • Compare • Difference • Source
Kozuch83.208.125.1429
View • Compare • Difference • Source
Kozuch194.108.143.10828
View • Compare • Difference • Source
Kozuch194.108.143.10827
View • Compare • Difference • Source
Will68.174.111.4726
View • Compare • Difference • Source
Will68.174.111.4725
View • Compare • Difference • Source
Will68.174.111.4724
View • Compare • Difference • Source
Will68.174.111.4723
View • Compare • Difference • Source
Will68.174.111.4722
View • Compare • Difference • Source
Will68.174.111.4721
View • Compare • Difference • Source
Will68.174.111.4720
View • Compare • Difference • Source
Will68.174.111.4719
View • Compare • Difference • Source
lugie70.224.212.20918
View • Compare • Difference • Source
lugie70.224.212.20917
View • Compare • Difference • Source
Will68.174.111.4716
View • Compare • Difference • Source
Will68.174.111.4715
View • Compare • Difference • Source
Will68.174.111.4714
View • Compare • Difference • Source
Will68.174.111.4713
View • Compare • Difference • Source
WaterDragon145.116.228.3412
View • Compare • Difference • Source
Will68.174.111.4711
View • Compare • Difference • Source
Will68.174.111.4710
View • Compare • Difference • Source
Will68.174.111.479
View • Compare • Difference • Source
Will68.174.111.478
View • Compare • Difference • Source
Will68.174.111.477
View • Compare • Difference • Source