[Astrospaces-commits] SF.net SVN: astrospaces: [84] trunk

[<fr...@us...>]

Revision: 84
          http://astrospaces.svn.sourceforge.net/astrospaces/?rev=84&view=rev
Author:   frcole
Date:     2007-08-01 15:03:28 -0700 (Wed, 01 Aug 2007)

Log Message:
-----------
Update config.php to reflect new tables as well as corrected some minor typos. --frc

Modified Paths:
--------------
    trunk/config.php
    trunk/develop/new-schema.sql

Modified: trunk/config.php
===================================================================
--- trunk/config.php	2007-08-01 20:09:38 UTC (rev 83)
+++ trunk/config.php	2007-08-01 22:03:28 UTC (rev 84)
@@ -1,37 +1,43 @@
-<?php
-/* These settings are autogenerated by AstroSPACES
-   do not change them unless you know what you are
-   doing!
-*/
-define('AS_DB_TYPE',   'mysql');
-define('AS_DB_PREFIX', 'as_');
-define('AS_DB_HOST',   'localhost');
-define('AS_DB_SCHEMA', 'schema');
-define('AS_DB_USER',   'user');
-define('AS_DB_PASS',   'pass');
-
-define('AS_EXT',  '.php');
-define('AS_LANG', 'en-us');
-
-define('AS_LOC_URL',    'http://localhost/');
-define('AS_LOC_DIRECT', 'C:/path/to/astrospaces/');
-
-/* These settings are constants and must NOT
-   be altered. Doing so will prevent AstroSPACES
-   from functioning.
-*/
-define('AS_TBL_USER',     AS_DB_PREFIX.'user');
-define('AS_TBL_BLOG',     AS_DB_PREFIX.'blog');
-define('AS_TBL_BLOG_CMT', AS_DB_PREFIX.'blog_comments');
-define('AS_TBL_COMMENTS', AS_DB_PREFIX.'comments');
-define('AS_TBL_FRIEND',   AS_DB_PREFIX.'friends');
-define('AS_TBL_IMG',      AS_DB_PREFIX.'images');
-define('AS_TBL_IMG_CMT',  AS_DB_PREFIX.'image_comments');
-define('AS_TBL_ACTION',   AS_DB_PREFIX.'actions');
-define('AS_TBL_CMT',      AS_DB_PREFIX.'comments');
-define('AS_TBL_SESSION',  AS_DB_PREFIX.'sessions');
-define('AS_TBL_PM',       AS_DB_PREFIX.'private_messages');
-
-define('AS_DIR_TPL', 'template/');
-define('AS_TPL',     AS_LOC_URL.AS_DIR_TPL.'default/');
-?>
\ No newline at end of file
+<?php
+/* These settings are autogenerated by AstroSPACES
+   do not change them unless you know what you are
+   doing!
+*/
+define('AS_DB_TYPE',   'mysql');
+define('AS_DB_PREFIX', 'as_');
+define('AS_DB_HOST',   'localhost');
+define('AS_DB_SCHEMA', 'schema');
+define('AS_DB_USER',   'user');
+define('AS_DB_PASS',   'pass');
+
+define('AS_EXT',  '.php');
+define('AS_LANG', 'en-us');
+
+define('AS_LOC_URL',    'http://localhost/');
+define('AS_LOC_DIRECT', 'C:/path/to/astrospaces/');
+
+/* These settings are constants and must NOT
+   be altered. Doing so will prevent AstroSPACES
+   from functioning.
+*/
+define('AS_TBL_USERS',    AS_DB_PREFIX.'users');
+define('AS_TBL_BLOG',     AS_DB_PREFIX.'blog');
+define('AS_TBL_BLOG_CMT', AS_DB_PREFIX.'blog_comment');
+define('AS_TBL_COMMENTS', AS_DB_PREFIX.'comments');
+define('AS_TBL_FRIEND',   AS_DB_PREFIX.'friends');
+define('AS_TBL_IMG',      AS_DB_PREFIX.'images');
+define('AS_TBL_IMG_CMT',  AS_DB_PREFIX.'image_comments');
+define('AS_TBL_ACTION',   AS_DB_PREFIX.'actions');
+define('AS_TBL_CMT',      AS_DB_PREFIX.'comments');
+define('AS_TBL_SESSION',  AS_DB_PREFIX.'sessions');
+define('AS_TBL_PM',       AS_DB_PREFIX.'private_messages');
+define('AS_TBL_GRPRES',   AS_DB_PREFIX.'group_resolver');
+define('AS_TBL_GRPS',     AS_DB_PREFIX.'groups');
+define('AS_TBL_SPROFLDS', AS_DB_PREFIX.'static_profile_fields');
+define('AS_TBL_DPROFLDS', AS_DB_PREFIX.'dynamic_profile_fields');
+define('AS_TBL_DPROVAL',  AS_DB_PREFIX.'dynamic_profile_values');
+
+define('AS_DIR_TPL', 'template/');
+define('AS_TPL',     AS_LOC_URL.AS_DIR_TPL.'default/');
+?>
+

Modified: trunk/develop/new-schema.sql
===================================================================
--- trunk/develop/new-schema.sql	2007-08-01 20:09:38 UTC (rev 83)
+++ trunk/develop/new-schema.sql	2007-08-01 22:03:28 UTC (rev 84)
@@ -117,14 +117,14 @@
   `last_login` int(10) unsigned NOT NULL COMMENT 'Unix timestamp',
   `time_offset` tinyint(3) unsigned NOT NULL,
   `email` varchar(60) NOT NULL,
-  `user_image` int(11) unsigned NOT NULL,
   `privacy` tinyint(1) unsigned NOT NULL default '0',
   PRIMARY KEY  (`user_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 
 DROP TABLE IF EXISTS `as_static_profile_fields`;
-CREATE TABLE  `as_users` (
-  `user_id` int(10) unsigned NOT NULL auto_increment,
+CREATE TABLE  `as_static_profile_fields` (
+  `static_profile_field_id` int(10) unsigned NOT NULL auto_increment,
+  `user_id` int(10) unsigned NOT NULL,
   `display_name` varchar(45) NOT NULL,
   `blurb` text NOT NULL,
   `aim` varchar(45) NOT NULL,
@@ -134,5 +134,23 @@
   `icq` varchar(45) NOT NULL,
   `msn` varchar(45) NOT NULL,
   `user_image` int(11) unsigned NOT NULL,
-  PRIMARY KEY  (`user_id`)
+  PRIMARY KEY  (`static_profile_field_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+
+DROP TABLE IF EXISTS `as_dynamic_profile_fields`;
+CREATE TABLE `as_dynamic_profile_fields` (
+  `dynamic_profile_field_id` int(10) unsigned NOT NULL auto_increment,
+  `field_name` varchar(128) NOT NULL default 'new field',
+  `field_description` varchar(128),
+  PRIMARY KEY (`dynamic_profile_field_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `as_dynamic_profile_values`;
+CREATE TABLE `as_dynamic_profile_values` (
+  `dynamic_profile_field_id` int(10) unsigned NOT NULL auto_increment,
+  `user_id` int(10) unsigned NOT NULL,
+  `field_name` varchar(128) NOT NULL default 'new field',
+  `field_value` varchar(128),
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.