Changeset 077f3f for install


Ignore:
Timestamp:
02/09/10 19:17:50 (9 years ago)
Author:
pierre-alain <pierre-alain@…>
Branches:
master
Children:
2a2406
Parents:
1eaf69
git-author:
pierre-alain <pierre-alain@…> (02/09/10 19:17:50)
git-committer:
pierre-alain <pierre-alain@…> (02/09/10 19:17:50)
Message:

closing ticket-3

You will have to add the tables 'news_tags' and 'news_relations_table' into your DB (take their definitions from file install/init_db.sql)

Location:
install
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • install/cfg-dist.php

    rf7f462 r077f3f  
    166166 
    167167// version 
    168 $cfg['version']                 = '0.1a2'; 
     168$cfg['version']                 = '0.2'; 
    169169 
    170170// activate debug mode here 
  • install/init_db.sql

    r877ab3 r077f3f  
    1 -- MySQL dump 10.11 
    2 -- 
    31/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 
    42/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 
     
    7775 
    7876-- 
     77-- Table structure for table `news_relations_tags` 
     78-- 
     79 
     80DROP TABLE IF EXISTS `news_relations_tags`; 
     81SET @saved_cs_client     = @@character_set_client; 
     82SET character_set_client = utf8; 
     83CREATE TABLE `news_relations_tags` ( 
     84  `newsid` int(11) NOT NULL, 
     85  `uid` int(11) NOT NULL, 
     86  `tid` int(11) NOT NULL, 
     87  UNIQUE KEY `uniq_key` (`newsid`,`tid`), 
     88  KEY `uid` (`uid`), 
     89  KEY `tid` (`tid`), 
     90  CONSTRAINT `news_relations_tags_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE, 
     91  CONSTRAINT `news_relations_tags_ibfk_2` FOREIGN KEY (`newsid`) REFERENCES `news` (`id`) ON DELETE CASCADE, 
     92  CONSTRAINT `news_relations_tags_ibfk_3` FOREIGN KEY (`tid`) REFERENCES `news_tags` (`id`) ON DELETE CASCADE 
     93) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
     94SET character_set_client = @saved_cs_client; 
     95 
     96-- 
     97-- Table structure for table `news_tags` 
     98-- 
     99 
     100DROP TABLE IF EXISTS `news_tags`; 
     101SET @saved_cs_client     = @@character_set_client; 
     102SET character_set_client = utf8; 
     103CREATE TABLE `news_tags` ( 
     104  `id` int(11) NOT NULL, 
     105  `uid` int(11) NOT NULL, 
     106  `name` varchar(255) NOT NULL, 
     107  UNIQUE KEY `uniq_key` (`uid`,`name`), 
     108  KEY `uid` (`uid`), 
     109  KEY `id` (`id`), 
     110  CONSTRAINT `news_tags_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `users` (`id`) ON DELETE CASCADE, 
     111  CONSTRAINT `news_tags_ibfk_2` FOREIGN KEY (`id`) REFERENCES `objects` (`id`) ON DELETE CASCADE 
     112) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
     113SET character_set_client = @saved_cs_client; 
     114 
     115-- 
    79116-- Table structure for table `objects` 
    80117-- 
     
    260297/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 
    261298/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 
     299 
     300-- Dump completed on 2010-02-09 17:56:00 
Note: See TracChangeset for help on using the changeset viewer.