File: test_60_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 (11 lines) | stat: -rw-r--r-- 340 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
 
CREATE DATABASE IF NOT EXISTS `ma_tests` /*!40100 DEFAULT CHARACTER SET utf8 */;

use ma_tests;
DROP TABLE IF EXISTS `foo`;
CREATE TABLE  `ma_tests`.`foo` (
  `idfoo` int(10) unsigned NOT NULL auto_increment,
  `col1` year(4) NOT NULL,
  `col2` char(4) NOT NULL,
  PRIMARY KEY  (`idfoo`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;