-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathpizzeriadb.doc
10 lines (9 loc) · 3.75 KB
/
pizzeriadb.doc
1
2
3
4
5
6
7
8
9
10
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40">
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-type" content="text/html;charset=utf-8" />
</head>
<body><h1>Database pizzeriadb</h1><h2>Table structure for table orders</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><strong>Type</strong></td><td class="print"><strong>Null</strong></td><td class="print"><strong>Default</strong></td></tr><tr class="print-category"><td class="print"><em><strong>orderID</strong></em></td><td class="print">int(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">orderSize</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">orderToppings</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">orderDate</td><td class="print">datetime</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">orderCondition</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">userID</td><td class="print">int(11)</td><td class="print">Yes</td><td class="print">NULL</td></tr></table><h2>Dumping data for table orders</h2><table class="width100" cellspacing="1"></table><h2>Table structure for table users</h2><table class="width100" cellspacing="1"><tr class="print-category"><th class="print">Column</th><td class="print"><strong>Type</strong></td><td class="print"><strong>Null</strong></td><td class="print"><strong>Default</strong></td></tr><tr class="print-category"><td class="print"><em><strong>userID</strong></em></td><td class="print">int(10)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">userFirstName</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">userLastName</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">userAddress</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">userPostalCode</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">userPhoneNumber</td><td class="print">int(11)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">userEmail</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr><tr class="print-category"><td class="print">userPassword</td><td class="print">int(11)</td><td class="print">No</td><td class="print"></td></tr><tr class="print-category"><td class="print">userRole</td><td class="print">varchar(50)</td><td class="print">Yes</td><td class="print">NULL</td></tr></table><h2>Dumping data for table users</h2><table class="width100" cellspacing="1"><tr class="print-category"><td class="print">1</td><td class="print">Hassan</td><td class="print">Nahhal</td><td class="print">123 </td><td class="print">N2D3E3</td><td class="print">0</td><td class="print">admin@admin</td><td class="print">12345</td><td class="print">employee</td></tr></table></body></html>