Author: pwang
Date: 2011-01-24 15:47:25 -0800 (Mon, 24 Jan 2011)
New Revision: 23586
Added:
new_cytoscape_website/plugin_website/plugins3/
new_cytoscape_website/plugin_website/plugins3/cyplugindb3_schema/
new_cytoscape_website/plugin_website/plugins3/cyplugindb3_schema/CyPluginDB3_schema.sql
Log:
Original creation
Added:
new_cytoscape_website/plugin_website/plugins3/cyplugindb3_schema/CyPluginDB3_schema.sql
===================================================================
---
new_cytoscape_website/plugin_website/plugins3/cyplugindb3_schema/CyPluginDB3_schema.sql
(rev 0)
+++
new_cytoscape_website/plugin_website/plugins3/cyplugindb3_schema/CyPluginDB3_schema.sql
2011-01-24 23:47:25 UTC (rev 23586)
@@ -0,0 +1,139 @@
+#DROP DATABASE IF EXISTS cyplugindb3;
+#CREATE DATABASE cyplugindb3;
+
+USE cyplugindb3;
+
+CREATE TABLE authors (
+ author_auto_id int(11) NOT NULL auto_increment,
+ names varchar(150) default NULL,
+ email varchar(90) default NULL,
+ affiliation varchar(150) default NULL,
+ affiliationURL varchar(200) default NULL,
+ PRIMARY KEY (author_auto_id)
+);
+
+CREATE TABLE categories (
+ category_id int(11) NOT NULL,
+ name varchar(50) NOT NULL,
+ description varchar(100) default NULL,
+ PRIMARY KEY (category_id)
+);
+
+INSERT INTO categories VALUES
+(1,'Core','Cytoscape core'),
+(2,'Analysis','Used for analyzing existing networks'),
+(3,'Network and Attribute I/O','Used for importing networks and attributes in
different file formats'),
+(4,'Network Inference','Used for inferring new networks'),
+(5,'Functional Enrichment','Used for functional enrichment of networks'),
+(6,'Communication/Scripting','Used for communicating with or scripting
Cytoscape'),
+(7,'Other','None of the above');
+
+CREATE TABLE plugin_author (
+ plugin_version_id int(11) default NULL,
+ author_id int(11) default NULL,
+ authorship_seq int(11) default NULL
+);
+
+CREATE TABLE plugin_files (
+ plugin_file_auto_id int(11) NOT NULL auto_increment,
+ file_data longblob,
+ file_type enum('jar','zip') default NULL,
+ file_name varchar(100) default NULL,
+ md5 varchar(40),
+ PRIMARY KEY (plugin_file_auto_id)
+);
+
+CREATE TABLE plugin_list (
+ plugin_auto_id int(11) NOT NULL auto_increment,
+ name varchar(100) NOT NULL,
+ unique_id int,
+ description text,
+ license text,
+ license_required varchar(3) default NULL,
+ project_url varchar(100) default NULL,
+ category_id int(11) default NULL,
+ sysdat date default NULL,
+ PRIMARY KEY (plugin_auto_id)
+);
+
+CREATE TABLE plugin_version (
+ version_auto_id int(11) NOT NULL auto_increment,
+ plugin_id int(11) default NULL,
+ plugin_file_id int(11) default NULL,
+ cy_version set('3.0','3.1','3.2','3.3') default NULL,
+ version double default '0.1',
+ release_date date default NULL,
+ release_note text,
+ release_note_url varchar(100) default NULL,
+ minimum_java_version varchar(10),
+ comment text,
+ jar_url varchar(100) default NULL,
+ source_url varchar(100) default NULL,
+ status varchar(20) default NULL,
+ reference text,
+ theme_only ENUM('yes', 'no') DEFAULT 'no',
+ download_count int(11),
+ sysdat date default NULL,
+ PRIMARY KEY (version_auto_id)
+);
+
+CREATE TABLE usagelog (
+ log_auto_id int not null auto_increment,
+ plugin_version_id int(11) NOT NULL,
+ remote_host varchar(60) default NULL,
+ ip_address varchar(20) default NULL,
+ refer_page varchar(99),
+ sysdat date default NULL,
+ PRIMARY KEY (log_auto_id)
+);
+
+CREATE TABLE contacts (
+ contact_auto_id int not null auto_increment,
+ name varchar(99),
+ email varchar(99),
+ plugin_version_id int,
+ sysdat date default NULL,
+ PRIMARY KEY (contact_auto_id)
+);
+
+CREATE TABLE theme_list (
+ theme_auto_id int(11) NOT NULL auto_increment,
+ name varchar(100) NOT NULL,
+ unique_id int,
+ description text,
+ sysdat date,
+ PRIMARY KEY (theme_auto_id)
+);
+
+CREATE TABLE theme_version (
+ version_auto_id int(11) NOT NULL auto_increment,
+ theme_id int(11) NOT NULL,
+ cy_version set('2.6','2.7 ','2.8') default NULL,
+ version double default '0.1',
+ release_date date default NULL,
+ status varchar(20) default NULL,
+ sysdat date default NULL,
+ PRIMARY KEY (version_auto_id)
+);
+
+CREATE TABLE theme_plugin (
+ theme_plugin_auto_id int(11) NOT NULL auto_increment,
+ theme_version_id int(11),
+ plugin_version_id int(11),
+ PRIMARY KEY (theme_plugin_auto_id)
+);
+
+CREATE TABLE description_words (
+ word_id int(11) NOT NULL auto_increment,
+ word varchar(100) NOT NULL,
+ plugin_count int,
+ PRIMARY KEY (word_id)
+);
+
+CREATE TABLE description_word_link (
+ id int(11) NOT NULL auto_increment,
+ word_id int NOT NULL,
+ plugin_id int NOT NULL,
+ frequency float,
+ PRIMARY KEY (id)
+);
--
You received this message because you are subscribed to the Google Groups
"cytoscape-cvs" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/cytoscape-cvs?hl=en.
