Advertisement
OKIEWARDOYO

PHP MYSQL No.10 - install_sql.sql

Aug 27th, 2012
2,546
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.60 KB | None | 0 0
  1. SET NAMES 'utf8';
  2. DROP TABLE IF EXISTS `metu_builder`;
  3.  
  4. CREATE TABLE `metu_builder` (
  5. `ID` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  6. `page` VARCHAR( 30 ) NOT NULL ,
  7. `column` INT( 10 ) NULL,
  8. `block_title` VARCHAR( 30 ) NULL,
  9. `order` int ( 10 ) NULL
  10. ) ENGINE = MYISAM DEFAULT CHARSET=utf8;
  11.  
  12. INSERT INTO `metu_builder` (`ID`, `page`, `column`,`block_title`,`order`) VALUES
  13. (1, 'home', '1', 'Promo', '1'),
  14. (2, 'home', '1', 'Blogs', '2'),
  15. (3, 'home', '2',  'Members', '1'),
  16. (4, 'home', '2', 'Mediatutorial', '2'),
  17. (5, 'account', '1', 'Status Text', '1'),
  18. (6, 'account', '2', 'Profile Detail', '1');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement