User:IOOI/GNUstepSoftwareIndex/Data Model

please sign your edit with four tildes ( ~~~~ )

Old database schema

 # phpMyAdmin SQL Dump
 # version 2.5.6
 # http://www.phpmyadmin.net
 #
 # Host: mysql.gnustep.org
 # Erstellungszeit: 16. Februar 2010 um 13:24
 # Server Version: 4.0.20
 # PHP-Version: 4.3.8
 #
 # Datenbank: `gnustep`
 #
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs`
 #
 
 CREATE TABLE `swi_gs` (
   `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,
   `sourceurl` text NOT NULL,
   `updated` datetime default '0000-00-00 00:00:00',
   `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,
   `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,
   `maturity` text NOT NULL,
   `feedurl` text NOT NULL,
   `replacedby` int(11) NOT NULL default '0',
   PRIMARY KEY  (`id`),
   FULLTEXT KEY `fulltext` (`name`,`summary`,`description`,`author`)
 ) ENGINE=MyISAM CHARACTER SET utf8mb3 AUTO_INCREMENT=108 ;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_appcategory`
 #
 
 CREATE TABLE `swi_gs_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 CHARACTER SET utf8mb3;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_categories`
 #
 
 CREATE TABLE `swi_gs_categories` (
   `id` int(4) NOT NULL default '0',
   `category` text NOT NULL,
   PRIMARY KEY  (`id`)
 ) ENGINE=MyISAM CHARACTER SET utf8mb3;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_changerequest`
 #
 
 CREATE TABLE `swi_gs_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 CHARACTER SET utf8mb3;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_comment`
 #
 
 CREATE TABLE `swi_gs_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 CHARACTER SET utf8mb3;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_subscription`
 #
 
 CREATE TABLE `swi_gs_subscription` (
   `appid` int(11) NOT NULL default '0',
   `email` varchar(255) NOT NULL default ,
   PRIMARY KEY  (`appid`,`email`)
 ) ENGINE=MyISAM CHARACTER SET utf8mb3;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_temp`
 #
 
 CREATE TABLE `swi_gs_temp` (
   `category1` varchar(50) default NULL
 ) ENGINE=HEAP;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_users`
 #
 
 CREATE TABLE `swi_gs_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',
   `permissions` text NOT NULL,
   PRIMARY KEY  (`email`)
 ) ENGINE=MyISAM CHARACTER SET utf8mb3;
 
 # --------------------------------------------------------
 
 #
 # structure for table `swi_gs_visitors`
 #
 
 CREATE TABLE `swi_gs_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 CHARACTER SET utf8mb3;