File: test_20_1.sql

package info (click to toggle)
mysql-admin 1.2.5rc-2
  • links: PTS
  • area: main
  • in suites: etch, etch-m68k
  • size: 80,944 kB
  • ctags: 43,103
  • sloc: sql: 295,916; pascal: 256,535; cpp: 74,487; ansic: 68,881; objc: 26,417; sh: 16,867; yacc: 10,755; java: 9,917; xml: 8,453; php: 2,806; python: 2,068; makefile: 1,252; 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;