File: test_20_1.sql

package info (click to toggle)
mysql-gui-tools 5.0r12-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 105,540 kB
  • ctags: 50,897
  • sloc: sql: 348,439; pascal: 285,780; cpp: 94,578; ansic: 90,768; objc: 33,761; sh: 25,629; xml: 10,924; yacc: 10,755; java: 9,986; php: 2,806; python: 2,068; makefile: 1,945; perl: 3
file content (12 lines) | stat: -rw-r--r-- 570 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
 
CREATE DATABASE IF NOT EXISTS `ma_tests` /*!40100 DEFAULT CHARACTER SET utf8 */;

DROP TABLE IF EXISTS `ma_tests`.`dbm_test`;
CREATE TABLE  `ma_tests`.`dbm_test` (
  `id_dbm_test` int(10) unsigned NOT NULL auto_increment COMMENT 'id column',
  `name` varchar(45) NOT NULL default 'Tom' COMMENT 'test',
  `date_test` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `rating` int(10) unsigned NOT NULL default '12',
  `test1` varchar(45) NOT NULL default 'test',
  `test2` varchar(45) default NULL,
  PRIMARY KEY  (`id_dbm_test`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;