Database klfree_is running on localhost

# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Aug 12, 2004 at 05:33 PM
# Server version: 4.0.20
# PHP Version: 4.3.4
# 
# Database : `klfree_is`
# 

# --------------------------------------------------------

#
# Table structure for table `account_groups`
#

DROP TABLE IF EXISTS `account_groups`;
CREATE TABLE `account_groups` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `id_account` int(11) unsigned NOT NULL default '0',
  `id_group` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=133 ;

# --------------------------------------------------------

#
# Table structure for table `accounts`
#

DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `login` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  `type` enum('member','expectant','other') NOT NULL default 'expectant',
  `create_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `firstname` varchar(255) NOT NULL default '',
  `surname` varchar(255) NOT NULL default '',
  `address_street` varchar(255) NOT NULL default '',
  `address_city` varchar(255) NOT NULL default '',
  `address_postcode` varchar(255) NOT NULL default '',
  `address_country` varchar(255) NOT NULL default '',
  `delivery_address_name` varchar(255) NOT NULL default '',
  `delivery_address_street` varchar(255) NOT NULL default '',
  `delivery_address_city` varchar(255) NOT NULL default '',
  `delivery_address_postcode` varchar(255) NOT NULL default '',
  `delivery_address_country` varchar(255) NOT NULL default '',
  `contact_email` varchar(255) NOT NULL default '',
  `contact_phone` varchar(255) NOT NULL default '',
  `bank_name` varchar(255) NOT NULL default '',
  `bank_number` varchar(255) NOT NULL default '',
  `deleted` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=60 ;

# --------------------------------------------------------

#
# Table structure for table `db_vars_links`
#

DROP TABLE IF EXISTS `db_vars_links`;
CREATE TABLE `db_vars_links` (
  `id` varchar(32) NOT NULL default '',
  `create_time` timestamp(14) NOT NULL,
  `expire_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `db_data` blob NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `db_vars_sessions`
#

DROP TABLE IF EXISTS `db_vars_sessions`;
CREATE TABLE `db_vars_sessions` (
  `id` varchar(32) NOT NULL default '',
  `inserted` datetime default NULL,
  `changed` timestamp(14) NOT NULL,
  `ip` varchar(15) NOT NULL default '',
  `session_data` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id_ip` (`id`,`ip`),
  KEY `create_time` (`inserted`),
  KEY `ip` (`ip`),
  KEY `changed` (`changed`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `devices`
#

DROP TABLE IF EXISTS `devices`;
CREATE TABLE `devices` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `MAC` varchar(255) NOT NULL default '',
  `type` enum('static','dynamic') NOT NULL default 'static',
  `active` enum('Y','N') NOT NULL default 'Y',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `MAC` (`MAC`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `groups`
#

DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=16 ;

# --------------------------------------------------------

#
# Table structure for table `ip_addresses`
#

DROP TABLE IF EXISTS `ip_addresses`;
CREATE TABLE `ip_addresses` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `id_device` int(11) unsigned NOT NULL default '0',
  `ip_v4` varchar(15) NOT NULL default '',
  `domain` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ip_v4` (`ip_v4`),
  UNIQUE KEY `domain` (`domain`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

# --------------------------------------------------------

#
# Table structure for table `location_rule_types`
#

DROP TABLE IF EXISTS `location_rule_types`;
CREATE TABLE `location_rule_types` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `id_location` int(11) unsigned NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `short_name` varchar(5) NOT NULL default '',
  `value` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

# --------------------------------------------------------

#
# Table structure for table `location_rules`
#

DROP TABLE IF EXISTS `location_rules`;
CREATE TABLE `location_rules` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `id_location` int(11) unsigned NOT NULL default '0',
  `id_account` int(11) unsigned NOT NULL default '0',
  `id_group` int(11) unsigned NOT NULL default '0',
  `rule_allow` int(11) unsigned NOT NULL default '0',
  `rule_deny` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `id_location` (`id_location`)
) TYPE=MyISAM AUTO_INCREMENT=31 ;

# --------------------------------------------------------

#
# Table structure for table `locations`
#

DROP TABLE IF EXISTS `locations`;
CREATE TABLE `locations` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `id_parent` int(11) unsigned NOT NULL default '0',
  `order_index` int(11) unsigned NOT NULL default '0',
  `key` varchar(255) NOT NULL default '',
  `lang_key` varchar(255) NOT NULL default '',
  `in_menu` enum('Y','N') NOT NULL default 'Y',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `key` (`key`),
  KEY `id_parent` (`id_parent`),
  KEY `order_index` (`order_index`)
) TYPE=MyISAM AUTO_INCREMENT=56 ;

# --------------------------------------------------------

#
# Table structure for table `transactions`
#

DROP TABLE IF EXISTS `transactions`;
CREATE TABLE `transactions` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `inserted` datetime NOT NULL default '0000-00-00 00:00:00',
  `amount` double(10,2) NOT NULL default '0.00',
  `type` enum('transfer','cash') NOT NULL default 'transfer',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
    

Topic revision: r1 - 2004-08-12 - 17:34:54 - KamilSopko
 
This site is powered by the TWiki collaboration platformCopyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback