Advanced Search

Comments tabel in Cakephp

/ Published in: PHP
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE TABLE surdeig_comments (
  2. 	id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  3. 	ref_url VARCHAR(200),
  4. 	author VARCHAR(200),
  5. 	email VARCHAR(100),
  6. 	url VARCHAR(200),
  7. 	ip VARCHAR(200),
  8. 	body TEXT,
  9. 	approved tinyint(1),
  10. 	agent VARCHAR(250),
  11. 	tag VARCHAR(50),
  12. 	user_id int,
  13. 	created DATETIME DEFAULT NULL,
  14. 	modified DATETIME DEFAULT NULL
  15. ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.