File: issue197074_03.php

package info (click to toggle)
netbeans 7.0.1%2Bdfsg1-5
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 625,684 kB
  • sloc: java: 4,186,825; xml: 465,705; php: 38,485; cpp: 19,252; ansic: 13,667; jsp: 10,961; sh: 9,710; sql: 1,469; makefile: 991; haskell: 698; objc: 288; perl: 265; fortran: 262; yacc: 30; awk: 17; lex: 11; asm: 4
file content (12 lines) | stat: -rw-r--r-- 622 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
<?php
$db = new PDO("pgsql:dbname=geodata;host=132.230.21.8", "postgres", "postgres");
$sqlQuery = 'CREATE TABLE items (id_item integer NOT NULL, handle character varying(255) NOT NULL';
$sqlQuery .= 'handle_source character varying(255) NOT NULL,';
$sqlQuery .= 'handle_citation character varying(255) NOT NULL,';
$sqlQuery .=                                            'CONSTRAINT items_pkey PRIMARY KEY (id_item),';
$sqlQuery .=                                            'CONSTRAINT items_handle_key UNIQUE (handle)';
$sqlQuery .=                                            ')';'

$db->query($sqlQuery);
$db = null;
?>