nopaste
HomeAll pastesPopular pastesRecent pastes

Public paste
Database Final!
By: Xmoo | Date: Jan 28 2009 08:08 | Format: PHP | Expires: never | Size: 1.72 KB | Hits: 872
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 date(255) NOT NULL,
  10.  tijd time(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 date(255) NOT NULL,
  22.  vtijd time(255) NOT NULL,
  23.  aantal varchar(255) NOT NULL,
  24.  tdatum date(255) NOT NULL,
  25.  ttijd time(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 date(255) NOT NULL,
  36.  vtijd time(255) NOT NULL,
  37.  tdatum date(255) NOT NULL,
  38.  ttijd time(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
Мешки для мусора
2 hours ago
1xbet i66fzn
1 days ago
Установка брекетов
1 days ago
Telegram USA 202 503 9187 LEGIT Funds Zelle Paypal Bank Cashapp Bank WU Clone Card and ATM cvv dumps Fullz prepaid cards load up clear all Criminal R
2 days ago
Мешки для мусора
3 days ago

What's new | Credits | Contact