One Hat Cyber Team

Edit File: nosc.sql

# MySQL dump 4.0
#
# Host: localhost    Database: nosc
#--------------------------------------------------------

#
# Table structure for table 'AA'
#
CREATE TABLE AA (
  author_id bigint(20) unsigned DEFAULT '0' NOT NULL,
  article_id int(10) DEFAULT '0' NOT NULL,
  author_ambition int(10),
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  PRIMARY KEY (id)
);

#
# Dumping data for table 'AA'
#

INSERT INTO AA VALUES (12,88,12,136);
INSERT INTO AA VALUES (23,88,11,135);
INSERT INTO AA VALUES (17,83,3,87);
INSERT INTO AA VALUES (16,3,2,158);
INSERT INTO AA VALUES (8,3,1,157);
INSERT INTO AA VALUES (18,138,1,123);
INSERT INTO AA VALUES (30,141,1,14);
INSERT INTO AA VALUES (11,141,2,15);
INSERT INTO AA VALUES (25,83,1,86);
INSERT INTO AA VALUES (27,83,2,85);
INSERT INTO AA VALUES (23,140,1,145);
INSERT INTO AA VALUES (31,139,15,112);
INSERT INTO AA VALUES (10,139,2,111);
INSERT INTO AA VALUES (18,139,1,110);
INSERT INTO AA VALUES (20,139,4,109);
INSERT INTO AA VALUES (25,139,6,108);
INSERT INTO AA VALUES (30,139,8,107);
INSERT INTO AA VALUES (26,139,9,106);
INSERT INTO AA VALUES (11,139,10,105);
INSERT INTO AA VALUES (7,88,9,134);
INSERT INTO AA VALUES (29,139,14,104);
INSERT INTO AA VALUES (28,139,12,103);
INSERT INTO AA VALUES (22,139,3,102);
INSERT INTO AA VALUES (21,139,5,101);
INSERT INTO AA VALUES (24,139,7,100);
INSERT INTO AA VALUES (32,2,2,160);
INSERT INTO AA VALUES (16,2,1,159);
INSERT INTO AA VALUES (8,1,1,154);
INSERT INTO AA VALUES (8,136,7,146);
INSERT INTO AA VALUES (20,142,2,144);
INSERT INTO AA VALUES (3,144,10,153);
INSERT INTO AA VALUES (29,144,8,152);
INSERT INTO AA VALUES (23,144,7,151);
INSERT INTO AA VALUES (20,143,1,125);
INSERT INTO AA VALUES (3,143,2,124);
INSERT INTO AA VALUES (18,83,4,88);
INSERT INTO AA VALUES (24,138,2,122);
INSERT INTO AA VALUES (26,88,6,133);
INSERT INTO AA VALUES (9,88,2,132);
INSERT INTO AA VALUES (22,88,4,131);
INSERT INTO AA VALUES (31,88,5,130);
INSERT INTO AA VALUES (21,88,7,129);
INSERT INTO AA VALUES (19,139,13,99);
INSERT INTO AA VALUES (17,88,8,128);
INSERT INTO AA VALUES (20,88,10,127);
INSERT INTO AA VALUES (3,88,13,126);
INSERT INTO AA VALUES (12,144,5,150);
INSERT INTO AA VALUES (20,144,4,149);
INSERT INTO AA VALUES (30,144,3,148);
INSERT INTO AA VALUES (10,144,1,147);

#
# Table structure for table 'AA_temp'
#
CREATE TABLE AA_temp (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  author_id bigint(20) DEFAULT '0' NOT NULL,
  article_id bigint(20) DEFAULT '0' NOT NULL,
  author_ambition int(10) unsigned,
  PRIMARY KEY (id)
);

#
# Dumping data for table 'AA_temp'
#

INSERT INTO AA_temp VALUES (1,8,3,1);
INSERT INTO AA_temp VALUES (2,16,3,2);

#
# Table structure for table 'Articles'
#
CREATE TABLE Articles (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  title varchar(255),
  received date,
  referee_1 varchar(20),
  sent_to_referee_1 date,
  received_from_referee_1 date,
  sent_to_author_1 date,
  received_from_author_1 date,
  referee_2 varchar(20),
  sent_to_referee_2 date,
  received_from_referee_2 date,
  status varchar(60),
  published_volume smallint(6),
  published_number smallint(6),
  published_year smallint(6),
  published_page_start smallint(6),
  published_page_end smallint(6),
  sent_to_author_2 date,
  received_from_author_2 date,
  notes text,
  abstract text,
  pdf text,
  PRIMARY KEY (id)
);

#
# Dumping data for table 'Articles'
#

