-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 01. August 2024 um 07:06
-- Server Version: 5.6.47
-- PHP-Version: 5.5.38

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `openphoenux_swi`
--

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

--
-- Tabellenstruktur für Tabelle `swi`
--

CREATE TABLE IF NOT EXISTS `swi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `license` text NOT NULL,
  `summary` text NOT NULL,
  `description` text NOT NULL,
  `downloadurl` text NOT NULL,
  `version` text NOT NULL,
  `homepageurl` text NOT NULL,
  `feedurl` text NOT NULL,
  `sourceurl` text NOT NULL,
  `updated` datetime DEFAULT '0000-00-00 00:00:00',
  `replacedby` int(11) NOT NULL DEFAULT '0',
  `approved` tinyint(4) NOT NULL DEFAULT '0',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `views` bigint(11) NOT NULL DEFAULT '0',
  `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `author` text NOT NULL,
  `rom` text NOT NULL,
  `model` text NOT NULL,
  `maturity` text NOT NULL,
  `category1` text NOT NULL,
  `category2` text NOT NULL,
  `category3` text NOT NULL,
  `category4` text NOT NULL,
  `screen0` tinyint(4) NOT NULL DEFAULT '0',
  `screen1` tinyint(4) NOT NULL DEFAULT '0',
  `screen2` tinyint(4) NOT NULL DEFAULT '0',
  `screen3` tinyint(4) NOT NULL DEFAULT '0',
  `screen4` tinyint(4) NOT NULL DEFAULT '0',
  `creator` text NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `fulltext` (`name`,`summary`,`description`,`author`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

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

--
-- Tabellenstruktur für Tabelle `swi_appcategory`
--

CREATE TABLE IF NOT EXISTS `swi_appcategory` (
  `catid` int(11) NOT NULL DEFAULT '0',
  `appid` int(11) NOT NULL DEFAULT '0',
  `number` tinyint(4) NOT NULL DEFAULT '0',
  UNIQUE KEY `appid` (`appid`,`number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_categories`
--

CREATE TABLE IF NOT EXISTS `swi_categories` (
  `id` int(4) NOT NULL DEFAULT '0',
  `category` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_changerequest`
--

CREATE TABLE IF NOT EXISTS `swi_changerequest` (
  `number` bigint(20) NOT NULL DEFAULT '0',
  `when` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `appid` int(11) NOT NULL DEFAULT '0',
  `field` text NOT NULL,
  `newvalue` text NOT NULL,
  `requestor` text NOT NULL,
  `reason` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_comment`
--

CREATE TABLE IF NOT EXISTS `swi_comment` (
  `appid` int(11) NOT NULL DEFAULT '0',
  `version` text NOT NULL,
  `from` text NOT NULL,
  `subject` text NOT NULL,
  `body` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_links`
--

CREATE TABLE IF NOT EXISTS `swi_links` (
  `url` text NOT NULL,
  `timestamp` int(11) NOT NULL,
  `result` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_subscription`
--

CREATE TABLE IF NOT EXISTS `swi_subscription` (
  `appid` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`appid`,`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_temp`
--

CREATE TABLE IF NOT EXISTS `swi_temp` (
  `category1` varchar(50) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_users`
--

CREATE TABLE IF NOT EXISTS `swi_users` (
  `email` varchar(255) NOT NULL DEFAULT '',
  `password` text NOT NULL,
  `registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `enabled` tinyint(4) NOT NULL DEFAULT '0',
  `manage` tinyint(4) NOT NULL DEFAULT '0',
  `permissions` text NOT NULL,
  PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `swi_visitors`
--

CREATE TABLE IF NOT EXISTS `swi_visitors` (
  `appid` int(11) NOT NULL DEFAULT '0',
  `when` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `IP` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Tabellenstruktur für Tabelle `votes`
--

CREATE TABLE IF NOT EXISTS `votes` (
  `choice` text NOT NULL,
  `ip` text NOT NULL,
  `host` text NOT NULL,
  `added` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
