From d582054c77b22daeb08d2bff17794b9a69a20dd4 Mon Sep 17 00:00:00 2001
From: mensonge <mensonge@b3834d28-1941-0410-a4f8-b48e95affb8f>
Date: Wed, 12 Dec 2007 16:29:16 +0000
Subject: import of scuttle 0.7.2

git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@1 b3834d28-1941-0410-a4f8-b48e95affb8f
---
 tables.sql | 68 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 68 insertions(+)
 create mode 100644 tables.sql

(limited to 'tables.sql')

diff --git a/tables.sql b/tables.sql
new file mode 100644
index 0000000..578fa06
--- /dev/null
+++ b/tables.sql
@@ -0,0 +1,68 @@
+-- 
+-- Table structure for table `sc_bookmarks`
+-- 
+
+CREATE TABLE `sc_bookmarks` (
+  `bId` int(11) NOT NULL auto_increment,
+  `uId` int(11) NOT NULL default '0',
+  `bIp` varchar(40) default NULL,
+  `bStatus` tinyint(1) NOT NULL default '0',
+  `bDatetime` datetime NOT NULL default '0000-00-00 00:00:00',
+  `bModified` datetime NOT NULL default '0000-00-00 00:00:00',
+  `bTitle` varchar(255) NOT NULL default '',
+  `bAddress` text NOT NULL,
+  `bDescription` varchar(255) default NULL,
+  `bHash` varchar(32) NOT NULL default '',
+  PRIMARY KEY  (`bId`),
+  KEY `sc_bookmarks_usd` (`uId`,`bStatus`,`bDatetime`),
+  KEY `sc_bookmarks_hui` (`bHash`,`uId`,`bId`),
+  KEY `sc_bookmarks_du` (`bDatetime`,`uId`)
+);
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `sc_tags`
+-- 
+
+CREATE TABLE `sc_tags` (
+  `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`)
+);
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `scUsers`
+-- 
+
+CREATE TABLE `sc_users` (
+  `uId` int(11) NOT NULL auto_increment,
+  `username` varchar(25) NOT NULL default '',
+  `password` varchar(40) NOT NULL default '',
+  `uDatetime` datetime NOT NULL default '0000-00-00 00:00:00',
+  `uModified` datetime NOT NULL default '0000-00-00 00:00:00',
+  `name` varchar(50) default NULL,
+  `email` varchar(50) NOT NULL default '',
+  `homepage` varchar(255) default NULL,
+  `uContent` text,
+  PRIMARY KEY  (`uId`)
+);
+
+-- --------------------------------------------------------
+
+-- 
+-- Table structure for table `sc_watched`
+-- 
+
+CREATE TABLE `sc_watched` (
+  `wId` int(11) NOT NULL auto_increment,
+  `uId` int(11) NOT NULL default '0',
+  `watched` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`wId`),
+  KEY `sc_watched_uId` (`uId`)
+);
\ No newline at end of file
-- 
cgit v1.2.3

