-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 28, 2006 at 11:04 AM
-- Server version: 5.0.21
-- PHP Version: 5.1.4
-- 
-- Database: `cws`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `commonuser`
-- 

CREATE TABLE `commonuser` (
  `id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `commonuser`
-- 

INSERT INTO `commonuser` VALUES (1);

-- --------------------------------------------------------

-- 
-- Table structure for table `diggblog_blog`
-- 

CREATE TABLE `diggblog_blog` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(200) NOT NULL,
  `url` varchar(255) NOT NULL,
  `entrynum` int(11) NOT NULL default '0',
  `lastupdate` int(11) NOT NULL default '0',
  `author` varchar(100) default NULL,
  `rssurl` varchar(255) NOT NULL,
  `icon` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `diggblog_blog`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `enterpriseuser`
-- 

CREATE TABLE `enterpriseuser` (
  `id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- 
-- Dumping data for table `enterpriseuser`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `panel`
-- 

CREATE TABLE `panel` (
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `panel`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `panelitem`
-- 

CREATE TABLE `panelitem` (
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `panelitem`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sysgroup`
-- 

CREATE TABLE `sysgroup` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `groupname` varchar(50) NOT NULL,
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- Dumping data for table `sysgroup`
-- 

INSERT INTO `sysgroup` VALUES (1, 'abcc', 'abc');
INSERT INTO `sysgroup` VALUES (3, 'asdf', 'asdf');

-- --------------------------------------------------------

-- 
-- Table structure for table `syslog`
-- 

CREATE TABLE `syslog` (
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `syslog`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sysmodule`
-- 

CREATE TABLE `sysmodule` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `pid` int(11) unsigned NOT NULL default '0',
  `title` varchar(100) NOT NULL,
  `url` varchar(255) NOT NULL,
  `memo` varchar(255) default NULL,
  `icon` varchar(100) default NULL,
  `isshow` tinyint(1) NOT NULL default '0',
  `position` mediumint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pid` (`pid`),
  KEY `isshow` (`isshow`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

-- 
-- Dumping data for table `sysmodule`
-- 

INSERT INTO `sysmodule` VALUES (2, 1, 'jasmin', 'asfdddddd', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (3, 0, 'System', '/', 'cccccccccc', '', 1, 0);
INSERT INTO `sysmodule` VALUES (4, 3, 'Module Management', '/', 'fasdf', '', 1, 0);
INSERT INTO `sysmodule` VALUES (5, 0, 'Article', '/', 'asdfasdf', '', 1, 0);
INSERT INTO `sysmodule` VALUES (6, 5, 'Categories', '/', 'c', '', 1, 0);
INSERT INTO `sysmodule` VALUES (7, 3, 'User Management', '/', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (8, 4, 'Add Module', '/admin/addModule', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (9, 4, 'List Modules', '/admin/listModules', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (10, 7, 'Add User', '/admin/addUser', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (12, 4, 'Delete Module', '/admin/deleteModule', '', '', 0, 0);
INSERT INTO `sysmodule` VALUES (14, 7, 'List Users', '/admin/listUsers', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (15, 7, 'Add UserRole', '/role/add', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (16, 7, 'List UserRoles', '/role/list', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (17, 7, 'Add UserGroup', '/group/add', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (18, 7, 'List UserGroups', '/group/list', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (19, 0, 'BBS', '/', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (20, 0, 'Blog', '/', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (21, 6, 'Add Category', '/article/addCategory', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (22, 6, 'List Categories', '/article/listCategories', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (23, 5, 'Articles', '/', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (24, 23, 'Add Article', '/article/addArticle', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (25, 23, 'List Articles', '/article/listArticles', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (26, 3, 'DB Management', '/', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (27, 26, 'Triggers', '/db/listTriggers', '', '', 1, 0);
INSERT INTO `sysmodule` VALUES (28, 26, 'Add Trigger', '/db/addTrigger', '', '', 1, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `syspermission`
-- 

CREATE TABLE `syspermission` (
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `syspermission`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `sysrole`
-- 

CREATE TABLE `sysrole` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `rolename` varchar(50) NOT NULL,
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `sysrole`
-- 

INSERT INTO `sysrole` VALUES (2, 'abc', 'acbc');
INSERT INTO `sysrole` VALUES (3, 'bz1a', 'bz');
INSERT INTO `sysrole` VALUES (4, 'Article Editor', 'Category: News');

-- --------------------------------------------------------

-- 
-- Table structure for table `sysuser`
-- 

CREATE TABLE `sysuser` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `email` varchar(100) NOT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL,
  `regdate` int(11) NOT NULL default '0',
  `regip` varchar(100) NOT NULL,
  `ismanager` tinyint(1) NOT NULL default '0',
  `iscommon` tinyint(1) unsigned NOT NULL default '0',
  `isenterprise` tinyint(1) unsigned NOT NULL default '0',
  `contribute` int(11) unsigned NOT NULL default '0',
  `praise` int(11) unsigned NOT NULL default '0',
  `activity` int(11) unsigned NOT NULL default '0',
  `money` float NOT NULL default '0',
  `nickname` varchar(50) default NULL,
  `truename` varchar(50) default NULL,
  `activationkey` varchar(100) default NULL,
  `userstatus` mediumint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `username` (`username`),
  KEY `ismanager` (`ismanager`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `sysuser`
-- 

INSERT INTO `sysuser` VALUES (1, 'binzy@justdn.com', 'asa', 'eee118a6fa4d9906f010c0272ce57947', 1150248861, '127.0.0.1', 1, 1, 0, 6, 15, 0, 0, NULL, NULL, NULL, 0);
INSERT INTO `sysuser` VALUES (2, 'asdfa', 'sdfasdfasd', 'asdfsadfasdf', 0, '', 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 0);

-- --------------------------------------------------------

-- 
-- Table structure for table `userpanel`
-- 

CREATE TABLE `userpanel` (
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `userpanel`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `userrole`
-- 

CREATE TABLE `userrole` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `uid` int(11) NOT NULL default '0',
  `gid` int(11) NOT NULL default '0',
  `rid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `uid` (`uid`),
  KEY `gid` (`gid`),
  KEY `rid` (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `userrole`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `userwebpart`
-- 

CREATE TABLE `userwebpart` (
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `userwebpart`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `webpart`
-- 

CREATE TABLE `webpart` (
  `id` int(11) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Dumping data for table `webpart`
--