INSERT INTO Articles VALUES (2,'A computational modification of the numerical-analytic\r\nmethod for periodic boundary value problems','1998-09-13','','0000-00-00','0000-00-00','0000-00-00','0000-00-00','','0000-00-00','0000-00-00','published',2,1,0,109,114,'0000-00-00','0000-00-00','','We introduce a new variant of the numerical-analytic method\r\nand investigate its feasibility for practical computations.',NULL);
INSERT INTO Articles VALUES (1,'On some boundary value problems with non-local\r\n conditions','1999-01-19','','0000-00-00','0000-00-00','0000-00-00','0000-00-00','','0000-00-00','0000-00-00','published',2,1,0,92,108,'0000-00-00','0000-00-00','','A way of investigating the solutions of non-linear\r\n boundary value problems with \"degenerate,\" in a sense, \r\nlocal and non-local boundary conditions is discussed.',NULL);
INSERT INTO Articles VALUES (3,'A note on the numerical-analytic method for nonlinear two-point\r\nboundary-value problems','2001-05-01','','0000-00-00','0000-00-00','0000-00-00','0000-00-00','','0000-00-00','0000-00-00','published',4,1,0,112,128,'0000-00-00','0000-00-00','','We discuss some techniques useful for the investigation \r\nof nonlinear \r\nboundary-value problems with \"separated\" \r\nnonlinear boundary conditions.',NULL);

#
# Table structure for table 'Authors'
#
CREATE TABLE Authors (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  last_name varchar(50),
  first_name varchar(50),
  middle_name varchar(30),
  title varchar(20),
  affiliation varchar(255),
  street varchar(255),
  city varchar(50),
  state varchar(50),
  postal_code varchar(20),
  country varchar(50),
  home_address text,
  phone varchar(30),
  fax varchar(30),
  email varchar(50),
  editor tinyint(3),
  note text,
  short_name varchar(60),
  PRIMARY KEY (id)
);

#
# Dumping data for table 'Authors'
#

