[Astrospaces-commits] SF.net SVN: astrospaces: [40] trunk/develop/new-schema.sql

[<del...@us...>]

Revision: 40
          http://astrospaces.svn.sourceforge.net/astrospaces/?rev=40&view=rev
Author:   deltalabs
Date:     2007-07-30 12:29:45 -0700 (Mon, 30 Jul 2007)

Log Message:
-----------


Added Paths:
-----------
    trunk/develop/new-schema.sql

Added: trunk/develop/new-schema.sql
===================================================================
--- trunk/develop/new-schema.sql	                        (rev 0)
+++ trunk/develop/new-schema.sql	2007-07-30 19:29:45 UTC (rev 40)
@@ -0,0 +1,130 @@
+DROP TABLE IF EXISTS `as_actions`;
+CREATE TABLE  `as_actions` (
+  `action_id` int(10) unsigned NOT NULL auto_increment,
+  `action_timestamp` int(10) unsigned NOT NULL,
+  `action` int(2) unsigned NOT NULL,
+  `for` int(11) unsigned NOT NULL,
+  PRIMARY KEY  (`action_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `as_blog`;
+CREATE TABLE  `as_blog` (
+  `blog_id` int(10) unsigned NOT NULL auto_increment,
+  `title` varchar(45) NOT NULL,
+  `blog_timestamp` int(10) unsigned NOT NULL,
+  `content` text NOT NULL,
+  `author_id` int(11) unsigned NOT NULL,
+  PRIMARY KEY  (`blog_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `as_blog_comment`;
+CREATE TABLE  `as_blog_comment` (
+  `comment_id` int(10) unsigned NOT NULL auto_increment,
+  `author_id` int(10) unsigned NOT NULL,
+  `comment` text NOT NULL,
+  `post_timestamp` int(10) unsigned NOT NULL,
+  PRIMARY KEY  (`comment_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `as_comments`;
+CREATE TABLE  `as_comments` (
+  `comment_id` int(10) unsigned NOT NULL auto_increment,
+  `comment_timestamp` int(10) unsigned NOT NULL,
+  `poster_id` int(11) unsigned NOT NULL,
+  `recipient_id` int(11) unsigned NOT NULL,
+  `comment` text NOT NULL,
+  PRIMARY KEY  (`comment_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
+
+DROP TABLE IF EXISTS `as_friends`;
+CREATE TABLE  `as_friends` (
+  `couple_id` int(10) unsigned NOT NULL auto_increment,
+  `user1_id` int(10) unsigned NOT NULL,
+  `user2_id` int(10) unsigned NOT NULL,
+  `accepted` tinyint(1) unsigned NOT NULL,
+  PRIMARY KEY  (`couple_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
+
+DROP TABLE IF EXISTS `as_group_resolver`;
+CREATE TABLE  `as_group_resolver` (
+  `pair_id` int(10) unsigned NOT NULL auto_increment,
+  `user_id` int(10) unsigned NOT NULL,
+  `group_id` int(10) unsigned NOT NULL,
+  `join_date` int(10) unsigned NOT NULL COMMENT 'Unix timestamp',
+  PRIMARY KEY  (`pair_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
+
+DROP TABLE IF EXISTS `as_groups`;
+CREATE TABLE  `as_groups` (
+  `group_id` int(10) unsigned NOT NULL auto_increment,
+  `name` varchar(45) NOT NULL,
+  `founder` int(11) unsigned NOT NULL,
+  `create_timestamp` int(10) unsigned NOT NULL,
+  PRIMARY KEY  (`group_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
+
+DROP TABLE IF EXISTS `as_image_comments`;
+CREATE TABLE  `as_image_comments` (
+  `comment_id` int(10) unsigned NOT NULL auto_increment,
+  `image_id` int(11) unsigned NOT NULL,
+  `post_timestamp` int(10) unsigned NOT NULL,
+  `author` int(11) unsigned NOT NULL,
+  `comment` text NOT NULL,
+  PRIMARY KEY  (`comment_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `as_images`;
+CREATE TABLE  `as_images` (
+  `img_id` int(10) unsigned NOT NULL auto_increment,
+  `owner_id` int(10) unsigned NOT NULL,
+  `content` varchar(45) NOT NULL COMMENT 'path to image on server',
+  `desc` text NOT NULL,
+  `width` int(4) unsigned NOT NULL,
+  `height` int(4) unsigned NOT NULL,
+  `name` text NOT NULL,
+  `views` int(6) unsigned NOT NULL,
+  PRIMARY KEY  (`img_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `as_private_messages`;
+CREATE TABLE  `as_private_messages` (
+  `message_id` int(10) unsigned NOT NULL auto_increment,
+  `sender_id` int(11) unsigned NOT NULL,
+  `recipient_id` int(11) unsigned NOT NULL,
+  `send_date` int(10) unsigned NOT NULL,
+  `subject` varchar(80) NOT NULL,
+  `message` text NOT NULL,
+  `read` tinyint(1) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`message_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+DROP TABLE IF EXISTS `as_sessions`;
+CREATE TABLE  `as_sessions` (
+  `session_id` int(10) unsigned NOT NULL auto_increment,
+  `user_id` int(11) unsigned NOT NULL,
+  `ip` varchar(12) NOT NULL,
+  `last_update` int(10) unsigned NOT NULL,
+  PRIMARY KEY  (`session_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
+
+DROP TABLE IF EXISTS `as_users`;
+CREATE TABLE  `as_users` (
+  `user_id` int(10) unsigned NOT NULL auto_increment,
+  `display_name` varchar(45) NOT NULL,
+  `password` varchar(16) NOT NULL,
+  `join_date` int(10) unsigned NOT NULL COMMENT 'Unix timestamp',
+  `last_login` int(10) unsigned NOT NULL COMMENT 'Unix timestamp',
+  `time_offset` tinyint(3) unsigned NOT NULL,
+  `blurb` text NOT NULL,
+  `email` varchar(60) NOT NULL,
+  `aim` varchar(45) NOT NULL,
+  `yim` varchar(45) NOT NULL,
+  `jabber` varchar(45) NOT NULL,
+  `irc` varchar(45) NOT NULL,
+  `icq` varchar(45) NOT NULL,
+  `msn` varchar(45) NOT NULL,
+  `user_image` int(11) unsigned NOT NULL,
+  `clean_url` varchar(45) NOT NULL,
+  `privacy` tinyint(1) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`user_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
\ No newline at end of file


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