File: schema.sql

# --------------------------------------------------------
# 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');