INSERT INTO Authors VALUES (3,'He','Ji-Huan','','Prof.','Shanghai University','149 Yanchang Road, P.O. Box 189','Shanghai','','200072','China','','','','jhhe@mail.shu.edu.ch',1,'','Ji-Huan He');
INSERT INTO Authors VALUES (12,'Chua','Leon','Ong','Prof.','Department of Electrical Engineering\\\\\r\nUniversity of California','','Berkley','State','CA 94720','USA','','','510 845 4267','',1,'','L. O. Chua');
INSERT INTO Authors VALUES (7,'Drakhlin','Michael','','Prof.','The Research Institute \\\\\r\nThe College of Judea and Samaria','','Ariel','','44837','Israel','','','','drakhlin@yosh.ac.il',1,'','M. Drakhlin');
INSERT INTO Authors VALUES (8,'Ronto','Andrei','','Dr.','Institute of Mathematics, NAS of Ukraine','3 Tereshchenkovskaya St.','Kiev','','01601','Ukraine','phone +38 +044 441374','+38 +044 2246153','+38 +044 2352010','ar@imath.kiev.ua',1,'',NULL);
INSERT INTO Authors VALUES (9,'Fabrizio','M.','','Prof.','Dipartimento di Matematica  \\\\\r\nUniversity Degli Studi di Bologna','Piazza di Porta S.~Donato','Bologna','','5-40127','Italy','','','','fabrizio@dm.UniBo.it',1,'',NULL);
INSERT INTO Authors VALUES (10,'Palmer','Kenneth','J.','Prof.','Centre of Financial Studies\\\\\r\nFaculty of Economics and Commerce\\\\\r\nThe University of Melbourne','','Melbourne','Victoria','3010','Australia','','','+61 3 9349 2397','',1,'',NULL);
INSERT INTO Authors VALUES (11,'Van Dao','Nguyen','','Prof.','Vietnam National University','144, Xuan Thuy, Cau Giay','Hanoi','','','Vietnam','','','+84 +4 8340724','vandao@vnu.ac.vn',1,'',NULL);
INSERT INTO Authors VALUES (16,'Ront\\\'o','Mikl\\\'os','','Prof. Dr.','Institute of Mathematics, University of Miskolc','Miskolc-Egyetemv\\\'aros','Miskolc','','H-3515','Hungary','some addr','00 0','','matronto@gold.uni-miskolc.hu',1,'',NULL);
INSERT INTO Authors VALUES (17,'Samoilenko','Anatoly','M.','Academician','Institute of Mathematics, NAS of Ukraine','3 Tereshchenkovskaya St.','Kiev','','01601','Ukraine','','+38 +044 2246153','+38 +044 2352010','sam@imath.kiev.ua',2,'',NULL);
INSERT INTO Authors VALUES (18,'Mawhin','Jean','','Prof.','Institut Math\\\'ematique\\\\\r\nUniversit\\\'e Catholique de Louvain','Chemin du Cyclotron, 2','Louvain-la-Neuve','','B-1348','Belgium','','','','mawhin@amm.ucl.ac.be',1,'',NULL);
INSERT INTO Authors VALUES (19,'Agarwal','Ravi','P.','Prof.','Department of Mathematics \\\\\r\n National University of Singapore','10 Kent Ridge Crescent','Singapore','','119260','Singapore','','','','matravip@nus.edu.sg',1,'',NULL);
INSERT INTO Authors VALUES (20,'Grebenikov','Eugenii','A.','Prof. Dr.','Institute for High-Performance Computing Systems\\\\\r\nRussian Academy of Sciences','37 Vavilova St.','Moscow','','117312','Russia','','','','gea@ipk.msk.su',1,'% Institute of Mathematics and Physics\\\\\r\n University of Sie','E. A. Grebenikov');
INSERT INTO Authors VALUES (21,'Rozov','Nicholas','Hr.','Prof.','Lomonosov State University','Vorobievy Gory','Moscow','','119899','Russia','','','','rozov@rozov.mccme.ru',1,'',NULL);
INSERT INTO Authors VALUES (22,'Pliss','Victor','A.','Prof.','St.-Petersbourg State University','2 Bibliotechnaya Sq.','St.-Petersbourg','','19890','Russia','','','','vapliss@vp2915.spb.edu',1,'',NULL);
INSERT INTO Authors VALUES (23,'Petryshyn','Roman','I.','Prof.','Fed\'kovich  University','2 Kotlyarevskogo St.','Chernivtsi','','274912','Ukraine','','','','rompetr@math.chdu.cv.ua',1,'',NULL);
INSERT INTO Authors VALUES (24,'Plotnikov','Victor','A.','Prof. Dr.','Mechnikov State University','2 Petra Velikogo St.','Odessa','','270100','Ukraine','','','','v.plotnikov@paco.net',1,'','V. A. Plotnikov');
INSERT INTO Authors VALUES (25,'Pykarpatsky','Anatoly','K.','Prof. Dr.','Mining and Metallurgical Academy (AGH)','30 Al. Mickiewicza St.','Krakow','','30-059','Poland','','','+48 +12 17 31 65','prika@mat.agh.edu.pl',1,'','A. K. Pykarpatsky');
INSERT INTO Authors VALUES (26,'Sell','George','R.','Prof.','University of Minnesota\\\\\r\nSchool of Mathematics','206 Church Street, S.E.','Minneapolis','','MN 55455','USA','','','+612 626 2017','sell@math.umn.edu',1,'',NULL);
INSERT INTO Authors VALUES (27,'Tvrd\\\'y','Milan','','Prof. Dr.','Mathematical Institute\\\\\r\nAcademy of Sciences of the Czech Republic','\\v{Z}itn\\\'a 25','Praha','','11567','Czech Republic','','','420 2 22211638','tvrdy@math.cas.cz',1,'','M. Tvrd\\\'y');
INSERT INTO Authors VALUES (28,'Shkil','Mykola','I.','Prof. Dr.','Drahomanov Pedagogical University','9 Pirogov St.','Kiev','','01030','Ukraine','','','','postmaster@crame.freenet.kiev.ua',1,'',NULL);
INSERT INTO Authors VALUES (29,'Martyniuk','Anatoly','A.','Prof. Dr.','Institute of Mechanics\\\\\r\nNational Academy of Sciences of Ukraine','3 Nesterov St.','Kiev','','03057','Ukraine','','','','',1,'',NULL);
INSERT INTO Authors VALUES (30,'Petryshyn','Wolodymyr','V.','Prof.','Department of Mathematics \\\\\r\nHill Center Rutgers University','','New Brunswick','New Jersey','08903','USA','','','','',1,'',NULL);
INSERT INTO Authors VALUES (31,'Mytropol\'sky','Yuri','O.','Academician','Institute of Mathematics, NAS of Ukraine','3 Tereshchenkovskaya St.','Kiev','','01601','Ukraine','','','+38 +044 2352010','',2,'','Yu. O. Mytropol\'sky');
INSERT INTO Authors VALUES (32,'Gal\\\'antai','Aurel','','Prof.','Institute of Mathematics, University of Miskolc','Miskolc-Egyetemv\\\'aros','Miskolc','','H-3515','Hungary','','','','matgal@gold.uni-miskolc.hu',0,'','A. Gal\\\'antai');

#
# Table structure for table 'LA'
#
CREATE TABLE LA (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  author_id int(10),
  letter_id int(10),
  PRIMARY KEY (id)
);

#
# Dumping data for table 'LA'
#

#
# Table structure for table 'LA_temp'
#
CREATE TABLE LA_temp (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  author_id int(10),
  letter_id int(10),
  PRIMARY KEY (id)
);

#
# Dumping data for table 'LA_temp'
#

#
# Table structure for table 'Letters'
#
CREATE TABLE Letters (
  id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
  text text DEFAULT '' NOT NULL,
  date date,
  subject varchar(60),
  opening text DEFAULT '' NOT NULL,
  closing text,
  signature text,
  PRIMARY KEY (id)
);

#
# Dumping data for table 'Letters'
#

INSERT INTO Letters VALUES (1,'Some text','2000-01-01','some subject','Dear Dr Some,','Sincerely,','A. Sam, Editor-in-Chief');

#
# Table structure for table 'Status'
#
CREATE TABLE Status (
  status_key varchar(60) DEFAULT '' NOT NULL,
  status_val tinyint(3) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'Status'
#

INSERT INTO Status VALUES ('rejected',0);
INSERT INTO Status VALUES ('review_1',1);
INSERT INTO Status VALUES ('review_2',2);
INSERT INTO Status VALUES ('accepted',3);
INSERT INTO Status VALUES ('published',4);