Changeset 23023 for events

Show
Ignore:
Timestamp:
11/09/08 05:41:05 (5 years ago)
Author:
maru_cc
Message:

スキーマ最新

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • events/phpframework/ethna/trunk/schema/phwittr.sql

    r13406 r23023  
     1-- 
     2-- Table structure for table `followers` 
     3-- 
     4 
     5DROP TABLE IF EXISTS `followers`; 
     6SET @saved_cs_client = @@character_set_client; 
     7SET character_set_client = utf8; 
     8CREATE TABLE `followers` ( 
     9`user_id` int(11) unsigned NOT NULL, 
     10`follow_id` int(11) unsigned NOT NULL, 
     11`created_at` datetime NOT NULL, 
     12PRIMARY KEY (`user_id`,`follow_id`), 
     13KEY `follow_id` (`follow_id`), 
     14CONSTRAINT `followers_ibfk_1` FOREIGN KEY (`follow_id`) REFERENCES `users` (`id`), 
     15CONSTRAINT `followers_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) 
     16) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
     17SET character_set_client = @saved_cs_client; 
     18 
     19-- 
     20-- Table structure for table `requests` 
     21-- 
     22 
     23DROP TABLE IF EXISTS `requests`; 
     24SET @saved_cs_client = @@character_set_client; 
     25SET character_set_client = utf8; 
     26CREATE TABLE `requests` ( 
     27`user_id` int(10) unsigned NOT NULL, 
     28`request_id` int(10) unsigned NOT NULL, 
     29`created_at` datetime NOT NULL, 
     30PRIMARY KEY (`user_id`,`request_id`), 
     31KEY `request_id` (`request_id`), 
     32CONSTRAINT `requests_ibfk_2` FOREIGN KEY (`request_id`) REFERENCES `users` (`id`), 
     33CONSTRAINT `requests_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) 
     34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
     35SET character_set_client = @saved_cs_client; 
     36 
     37-- 
     38-- Table structure for table `statuses` 
     39-- 
     40 
     41DROP TABLE IF EXISTS `statuses`; 
     42SET @saved_cs_client = @@character_set_client; 
     43SET character_set_client = utf8; 
     44CREATE TABLE `statuses` ( 
     45`id` int(10) unsigned NOT NULL auto_increment, 
     46`user_id` int(10) unsigned NOT NULL, 
     47`reply_user_id` int(10) unsigned default NULL, 
     48`comment` varchar(255) collate utf8_unicode_ci NOT NULL, 
     49`created_at` datetime NOT NULL, 
     50PRIMARY KEY (`id`) 
     51) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
     52SET character_set_client = @saved_cs_client; 
     53 
     54-- 
     55-- Table structure for table `users` 
     56-- 
     57 
     58DROP TABLE IF EXISTS `users`; 
     59SET @saved_cs_client = @@character_set_client; 
     60SET character_set_client = utf8; 
    161CREATE TABLE `users` ( 
    2   `id` int(10) unsigned NOT NULL auto_increment, 
    3   `user_name` varchar(100) collate utf8_unicode_ci NOT NULL, 
    4   `email` varchar(255) collate utf8_unicode_ci NOT NULL, 
    5   `password` varchar(64) collate utf8_unicode_ci NOT NULL, 
    6   `image` varchar(255) collate utf8_unicode_ci default NULL, 
    7   `private_flag` tinyint(4) NOT NULL default '0', 
    8   `created_at` datetime NOT NULL, 
    9   `updated_at` datetime NOT NULL, 
    10   `delete_flag` tinyint(4) NOT NULL default '0', 
    11   PRIMARY KEY  (`id`) 
     62`id` int(10) unsigned NOT NULL auto_increment, 
     63`user_name` varchar(100) collate utf8_unicode_ci NOT NULL, 
     64`email` varchar(255) collate utf8_unicode_ci NOT NULL, 
     65`password` varchar(64) collate utf8_unicode_ci NOT NULL, 
     66`image` varchar(255) collate utf8_unicode_ci default NULL, 
     67`private_flag` tinyint(4) NOT NULL default '0', 
     68`created_at` datetime NOT NULL, 
     69`updated_at` datetime NOT NULL, 
     70`delete_flag` tinyint(4) NOT NULL default '0', 
     71`act_key` varchar(100) collate utf8_unicode_ci default NULL, 
     72PRIMARY KEY (`id`), 
     73UNIQUE KEY `user_name` (`user_name`) 
    1274) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
    13  
    14 CREATE TABLE `followers` ( 
    15   `user_id` int(11) unsigned NOT NULL, 
    16   `follow_id` int(11) unsigned NOT NULL, 
    17   `created_at` datetime NOT NULL, 
    18   PRIMARY KEY  (`user_id`,`follow_id`), 
    19   KEY `follow_id` (`follow_id`), 
    20   CONSTRAINT FOREIGN KEY (`follow_id`) REFERENCES `users` (`id`), 
    21   CONSTRAINT FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) 
    22 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
    23  
    24 CREATE TABLE `statuses` ( 
    25   `id` int(10) unsigned NOT NULL auto_increment, 
    26   `user_id` int(10) unsigned NOT NULL, 
    27   `reply_user_id` int(10) unsigned default NULL, 
    28   `comment` varchar(255) collate utf8_unicode_ci NOT NULL, 
    29   `created_at` datetime NOT NULL, 
    30   PRIMARY KEY  (`id`) 
    31 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 
     75SET character_set_client = @saved_cs_client;