- PHP MAKER LOCALHOST PREVIEW INSTALL
- PHP MAKER LOCALHOST PREVIEW UPDATE
- PHP MAKER LOCALHOST PREVIEW CODE
View the definition of each column below.
PHP MAKER LOCALHOST PREVIEW CODE
The above SQL code will create the tickets and tickets_comments table. The data that we insert into the tickets and tickets_comments tables will be for testing purposes. INSERT INTO `tickets_comments` (`id`, `ticket_id`, `msg`, `created`) VALUES (1, 1, 'This is a test comment.', ' 16:23:39') INSERT INTO `tickets` (`id`, `title`, `msg`, `email`, `created`, `status`) VALUES (1, 'Test Ticket', 'This is your first ticket.', ' 13:06:17', 'open') ĬREATE TABLE IF NOT EXISTS `tickets_comments` ( ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 `status` enum('open','closed','resolved') NOT NULL DEFAULT 'open', `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, SQL Copy CREATE TABLE IF NOT EXISTS `tickets` ( While the database is selected, click the SQL tab and execute the following statement:
Creating the Database and setting-up Tables
PHP MAKER LOCALHOST PREVIEW UPDATE
PHP MAKER LOCALHOST PREVIEW INSTALL