File: sqlfxml-producer-basic.sql

package info (click to toggle)
libsql-translator-perl 0.11011-1
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 15,380 kB
  • sloc: perl: 251,748; sql: 3,805; xml: 233; makefile: 7
file content (20 lines) | stat: -rw-r--r-- 414 bytes parent folder | download | duplicates (10) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
-- 
-- Created by SQL::Translator::Producer::MySQL
-- Created on Thu Aug  7 16:28:01 2003
-- 
-- SET foreign_key_checks=0;

--
-- Table: Basic
--
CREATE TABLE Basic (
    -- comment on id field
    id integer(10) NOT NULL auto_increment
   ,title varchar(100) NOT NULL DEFAULT 'hello'
   ,description text DEFAULT ''
   ,email varchar(255)
   ,INDEX  titleindex (title)
   ,PRIMARY KEY (id)
   ,UNIQUE (email)
);