nopaste
HomeAll pastesPopular pastesRecent pastes

Public paste
DB
By: Xmoo | Date: Jan 28 2009 08:02 | Format: PHP | Expires: never | Size: 1.75 KB | Hits: 839
Edit & repaste | raw paste | Request removal

  1. <?php
  2. include("config.php");
  3.  
  4. //Creating tabel VerbruikArtikelen
  5. mysql_query("CREATE TABLE VerbruikArtikelen (
  6.  VerbruikID int(11) NOT NULL auto_increment,
  7.  DeelnemerID varchar(11) NOT NULL,
  8.  ArtikelID varchar(11) NOT NULL,
  9.  datum varchar(255) NOT NULL,
  10.  tijd varchar(255) NOT NULL,
  11.  aantal varchar(255) NOT NULL,
  12.  PRIMARY KEY  (VerbruikID)
  13. )") or die('<b><font color=red>Couldnt make table!</font></b>');
  14.         echo "<font color=green>Table -VerbruikArtikelen- has been succesfully added to the database!<br></font>";
  15.  
  16. //Creating tabel Verbruikapparatuur
  17. mysql_query("CREATE TABLE Verbruikapparatuur (
  18.  VerbruikaID int(11) NOT NULL auto_increment,
  19.  DeelnemerID varchar(11) NOT NULL,
  20.  ApparatuurID varchar(11) NOT NULL,
  21.  vdatum varchar(255) NOT NULL,
  22.  vtijd varchar(255) NOT NULL,
  23.  aantal varchar(255) NOT NULL,
  24.  tdatum varchar(255) NOT NULL,
  25.  ttijd varchar(255) NOT NULL,
  26.  PRIMARY KEY  (VerbruikaID)
  27. )") or die('<b><font color=red>Couldnt make table!</font></b>');
  28.         echo "<font color=green>Table -Verbruikapparatuur- has been succesfully added to the database!<br></font>";    
  29.                                          
  30.        
  31. //Creating tabel Aanwezigheid
  32. mysql_query("CREATE TABLE Aanwezigheid (
  33.  AanwezigheidID int(11) NOT NULL auto_increment,
  34.  DeelnemerID varchar(11) NOT NULL,
  35.  vdatum varchar(255) NOT NULL,
  36.  vtijd varchar(255) NOT NULL,
  37.  tdatum varchar(255) NOT NULL,
  38.  ttijd varchar(255) NOT NULL,
  39.  PRIMARY KEY  (AanwezigheidID)
  40. )") or die('<b><font color=red>Couldnt make table!</font></b>');
  41.         echo "<font color=green>Table -Aanwezigheid- has been succesfully added to the database!<br></font>";                                                          
  42.         echo "<br>If there were no errors occurred during the install and all the content shown were green collored, please delete install.php from your server.";
  43. ?>
Latest pastes
Pills gen in behalf of patients. What side effects can this medication cause? cmvspnhcmgay
2 days ago
Undefined
9 days ago
Undefined
11 days ago
Undefined
21 days ago
Undefined
22 days ago

What's new | Credits | Contact