Don't like ads? PRO users don't see any ads ;-)
Public Pastes

#Hacked Databases 3 .edu 1 .gov

By: xL3gi0n on Jul 31st, 2012  |  syntax: MySQL  |  size: 33.04 KB  |  hits: 1,029  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.       _     _____       _  ___        
  2. __  _| |   |___ /  __ _(_)/ _ \ _ __  
  3. \ \/ / |     |_ \ / _` | | | | | '_ \
  4. >  <| |___ ___) | (_| | | |_| | | | |
  5. /_/\_\_____|____/ \__, |_|\___/|_| |_|
  6.                  |___/                    
  7. [-------------------------------------]
  8. @xL3gi0n Hackers
  9. #https://www.facebook.com/xL3gi0nhackers.gov
  10. ##We are xL3gi0n.You are nothing. You will fall in the hand's of our fellow brothers and sisters. We unite as one but fight as many.
  11. #Three.edu database hacked.  One .gov database hacked
  12. [-------------------------------------]
  13. #First up .edu site ahhaha
  14. #Target : http://student.eepis-its.edu
  15. [-------------------------------------]
  16. -- phpMyAdmin SQL Dump
  17. -- version 3.3.9
  18. -- http://www.phpmyadmin.net
  19. --
  20. -- Host: localhost
  21. -- Generation Time: Jan 15, 2012 at 04:10
  22. -- Server version: 5.5.8
  23. -- PHP Version: 5.3.5
  24.  
  25. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  26.  
  27.  
  28. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  29. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  30. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  31. /*!40101 SET NAMES utf8 */;
  32.  
  33. --
  34. -- Database: `userband`
  35. --
  36.  
  37. -- --------------------------------------------------------
  38.  
  39. --
  40. -- Table structure for table `admin`
  41. --
  42.  
  43. CREATE TABLE IF NOT EXISTS `admin` (
  44.  `id_admin` int(20) NOT NULL AUTO_INCREMENT,
  45.  `useradmin` varchar(20) NOT NULL,
  46.  `pass` varchar(50) NOT NULL,
  47.  PRIMARY KEY (`id_admin`),
  48.  KEY `useradmin` (`useradmin`)
  49. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  50.  
  51. --
  52. -- Dumping data for table `admin`
  53. --
  54.  
  55. INSERT INTO `admin` (`id_admin`, `useradmin`, `pass`) VALUES
  56. (1, 'admin', 'fa246d0262c3925617b0c72bb20eeb1d');
  57.  
  58. -- --------------------------------------------------------
  59.  
  60. --
  61. -- Table structure for table `userid`
  62. --
  63.  
  64. CREATE TABLE IF NOT EXISTS `userid` (
  65.  `id_username` int(20) NOT NULL AUTO_INCREMENT,
  66.  `username` char(20) NOT NULL,
  67.  `password` char(50) NOT NULL,
  68.  `email` char(20) NOT NULL,
  69.  `nama` char(20) NOT NULL,
  70.  `rating` int(10) NOT NULL,
  71.  `avatar` int(1) NOT NULL,
  72.  PRIMARY KEY (`id_username`),
  73.  KEY `username` (`username`)
  74. ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
  75.  
  76. --
  77. -- Dumping data for table `userid`
  78. --
  79.  
  80. INSERT INTO `userid` (`id_username`, `username`, `password`, `email`, `nama`, `rating`, `avatar`) VALUES
  81. (4, 'tandon', 'b59c67bf196a4758191e42f76670ceba', 'tandon@yahoo.com', 'rangga', 10, 1),
  82. (5, 'lia', '934b535800b1cba8f96a5d72f72f1611', 'lia@yahoo.com', 'lia zahiroh', 8, 2),
  83. (6, 'maznanda', '2be9bd7a3434f7038ca27d1918de58bd', 'suko@yahoo.com', 'suko', 0, 3),
  84. (7, 'maniak', 'dbc4d84bfcfe2284ba11beffb853a8c4', 'tangofox@yahoo.com', 'alfino', 0, 4),
  85. (8, 'batak', '6074c6aa3488f3c2dddff2a7ca821aab', 'batak@yahoo.com', 'ardi', 0, 3),
  86. (9, 'maseka', 'b59c67bf196a4758191e42f76670ceba', 'eka@yahoo.com', 'eka', 0, 1),
  87. (10, 'putri', 'b59c67bf196a4758191e42f76670ceba', 'rioskomputama@yahoo.', 'cici', 0, 2);
  88. [-------------------------------------]
  89. #Second target .edu site again !
  90. #Target : http://www.mscs.mu.edu
  91. [-------------------------------------]
  92. DROP TABLE MEMBER CASCADE CONSTRAINTS;
  93. CREATE TABLE MEMBER (
  94.  MID      varchar2(20) primary key,
  95.  Email    varchar2(40) not null,
  96.  FName    varchar2(30) not null,
  97.  LName    varchar2(30) not null,
  98.  Password varchar2(20) not null,
  99.  Address  varchar2(50) not null,
  100.  Phone    varchar2(25)
  101. );
  102.  
  103. DROP TABLE BUYER CASCADE CONSTRAINTS;
  104. CREATE TABLE BUYER (
  105.  MID         varchar2(20) PRIMARY KEY REFERENCES MEMBER(MID) ON DELETE CASCADE,
  106.  ShipAddress varchar2(50) not null
  107. );
  108.  
  109. DROP TABLE SELLER CASCADE CONSTRAINTS;
  110. CREATE TABLE SELLER (
  111.  MID        varchar2(20) primary key REFERENCES MEMBER(MID) ON DELETE CASCADE,
  112.  AccountNo  varchar2(20) not null,
  113.  RountingNo varchar2(20) not null
  114. );
  115.  
  116. DROP TABLE CATEGORY CASCADE CONSTRAINTS;
  117. CREATE TABLE CATEGORY (
  118.  CatName VARCHAR2(40) PRIMARY KEY,
  119.  SubCat  VARCHAR2(40) REFERENCES CATEGORY(CatName)
  120. );
  121.  
  122. DROP TABLE ITEM CASCADE CONSTRAINTS;
  123. CREATE TABLE ITEM (
  124.  ItemNo      integer primary key,
  125.  Title       varchar2(100) not null,
  126.  Description varchar2(4000) not null,
  127.  StartBid    decimal not null CHECK(StartBid > 0),
  128.  BidIncr     decimal not null CHECK(BidIncr > 0),
  129.  StartDate   date not null,
  130.  EndDate     date not null,
  131.  CatName     varchar2(40) references CATEGORY(CatName) ON DELETE SET NULL,
  132.  SellerID    varchar2(20) not null references SELLER(MID),
  133.  WinnerID    varchar2(20) references BUYER(MID),
  134.  BRating     integer CHECK(BRating >= 1 and BRating <= 10),
  135.  BComment    varchar2(250),
  136.  SRating     integer CHECK(SRating >= 1 and SRating <= 10),
  137.  SComment    varchar2(250),
  138.  CONSTRAINT EndDate_After_StartDate CHECK (EndDate > StartDate)
  139. );
  140.  
  141. DROP TABLE BID CASCADE CONSTRAINTS;
  142. CREATE TABLE BID (
  143.  MID      varchar2(20) references BUYER(MID),
  144.  ItemNo   integer references ITEM(ItemNo) ON DELETE CASCADE,
  145.  BidTime  date,
  146.  BidPrice decimal not null CHECK(BidPrice > 0),
  147.  CONSTRAINT Bid_PK PRIMARY KEY (MID, ItemNo, BidTime)
  148. );
  149.  
  150. DROP SEQUENCE ItemNo_Seq;
  151. CREATE SEQUENCE ItemNo_Seq
  152. start with 1
  153. increment by 1;
  154.  
  155. -- INSERTING into MEMBER
  156. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('1','casillas@realmadrid.com','Iker','Casillas','espanol','1 First Street, Bernabeu, MA, 93136','111-111-1111');
  157. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('2','salgado@realmadrid.com','Michel','Salgado','espanol','2 Second Street, Bernabeu, MA, 93136','111-111-1111');
  158. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('3','pepe@realmadrid.com','Kleper','Laveran','portugues','3 Third Street, Bernabeu, MA, 93136','111-111-1111');
  159. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('4','ramos@realmadrid.com','Sergio','Ramos','espanol','4 Fourth Street, Bernabeu, MA, 93136','111-111-1111');
  160. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('5','cannavaro@realmadrid.com','Fabio','Cannavaro','italiano','5 Fifth Street, Bernabeu, MA, 93136','111-111-1111');
  161. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('6','diarra@realmadrid.com','Mahamadou','Diarra','mali','6 Sixth Street, Bernabeu, MA, 93136','111-111-1111');
  162. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('7','raul@realmadrid.com','Raul','Gonzalez','espanol','7 Seventh Street, Bernabeu, MA, 93136','111-111-1111');
  163. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('8','gago@realmadrid.com','Fernando','Gago','argentino','8 Eighth Street, Bernabeu, MA, 93136','111-111-1111');
  164. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('9','saviola@realmadrid.com','Javier','Saviola','argentino','9 Ninth Street, Bernabeu, MA, 93136','111-111-1111');
  165. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('10','sneijder@realmadrid.com','Wesley','Sneijder','holandes','10 Tenth Street, Bernabeu, MA, 93136','111-111-1111');
  166. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('11','robben@realmadrid.com','Arjen','Robben','holandes','11 Eleventh Street, Bernabeu, MA, 93136','111-111-1111');
  167. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('12','marcelo@realmadrid.com','Marcelo','Vieira','brasileno','12 Twelfth Street, Bernabeu, MA, 93136','111-111-1111');
  168. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('13','codina@realmadrid.com','Jordi','Codina','espanol','13 Thirteenth Street, Bernabeu, MA, 93136','111-111-1111');
  169. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('14','guti@realmadrid.com','Jose Maria','Gutierrez','espanol','14 Fourteenth Street, Bernabeu, MA, 93136','111-111-1111');
  170. Insert into MEMBER (MID,EMAIL,FNAME,LNAME,PASSWORD,ADDRESS,PHONE) values ('15','drenthe@realmadrid.com','Royston','Drenthe','holandes','15 Fifteenth Street, Bernabeu, MA, 93136','111-111-1111');
  171.  
  172.  
  173. -- INSERTING into BUYER
  174. Insert into BUYER (MID,SHIPADDRESS) values ('1','1 First Street, Bernabeu, MA, 93136');
  175. Insert into BUYER (MID,SHIPADDRESS) values ('2','2 Second Street, Bernabeu, MA, 93136');
  176. Insert into BUYER (MID,SHIPADDRESS) values ('3','3 Third Street, Bernabeu, MA, 93136');
  177. Insert into BUYER (MID,SHIPADDRESS) values ('4','4 Fourth Street, Bernabeu, MA, 93136');
  178. Insert into BUYER (MID,SHIPADDRESS) values ('5','5 Fifth Street, Bernabeu, MA, 93136');
  179. Insert into BUYER (MID,SHIPADDRESS) values ('6','6 Sixth Street, Bernabeu, MA, 93136');
  180. Insert into BUYER (MID,SHIPADDRESS) values ('7','7 Seventh Street, Bernabeu, MA, 93136');
  181. Insert into BUYER (MID,SHIPADDRESS) values ('8','8 Eighth Street, Bernabeu, MA, 93136');
  182. Insert into BUYER (MID,SHIPADDRESS) values ('9','9 Ninth Street, Bernabeu, MA, 93136');
  183. Insert into BUYER (MID,SHIPADDRESS) values ('10','10 Tenth Street, Bernabeu, MA, 93136');
  184. Insert into BUYER (MID,SHIPADDRESS) values ('11','11 Eleventh Street, Bernabeu, MA, 93136');
  185.  
  186. -- INSERTING into SELLER
  187. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('12','1234567892','10000001');
  188. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('13','1234567893','10000001');
  189. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('14','1234567894','10000001');
  190. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('15','1234567895','10000001');
  191. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('1','1234567891','10000001');
  192. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('2','1234567892','10000001');
  193. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('3','12345678913','10000001');
  194. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('4','12345678914','10000001');
  195. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('5','12345678915','10000001');
  196. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('6','12345678916','10000001');
  197. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('7','12345678917','10000001');
  198. Insert into SELLER (MID,ACCOUNTNO,ROUNTINGNO) values ('8','12345678918','10000001');
  199.  
  200.  
  201. -- INSERTING into CATEGORY
  202. Insert into CATEGORY (CATNAME,SubCat) values ('Computer',null);
  203. Insert into CATEGORY (CATNAME,SubCat) values ('Hardware','Computer');
  204. Insert into CATEGORY (CATNAME,SubCat) values ('Software','Computer');
  205. Insert into CATEGORY (CATNAME,SubCat) values ('Accessories','Computer');
  206. Insert into CATEGORY (CATNAME,SubCat) values ('Network','Computer');
  207. Insert into CATEGORY (CATNAME,SubCat) values ('Memory','Hardware');
  208. Insert into CATEGORY (CATNAME,SubCat) values ('Hard Drive','Hardware');
  209. Insert into CATEGORY (CATNAME,SubCat) values ('Games','Software');
  210. Insert into CATEGORY (CATNAME,SubCat) values ('OS','Software');
  211. Insert into CATEGORY (CATNAME,SubCat) values ('Applications','Software');
  212. Insert into CATEGORY (CATNAME,SubCat) values ('Random','Accessories');
  213. Insert into CATEGORY (CATNAME,SubCat) values ('Power and Batteries','Accessories');
  214. Insert into CATEGORY (CATNAME,SubCat) values ('Routing','Network');
  215.  
  216.  
  217. -- INSERTING into ITEM
  218. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'Chassis','Invisible',9999,100,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Random','3','3',null,null,null,null);
  219. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'WRT54G','For XINU happiness',50,1,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Routing','2','3',null,null,null,null);
  220. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'Photoshop CS3','Because expensive doesnt cut it',200,25,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Applications','12','3',null,null,null,null);
  221. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'Bloons Tower Defense 3','Because 2 just isnt good enough for 2011!',5,1,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Games','6',null,null,null,null,null);
  222. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'DDR2 SDRAM DDR2 800','Do it!',60,5,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Memory','6',null,null,null,null,null);
  223. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'Mouse ball','For use with old mouses',2,1,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Random','3',null,null,null,null,null);
  224. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'Blu-Ray drive','Movie time',600,100,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Hardware','12','2',10,'Looks great!',9,'This was expensive! and hard to sell');
  225. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'Norton Antivirus','Security?',90,5,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Applications','13','2',10,'Fast',9,'Annoying questions');
  226. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'Super Battery','Security?',90,5,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Power and Batteries','14','2',10,'Fast',9,'you know it');
  227. Insert into ITEM (ITEMNO,TITLE,DESCRIPTION,STARTBID,BIDINCR,STARTDATE,ENDDATE,CATNAME,SELLERID,WINNERID,BRATING,BCOMMENT,SRATING,SCOMMENT) values (ItemNo_Seq.nextval,'L337 HaX0r Suite','Security who?',90,5,to_timestamp('01-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),to_timestamp('01-JAN-12','DD-MON-RR HH.MI.SSXFF AM'),'Applications','15','8',10,'not as good as my own',9,'I just stole his credit card');
  228.  
  229. --  INSERTING into BID
  230. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',2,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),102);
  231. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('1',5,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),102);
  232. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',7,to_timestamp('26-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),104);
  233. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',5,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),102);
  234. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',4,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),1000);
  235. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',3,to_timestamp('10-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),100);
  236. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',6,to_timestamp('11-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),200);
  237. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',8,to_timestamp('12-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),250);
  238. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',9,to_timestamp('13-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),300);
  239. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('2',10,to_timestamp('20-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),1000);
  240. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('1',2,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),100);
  241. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('3',2,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),102);
  242. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('4',2,to_timestamp('01-NOV-11','DD-MON-RR HH.MI.SSXFF AM'),103);
  243. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('5',2,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),104);
  244. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('6',2,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),105);
  245. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('1',3,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),101);
  246. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('1',7,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),103);
  247. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('8',2,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),9999);
  248. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('9',3,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),9999);
  249. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('7',4,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),9999);
  250. Insert into BID (MID,ITEMNO,BIDTIME,BIDPRICE) values ('8',5,to_timestamp('25-OCT-11','DD-MON-RR HH.MI.SSXFF AM'),9999);
  251.  
  252. commit;
  253. [-------------------------------------]
  254. #Third target .edu site.... !
  255. #Target : http://www.cs.pitt.edu
  256. [-------------------------------------]
  257. DROP TABLE ADMIN;
  258. DROP TABLE CIRCUL;
  259. DROP TABLE RESERVATION;
  260. DROP TABLE USERS;
  261. DROP TABLE LOCATION;
  262. DROP TABLE COPY;
  263. DROP TABLE MARCBOOKS;
  264. DROP TABLE BOOKS;
  265.  
  266.  
  267.  
  268. CREATE TABLE BOOKS (
  269.    LKEY varchar2(16),
  270.    X001 varchar2(16),
  271.    X010 varchar2(16),
  272.    X01X varchar2(32),
  273.    ISBN varchar2(50) PRIMARY KEY,
  274.    X020 varchar2(200),
  275.    X049 varchar2(4),
  276.    X050 varchar2(24),
  277.    X082 varchar2(24),
  278.    X092 varchar2(40),
  279.    AUTHOR varchar2(100),
  280.    X1XX varchar2(500),
  281.    TITLE varchar2(500),
  282.    X245 varchar2(500),
  283.    X250 varchar2(40),
  284.    X260 varchar2(500),
  285.    X300 varchar2(80),
  286.    X500 varchar2(500),
  287.    X504 varchar2(120),
  288.    X505 varchar2(1500),
  289.    X520 varchar2(500),
  290.    X590 varchar2(120),
  291.    X6XX varchar2(500),
  292.    X700 varchar2(500),
  293.    X710 varchar2(500),
  294.    X740 varchar2(500),
  295.    X8XX varchar2(500),
  296.    PRICE NUMBER(10,2),
  297.    DATA_IN DATE,
  298.    YEAR_PUB VARCHAR2(4),
  299.    PAGE  VARCHAR2(4),
  300.    COMMENTS VARCHAR2(500),
  301.    STATUS VARCHAR2(1),
  302.    FLAG  NUMBER,
  303.    NO_COPY NUMBER
  304. );
  305.  
  306. CREATE TABLE MARCBOOKS (
  307.    X001 varchar2(16),
  308.    X010 varchar2(16),
  309.    X01X varchar2(32),
  310.    ISBN varchar2(50) REFERENCES BOOKS(ISBN),
  311.    X020 varchar2(200),
  312.    X049 varchar2(4),
  313.    X050 varchar2(24),
  314.    X082 varchar2(24),
  315.    X092 varchar2(40),
  316.    X1XX varchar2(500),
  317.    TITLE varchar2(500),
  318.    X245 varchar2(500),
  319.    X250 varchar2(40),
  320.    X260 varchar2(500),
  321.    X300 varchar2(80),
  322.    X500 varchar2(500),
  323.    X504 varchar2(120),
  324.    X505 varchar2(1500),
  325.    X520 varchar2(500),
  326.    X590 varchar2(120),
  327.    X6XX varchar2(500),
  328.    X700 varchar2(500),
  329.    X710 varchar2(500),
  330.    X740 varchar2(500),
  331.    X8XX varchar2(500),
  332.    PRIMARY KEY(ISBN)
  333. );
  334.  
  335. CREATE TABLE USERS
  336. (
  337.    USER_ID VARCHAR2(14) PRIMARY KEY,
  338.    SSN VARCHAR2(9),
  339.    DATE_OPEN  DATE,
  340.    DATE_END   DATE,
  341.    MR_MS  VARCHAR2(2),
  342.    FIRSTNAME  VARCHAR2(16),
  343.    MI  VARCHAR2(2),
  344.    LASTNAME  VARCHAR2(16),
  345.    TITLE  VARCHAR2(32),
  346.    COMPANY  VARCHAR2(32),
  347.    STREET1  VARCHAR2(32),
  348.    STREET2  VARCHAR2(32),
  349.    CITY     VARCHAR2(16),
  350.    STATE    VARCHAR2(2),
  351.    ZIP      VARCHAR2(90),
  352.    COUNTRY  VARCHAR2(32),
  353.    CATALOG  VARCHAR2(1),
  354.    H_TEL    VARCHAR2(10),
  355.    B_TEL    VARCHAR2(16),
  356.    FAX      VARCHAR2(10),
  357.    PAGER    VARCHAR2(10),
  358.    LOAN_PD  NUMBER(10, 2),
  359.    E_MAIL   VARCHAR2(80),
  360.    NOTE     VARCHAR2(500)
  361. );
  362.  
  363.  
  364. CREATE TABLE RESERVATION
  365. (
  366.    ISBN VARCHAR2(50) REFERENCES BOOKS(ISBN),
  367.    USER_ID VARCHAR2(14) REFERENCES USERS(USER_ID),
  368.    LOG_DATE DATE,
  369.    REMARKS VARCHAR2(200),
  370.    PRIMARY KEY(ISBN, USER_ID)
  371. );
  372.  
  373. CREATE TABLE COPY
  374. (
  375.    BOOK_ID VARCHAR2(14) PRIMARY KEY,
  376.    ISBN    VARCHAR2(50) REFERENCES BOOKS(ISBN),
  377.    COPY_ID NUMBER,
  378.    ONLOAN  VARCHAR2(20)
  379. );
  380.  
  381.  
  382. CREATE TABLE LOCATION
  383. (
  384.    BOOK_ID  VARCHAR2(14) REFERENCES COPY(BOOK_ID),
  385.    BUILDING VARCHAR2(10),
  386.    ROOM     VARCHAR2(10),
  387.    SHELF    VARCHAR2(10),
  388.    PRIMARY KEY ( BOOK_ID)
  389. );
  390.  
  391.  
  392.  
  393. CREATE TABLE CIRCUL
  394. (
  395.    USER_ID    VARCHAR2(14) REFERENCES USERS(USER_ID),
  396.    BOOK_ID    VARCHAR2(14) REFERENCES COPY(BOOK_ID),
  397.    DATE_OUT   DATE,
  398.    DATE_DUE   DATE,
  399.    DATE_BACK  DATE,
  400.    DATE_RENEW DATE,
  401.    RETURNED   VARCHAR2(1),
  402.    FINE       NUMBER(10,2),
  403.    PRIMARY KEY(USER_ID, BOOK_ID)
  404. );
  405.  
  406. CREATE TABLE ADMIN
  407. (
  408.    FIRSTNAME  VARCHAR2(16),
  409.    LASTNAME   VARCHAR2(16),
  410.    PASSWORD   VARCHAR2(16),
  411.    STATUS     VARCHAR2(16),
  412.    PRIMARY KEY(FIRSTNAME,LASTNAME,PASSWORD)
  413. );
  414.  
  415. insert into users values('123456','123456789',to_date('01/01/1997','mm/dd/yyyy'),'','mr','bob','k','smith','','','12 broadway','','chicago','il','60000','usa','y','5551234','','','',0,'','');
  416. insert into users values('456789','123449999',to_date('11/01/1998','mm/dd/yyyy'),'','ms','jane','k','carter','','','134 main st.','','skokie','il','60076','usa','y','6791234','','','',0,'jane@nomail.com','');
  417. insert into users values('999999','444556666',to_date('12/01/1999','mm/dd/yyyy'),'','mr','jack','a','tripper','','','999 Prospect st.','','evanston','il','60011','usa','n','6796676','','','',10,'jack@yaha.com','');
  418.  
  419. commit;
  420. [-------------------------------------]
  421. #Fourth target .gov site.... -.-
  422. #Target : https://ncisvn.nci.nih.gov/
  423. [-------------------------------------]
  424. -- The following entries creates a super admin application incase you decide
  425. -- to use this database to run UPT also. In that case you need to provide
  426. -- the project login id and name for the super admin.
  427. -- However in incase you are using this database just to host the application's
  428. -- authorization schema, these enteries are not used and hence they can be left as
  429. -- it is.
  430. --
  431. -- Password is changeme
  432. INSERT INTO CSM_APPLICATION(
  433. APPLICATION_NAME, APPLICATION_DESCRIPTION, DECLARATIVE_FLAG, ACTIVE_FLAG,UPDATE_DATE)
  434. VALUES ( 'csmupt', 'CSM UPT Super Admin Application', '0','0',current_date)
  435. ;
  436. INSERT INTO CSM_USER(
  437. LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD,UPDATE_DATE)
  438. VALUES ( 'csmadmin', 'CSM', 'Admin','zJPWCwDeSgG8j2uyHEABIQ==',current_date)
  439. ;
  440. INSERT INTO CSM_PROTECTION_ELEMENT(PROTECTION_ELEMENT_NAME, PROTECTION_ELEMENT_DESCRIPTION, OBJECT_ID, APPLICATION_ID,UPDATE_DATE)
  441. VALUES ('csmupt', 'CSM UPT Super Admin Application Protection Element', 'csmupt', 1,current_date)
  442. ;
  443. INSERT INTO CSM_USER_PE(
  444. PROTECTION_ELEMENT_ID, USER_ID, UPDATE_DATE)
  445. VALUES ( 1,1,current_date)
  446. ;
  447. COMMIT
  448. ;
  449. --  
  450. --  The following entry is for your application.
  451. --  Replace <<application_context_name>> with your application name.
  452. --
  453. --  password is ctods
  454. INSERT INTO CSM_APPLICATION(
  455. APPLICATION_NAME, APPLICATION_DESCRIPTION, DECLARATIVE_FLAG, ACTIVE_FLAG,UPDATE_DATE,
  456. DATABASE_URL, DATABASE_USER_NAME,DATABASE_PASSWORD, DATABASE_DIALECT, DATABASE_DRIVER)
  457. VALUES ('pa','pa','0','0',current_date, 'jdbc:postgresql://localhost:5432/ctods_pa', 'pauser',
  458. 'BmJz1l2ghRU=', 'org.hibernate.dialect.PostgreSQLDialect', 'org.postgresql.Driver' )
  459. ;
  460. INSERT INTO CSM_PROTECTION_ELEMENT(
  461. PROTECTION_ELEMENT_NAME, PROTECTION_ELEMENT_DESCRIPTION, OBJECT_ID, APPLICATION_ID,UPDATE_DATE)
  462. VALUES ( 'pa','PA Admin Application Protection Element','pa',1,current_date)
  463. ;
  464. COMMIT
  465. ;
  466. --
  467. --  The following entries are Common Set of Privileges
  468. --
  469. INSERT INTO CSM_PRIVILEGE(PRIVILEGE_NAME, PRIVILEGE_DESCRIPTION,UPDATE_DATE)
  470. VALUES('CREATE','This privilege grants permission to a user to create an entity. This entity can be an object, a database entry, or a resource such as a network connection', current_date)
  471. ;
  472. INSERT INTO CSM_PRIVILEGE(PRIVILEGE_NAME, PRIVILEGE_DESCRIPTION,UPDATE_DATE)
  473. VALUES('ACCESS','This privilege allows a user to access a particular resource.  Examples of resources include a network or database connection, socket, module of the application, or even the application itself', current_date)
  474. ;
  475. INSERT INTO CSM_PRIVILEGE(PRIVILEGE_NAME, PRIVILEGE_DESCRIPTION,UPDATE_DATE)
  476. VALUES('READ','This privilege permits the user to read data from a file, URL, database, an object, etc. This can be used at an entity level signifying that the user is allowed to read data about a particular entry', current_date)
  477. ;
  478. INSERT INTO CSM_PRIVILEGE(PRIVILEGE_NAME, PRIVILEGE_DESCRIPTION,UPDATE_DATE)
  479. VALUES('WRITE','This privilege allows a user to write data to a file, URL, database, an object, etc. This can be used at an entity level signifying that the user is allowed to write data about a particular entity', current_date)
  480. ;
  481. INSERT INTO CSM_PRIVILEGE(PRIVILEGE_NAME, PRIVILEGE_DESCRIPTION,UPDATE_DATE)
  482. VALUES('UPDATE','This privilege grants permission at an entity level and signifies that the user is allowed to update data for a particular entity. Entities may include an object, object attribute, database row etc', current_date)
  483. ;
  484. INSERT INTO CSM_PRIVILEGE(PRIVILEGE_NAME, PRIVILEGE_DESCRIPTION,UPDATE_DATE)
  485. VALUES('DELETE','This privilege permits a user to delete a logical entity. This entity can be an object, a database entry, a resource such as a network connection, etc', current_date)
  486. ;
  487. INSERT INTO CSM_PRIVILEGE(PRIVILEGE_NAME, PRIVILEGE_DESCRIPTION,UPDATE_DATE)
  488. VALUES('EXECUTE','This privilege allows a user to execute a particular resource. The resource can be a method, function, behavior of the application, URL, button etc', current_date)
  489. ;
  490. -- Password is pass
  491. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('abstractor', 'Test', 'Abstractor','BtM2GNbiAxg=',current_date)
  492. ;
  493. INSERT INTO CSM_USER_PE(PROTECTION_ELEMENT_ID, USER_ID, UPDATE_DATE) VALUES (2, 2,current_date)
  494. ;
  495. INSERT INTO CSM_GROUP (GROUP_NAME, GROUP_DESC, APPLICATION_ID, UPDATE_DATE) VALUES ('Abstractor', 'Abstractor group - security role', (select application_id from csm_application where application_name = 'pa'),current_date)
  496. ;
  497. INSERT INTO CSM_GROUP (GROUP_NAME, GROUP_DESC, APPLICATION_ID, UPDATE_DATE) VALUES ('Submitter', 'Trial Submitter group - security role', (select application_id from csm_application where application_name = 'pa'),current_date)
  498. ;
  499. INSERT INTO CSM_GROUP (GROUP_NAME, GROUP_DESC, APPLICATION_ID, UPDATE_DATE) VALUES ('RegAdmin', 'Registry Administrator - security role', (select application_id from csm_application where application_name = 'pa'),current_date)
  500. ;
  501. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES (2, 1)
  502. ;
  503. -- Password is pass
  504. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('subscriber', 'Test', 'Subscriber','BtM2GNbiAxg=',current_date)
  505. ;
  506. INSERT INTO CSM_USER_PE(PROTECTION_ELEMENT_ID, USER_ID, UPDATE_DATE) VALUES ((select protection_element_id from csm_protection_element where protection_element_name = 'pa'), (select user_id from csm_user where login_name = 'subscriber'),current_date)
  507. ;
  508. INSERT INTO CSM_GROUP (GROUP_NAME, GROUP_DESC, APPLICATION_ID, UPDATE_DATE) VALUES ('Subscriber', 'Topic Subscriber group - security role', (select application_id from csm_application where application_name = 'pa'),current_date)
  509. ;
  510. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = 'subscriber'), (select group_id from csm_group where group_name = 'Subscriber'))
  511. ;
  512. -- Password is pass
  513. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('publisher', 'Test', 'Publisher','BtM2GNbiAxg=',current_date)
  514. ;
  515. INSERT INTO CSM_USER_PE(PROTECTION_ELEMENT_ID, USER_ID, UPDATE_DATE) VALUES ((select protection_element_id from csm_protection_element where protection_element_name = 'pa'), (select user_id from csm_user where login_name = 'publisher'),current_date)
  516. ;
  517. INSERT INTO CSM_GROUP (GROUP_NAME, GROUP_DESC, APPLICATION_ID, UPDATE_DATE) VALUES ('Publisher', 'Topic Publisher group - security role', (select application_id from csm_application where application_name = 'pa'),current_date)
  518. ;
  519. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = 'publisher'), (select group_id from csm_group where group_name = 'Publisher'))
  520. ;
  521. -- Password is pass
  522. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('ejbclient', 'Test', 'EJBClient','BtM2GNbiAxg=',current_date)
  523. ;
  524. INSERT INTO CSM_USER_PE(PROTECTION_ELEMENT_ID, USER_ID, UPDATE_DATE) VALUES ((select protection_element_id from csm_protection_element where protection_element_name = 'pa'), (select user_id from csm_user where login_name = 'ejbclient'),current_date)
  525. ;
  526. INSERT INTO CSM_GROUP (GROUP_NAME, GROUP_DESC, APPLICATION_ID, UPDATE_DATE) VALUES ('client', 'remote client group - security role', (select application_id from csm_application where application_name = 'pa'),current_date)
  527. ;
  528. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = 'ejbclient'), (select group_id from csm_group where group_name = 'client'))
  529. ;
  530. -- password is pass
  531. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('firebird-nci', 'Firebird', 'Nci','BtM2GNbiAxg=',current_date)
  532. ;
  533. INSERT INTO CSM_USER_PE(PROTECTION_ELEMENT_ID, USER_ID, UPDATE_DATE) VALUES ((select protection_element_id from csm_protection_element where protection_element_name = 'pa'), (select user_id from csm_user where login_name = 'firebird-nci'),current_date)
  534. ;
  535. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = 'firebird-nci'), (select group_id from csm_group where group_name = 'client'))
  536. ;
  537. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = 'firebird-nci'), (select group_id from csm_group where group_name = 'Subscriber'))
  538. ;
  539.  
  540. -- Password is pass
  541. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('submitter', 'Test', 'Submitter','BtM2GNbiAxg=',current_date)
  542. ;
  543. INSERT INTO CSM_USER_PE(PROTECTION_ELEMENT_ID, USER_ID, UPDATE_DATE) VALUES ((select protection_element_id from csm_protection_element where protection_element_name = 'pa'), (select user_id from csm_user where login_name = 'submitter'),current_date)
  544. ;
  545. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = 'submitter'), (select group_id from csm_group where group_name = 'Submitter'))
  546. ;
  547. -- grid user for abstractor
  548. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=abstractor', 'Test', 'PA Abstractor','',current_date)
  549. ;
  550. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = '/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=abstractor'), (select group_id from csm_group where group_name = 'Abstractor'))
  551. ;
  552. -- grid user for submitter
  553. INSERT INTO CSM_USER(LOGIN_NAME, FIRST_NAME, LAST_NAME, PASSWORD, UPDATE_DATE) VALUES ('/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=submitter', 'Test', 'PA Submitter','',current_date)
  554. ;
  555. INSERT INTO CSM_USER_GROUP (USER_ID, GROUP_ID) VALUES ((select user_id from csm_user where login_name = '/O=caBIG/OU=caGrid/OU=Training/OU=Dorian/CN=submitter'), (select group_id from csm_group where group_name = 'Submitter'))
  556. ;
  557.  
  558. --Remote Groups for PA in the dev environment.
  559. insert into CSM_REMOTE_GROUP (GROUP_ID, APPLICATION_ID, GRID_GROUPER_URL, GRID_GROUPER_GROUP_NAME) values ((select group_id from csm_group where group_name = 'Abstractor'), (select application_id from csm_application where application_name = 'pa'), 'https://grouper.training.cagrid.org:8443/wsrf/services/cagrid/GridGrouper', 'COPPA:PA:Abstractor');
  560. insert into CSM_REMOTE_GROUP (GROUP_ID, APPLICATION_ID, GRID_GROUPER_URL, GRID_GROUPER_GROUP_NAME) values ((select group_id from csm_group where group_name = 'Submitter'), (select application_id from csm_application where application_name = 'pa'), 'https://grouper.training.cagrid.org:8443/wsrf/services/cagrid/GridGrouper', 'COPPA:PA:Submitter');
  561. insert into CSM_REMOTE_GROUP (GROUP_ID, APPLICATION_ID, GRID_GROUPER_URL, GRID_GROUPER_GROUP_NAME) values ((select group_id from csm_group where group_name = 'RegAdmin'), (select application_id from csm_application where application_name = 'pa'), 'https://grouper.training.cagrid.org:8443/wsrf/services/cagrid/GridGrouper', 'COPPA:PA:RegAdmin');
  562. --The below commands are commented out due to the fact that they are added later in the upgrade process. If you need to add these remote group mappings, do so manually.
  563. --insert into CSM_REMOTE_GROUP (GROUP_ID, APPLICATION_ID, GRID_GROUPER_URL, GRID_GROUPER_GROUP_NAME) values ((select group_id from csm_group where group_name = 'gridClient'), (select application_id from csm_application where application_name = 'pa'), 'https://grouper.training.cagrid.org:8443/wsrf/services/cagrid/GridGrouper', 'COPPA:PA:GridClient');
  564. --insert into CSM_REMOTE_GROUP (GROUP_ID, APPLICATION_ID, GRID_GROUPER_URL, GRID_GROUPER_GROUP_NAME) values ((select group_id from csm_group where group_name = 'Outcomes'), (select application_id from csm_application where application_name = 'pa'), 'https://grouper.training.cagrid.org:8443/wsrf/services/cagrid/GridGrouper', 'COPPA:PA:Outcomes');
  565. COMMIT
  566. ;
  567. [-------------------------------------]
create a new version of this paste RAW Paste Data