[phpwebapp-commits] CVS: top10/db inima_top10.sql,NONE,1.1.2.1

[Dashamir H. <das...@us...>]

Update of /cvsroot/phpwebapp/top10/db
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv19514/db

Added Files:
      Tag: maisp
	inima_top10.sql 
Log Message:


--- NEW FILE: inima_top10.sql ---
# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Feb 07, 2004 at 02:07 PM
# Server version: 4.0.16
# PHP Version: 4.3.4
# 
# Database : `inima_top10`
# 
CREATE DATABASE IF NOT EXISTS inima_top10;
USE inima_top10;

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

#
# Table structure for table `categories`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 15, 2004 at 04:57 PM
#

DROP TABLE IF EXISTS categories;
CREATE TABLE categories (
  category varchar(50) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `categories`
#

INSERT INTO categories (category) VALUES ('web application framework'),
('content managment system'),
('document managment system'),
('groupware'),
('wiki');

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

#
# Table structure for table `comments`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 15, 2004 at 04:57 PM
#

DROP TABLE IF EXISTS comments;
CREATE TABLE comments (
  comment_id int(10) unsigned NOT NULL auto_increment,
  proj_id varchar(100) NOT NULL default '',
  username varchar(30) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  comment text NOT NULL,
  date date NOT NULL default '0000-00-00',
  ip varchar(20) NOT NULL default '',
  PRIMARY KEY  (comment_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `comments`
#


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

#
# Table structure for table `languages`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 15, 2004 at 04:57 PM
#

DROP TABLE IF EXISTS languages;
CREATE TABLE languages (
  prog_lang varchar(30) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `languages`
#

INSERT INTO languages (prog_lang) VALUES ('PHP'),
('Perl'),
('JSP'),
('Java');

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

#
# Table structure for table `licenses`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 15, 2004 at 04:57 PM
#

DROP TABLE IF EXISTS licenses;
CREATE TABLE licenses (
  license varchar(50) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table `licenses`
#

INSERT INTO licenses (license) VALUES ('GPL'),
('LGPL');

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

#
# Table structure for table `preference_list`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 15, 2004 at 04:57 PM
#

DROP TABLE IF EXISTS preference_list;
CREATE TABLE preference_list (
  proj_id varchar(100) NOT NULL default '',
  username varchar(30) NOT NULL default '',
  position smallint(4) NOT NULL default '0',
  PRIMARY KEY  (proj_id,username)
) TYPE=MyISAM;

#
# Dumping data for table `preference_list`
#

INSERT INTO preference_list (proj_id, username, position) VALUES ('doulos', 'test', 10),
('webdocwf', 'test', 9),
('struts-menu', 'dashohoxha', 0),
('echo', 'dasho', 1),
('echopoint', 'dasho', 0),
('eservices', 'test', 8),
('htmltable', 'test', 7),
('jspwidget', 'test', 6),
('wact', 'test', 5),
('ojbc', 'test', 4),
('nunitasp', 'test', 3),
('j-tr', 'test', 2),
('realmethods', 'test', 1),
('obliquid', 'test', 0),
('tapestry', 'test', 11),
('aft', 'test', 12),
('doulos', 'dashohoxha', 2),
('tapestry', 'dashohoxha', 3),
('phpmvc', 'dashohoxha', 4),
('ojbc', 'dashohoxha', 5),
('wact', 'dashohoxha', 6);

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

#
# Table structure for table `proj_list`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 17, 2004 at 05:21 PM
#

DROP TABLE IF EXISTS proj_list;
CREATE TABLE proj_list (
  proj_id varchar(100) NOT NULL default '',
  proj_name varchar(100) NOT NULL default '',
  proj_descr text NOT NULL,
  url1 varchar(255) default NULL,
  url2 varchar(255) default NULL,
  category varchar(100) NOT NULL default '',
  status varchar(10) NOT NULL default '',
  license varchar(100) NOT NULL default '',
  prog_lang varchar(100) NOT NULL default '',
  register_date date default NULL,
  group_id varchar(10) NOT NULL default '',
  points int(11) NOT NULL default '0',
  nr_comments int(11) NOT NULL default '0',
  PRIMARY KEY  (proj_id)
) TYPE=MyISAM;

#
# Dumping data for table `proj_list`
#

INSERT INTO proj_list (proj_id, proj_name, proj_descr, url1, url2, category, status, license, prog_lang, register_date, group_id, points, nr_comments) VALUES ('GLUE', 'GNU Internet groupware project', 'The GNU GLUE (GNU Links Users Everywhere) projects will create a distributed groupware application framework based on emerging new Internet standards such as XML, WebDAV, and RTSP, suitable for both synchronous and asynchronous and both on-line and disconnected operation.', 'http://www.gnu.org/directory/glue.html', 'http://www.gnu.org/software/glue/glue.html', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-15', '', 0, 0),
('SXML', 'SXML', 'SXML defines and implements a markup language. When the program is given a document containing user defined tags and their definition, it produces a new document, which is generated by replacing the tags with their definition (you can asssociate functions to tags).', 'http://www.gnu.org/directory/sxml.html', 'http://medialab.di.unipi.it/Project/SXML/', 'web application framework', 'approved', 'GPL', 'Perl', '2004-01-17', '', 0, 0),
('Metahtml', 'Metahtml', 'Meta-HTML is a powerful, extensible server-side programming language specifically designed for working on the World Wide Web. It resembles a cross between HTML and Lisp and has a huge existing function library, including support for sockets, image creation, Perl, GNU plot, etc. It is extensible in both Meta-HTML and other languages (C, etc.)', 'http://www.gnu.org/directory/metahtml.html', 'http://www.metahtml.org/', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-17', '', 0, 0),
('Roxen', 'Roxen', 'Roxen WebServer is a full-featured open-source web server distributed under the GPL license. It runs on a number of different operating systems including Windows, Linux, Solaris and Mac OS X.', 'http://www.gnu.org/directory/roxen.html', 'http://www.roxen.com/products/webserver/', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-17', '', 0, 0),
('OpenACS', 'OpenACS', 'OpenACS (Open ArsDigita Community System) is an advanced toolkit for building scalable, community-oriented web applications for the Oracle RDBMS, ported to PostgreSQL. It is an advanced Web toolkit that focuses on collaboration, and includes over 40 modules. It relies on AOLserver, a web/application server, and PostgreSQL, a true ACID-compliant RDBMS.', 'http://www.gnu.org/directory/openacs.html', 'http://openacs.org/', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-17', '', 0, 0),
('Gedafe', 'Generic Database Front-End', 'Gedafe is an application independent end-user web front-end for databases. This means that the front-end has no information about the structure and contents of the database. All application logic along with meta-information on how to present the data, is put into the database. The front-end gathers this information and uses it to build the user interface. This greatly reduces development time since you only have to develop the application at the database level', 'http://www.gnu.org/directory/gedafe.html', 'http://isg.ee.ethz.ch/tools/gedafe/', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-17', '', 0, 0),
('Bigwig', 'Bigwig', '\'bigwig\' is a high-level programming language for developing interactive Web services. Programs are compiled into a conglomerate of lower-level technologies such as C code, HTTP, HTML, JavaScript, and SSL, all running on top of a runtime system based on an Apache Web server module.', 'http://www.gnu.org/directory/bigwig.html', 'http://www.brics.dk/bigwig/oldindex.html', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-17', '', 0, 0),
('JWIG', 'Java Extensions for High-Level Web Service Development', 'JWIG is a Java-based development system for making advanced Web services. It integrates the central features of the <bigwig> language into Java by providing explicit support for Web service sessions and safe XHTML dynamic document construction.', 'http://www.brics.dk/JWIG/', '', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-17', '', 0, 0),
('HTML::Mason', 'HTML::Mason', 'HTML::Mason is a web site development and delivery system that constructs web pages and sites from shared, reusable building blocks called components. Components contain a mix of Perl and HTML, and can call each other and pass values back and forth like subroutines. They increase modularity and eliminate repetitive work. HTML::Mason is most powerful when used in conjunction with mod_perl, but can be used in standalone applications as well.', 'http://www.gnu.org/directory/HTML-Mason.html', 'http://www.masonhq.com/', 'web application framework', 'approved', 'GPL', 'Perl', '2004-01-17', '', 0, 0),
('WDialog', 'WDialog', 'WDialog is a system to make dialog-centric Web applications. It imitates the behavior of widgets found in GUIs, but acts in an HTML/HTTP environment. It uses its own XML-based UI language, but callbacks are coded in either O\'Caml or Perl. WDialog is written in the programming language Objective Caml', 'http://www.gnu.org/directory/wdialog.html', 'http://wdialog.sourceforge.net/', 'web application framework', 'approved', 'GPL', 'PHP', '2004-01-17', '', 0, 0);

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

#
# Table structure for table `proj_members`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 17, 2004 at 05:20 PM
#

DROP TABLE IF EXISTS proj_members;
CREATE TABLE proj_members (
  proj_id varchar(100) NOT NULL default '',
  username varchar(30) NOT NULL default '',
  PRIMARY KEY  (proj_id,username)
) TYPE=MyISAM;

#
# Dumping data for table `proj_members`
#

INSERT INTO proj_members (proj_id, username) VALUES ('Bigwig', 'amo...@br...'),
('Bigwig', 'br...@br...'),
('Bigwig', 'mi...@br...'),
('Bigwig', 'ol...@br...'),
('Bigwig', 'ri...@br...'),
('ezln23-service', '-'),
('Gedafe', 'dw...@ee...'),
('Gedafe', 'oe...@ee...'),
('Gedafe', 'za...@ee...'),
('GLUE', 'fl...@us...'),
('HTML::Mason', 'mas...@ma...'),
('jaffa', 'dashohoxha'),
('jaffa', 'test'),
('jwebunit', 'dashohoxha'),
('JWIG', 'amo...@br...'),
('JWIG', 'mi...@br...'),
('Metahtml', 'bf...@gn...'),
('OpenACS', 'be...@mi...'),
('Roxen', 'su...@ro...'),
('salmon', 'dasho'),
('salmon', 'test'),
('sslext', 'dasho'),
('strutsgenerator', 'dashohoxha'),
('SXML', 'cis...@di...'),
('test', 'usr1'),
('test', 'usr2'),
('WDialog', 'ge...@ge...');

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

#
# Table structure for table `requests`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 15, 2004 at 04:57 PM
#

DROP TABLE IF EXISTS requests;
CREATE TABLE requests (
  request_id varchar(50) NOT NULL default '',
  time timestamp(14) NOT NULL,
  username varchar(30) NOT NULL default '',
  ip varchar(20) NOT NULL default '',
  type varchar(30) NOT NULL default '',
  data varchar(255) NOT NULL default '',
  status varchar(10) NOT NULL default '',
  PRIMARY KEY  (request_id)
) TYPE=MyISAM;

#
# Dumping data for table `requests`
#


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

#
# Table structure for table `session`
#
# Creation: Jan 05, 2004 at 05:22 PM
# Last update: Jan 17, 2004 at 11:43 AM
#

DROP TABLE IF EXISTS session;
CREATE TABLE session (
  id varchar(255) NOT NULL default '',
  vars text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `session`
#

INSERT INTO session (id, vars) VALUES ('IP: 62.94.150.82; DATE: 2004-01-05 17:22:10', 'a:0:{}'),
('IP: 62.94.150.82; DATE: 2004-01-06 14:51:02', 'a:0:{}'),
('IP: 213.209.169.74; DATE: 2004-01-06 16:19:19', 'a:0:{}'),
('IP: 63.227.208.158; DATE: 2004-01-06 18:16:17', 'a:0:{}'),
('IP: 63.227.208.158; DATE: 2004-01-06 18:23:39', 'a:0:{}'),
('IP: 62.94.150.82; DATE: 2004-01-09 15:00:30', 'a:0:{}'),
('IP: 62.94.150.82; DATE: 2004-01-15 16:55:50', 'a:0:{}'),
('IP: 62.94.150.82; DATE: 2004-01-15 17:08:03', 'a:0:{}'),
('IP: 62.94.150.82; DATE: 2004-01-16 14:47:54', 'a:0:{}'),
('IP: 62.94.150.82; DATE: 2004-01-16 15:11:26', 'a:0:{}'),
('IP: 193.254.1.36; DATE: 2004-01-17 09:23:42', 'a:0:{}'),
('IP: 193.254.1.36; DATE: 2004-01-17 11:43:20', 'a:0:{}');

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

#
# Table structure for table `users`
#
# Creation: Jan 15, 2004 at 04:57 PM
# Last update: Jan 17, 2004 at 02:41 PM
#

DROP TABLE IF EXISTS users;
CREATE TABLE users (
  username varchar(30) NOT NULL default '',
  realname varchar(50) default NULL,
  email varchar(50) NOT NULL default '',
  homepage varchar(50) default NULL,
  status varchar(10) NOT NULL default 'private',
  KEY primarykey (username)
) TYPE=MyISAM;

#
# Dumping data for table `users`
#

INSERT INTO users (username, realname, email, homepage, status) VALUES ('rms', '', 'rm...@gn...', '', 'private'),
('karl', '', 'ka...@fr...', '', 'private'),
('dasho', 'Dashamir Hoxha', 'da...@so...', 'http://', 'private');