From 4de56ed6623c57c1c767be192ffe2af5926fe598 Mon Sep 17 00:00:00 2001
From: mensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>
Date: Mon, 21 Apr 2008 08:44:44 +0000
Subject: Refactoring: rename sc_tags into sc_bookmarks2tags (and services,
 codes...)

git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@116 b3834d28-1941-0410-a4f8-b48e95affb8f
---
 tables.sql | 20 ++++++++++++++++++--
 1 file changed, 18 insertions(+), 2 deletions(-)

(limited to 'tables.sql')

diff --git a/tables.sql b/tables.sql
index 92c42c7..8280ac3 100644
--- a/tables.sql
+++ b/tables.sql
@@ -1,5 +1,6 @@
 -- Semantice Scuttle - Tables creation SQL script
 -- ! Dont forget to change table names according to $tableprefix defined in config.inc.php !
+
 -- 
 -- Table structure for table `sc_bookmarks`
 -- 
@@ -28,12 +29,27 @@ CREATE TABLE `sc_bookmarks` (
 -- 
 
 CREATE TABLE `sc_tags` (
+  `tId` int(11) NOT NULL auto_increment,
+  `tag` varchar(32) NOT NULL default '',
+  `uId` int(11) NOT NULL default '0',
+  `tDescription` varchar(255) default NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `sc_tags_tag_uId` (`tag`, `uId`)
+);
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `sc_bookmarks2tags`
+-- 
+
+CREATE TABLE `sc_bookmarks2tags` (
   `id` int(11) NOT NULL auto_increment,
   `bId` int(11) NOT NULL default '0',
   `tag` varchar(32) NOT NULL default '',
   PRIMARY KEY  (`id`),
-  UNIQUE KEY `sc_tags_tag_bId` (`tag`,`bId`),
-  KEY `sc_tags_bId` (`bId`)
+  UNIQUE KEY `sc_bookmarks2tags_tag_bId` (`tag`,`bId`),
+  KEY `sc_bookmarks2tags_bId` (`bId`)
 );
 
 -- --------------------------------------------------------
-- 
cgit v1.2.3

