PHP Classes
elePHPant
Icontem

File: schema.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Tobie van der Spuy  >  MySQL Form Generator  >  schema.sql  >  Download  
File: schema.sql
Role: Auxiliary data
Content type: text/plain
Description: Example Table SQL
Class: MySQL Form Generator
Generate forms to edit data in MySQL tables
Author: By
Last change:
Date: 13 years ago
Size: 1,821 bytes
 

Contents

Class file image Download
# --------------------------------------------------------
# Template MySQL Database for the MySQL Form Generator Class
# --------------------------------------------------------

# --------------------------------------------------------
# Create a new database to host these tables, or just create them in an existing database!
# --------------------------------------------------------
# Remember to update the example.php files with your own DB values!
# --------------------------------------------------------
# User: guest
# Password: guest
# Host: localhost
# Database : mfgc
# --------------------------------------------------------

# --------------------------------------------------------
# Table structure for table 'table1'
# --------------------------------------------------------

CREATE TABLE table1 (
   id int(11) auto_increment NOT NULL,
   t1_name varchar(50) NOT NULL,
   t1_description text NOT NULL,
   t1_extra int(8) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id)
);

# --------------------------------------------------------
# Dumping data for table 'table1'
# --------------------------------------------------------

INSERT INTO table1 VALUES ( '1', 'First Row!', 'This is the first row in the Table1 database!', '23');

# --------------------------------------------------------
# Table structure for table 'table2'
# --------------------------------------------------------

CREATE TABLE table2 (
   id int(11) NOT NULL,
   t1_surname varchar(50) NOT NULL,
   t1_active enum('Y','N') DEFAULT 'Y' NOT NULL,
   PRIMARY KEY (id)
);

# --------------------------------------------------------
# Dumping data for table 'table2'
# --------------------------------------------------------

INSERT INTO table2 VALUES ( '1', 'First Row Surname!', 'Y');