PHP Classes

File: schema.sql

Recommend this page to a friend!
  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: 22 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');