Changes between Version 16 and Version 17 of oid/WorkLog/08-10-15

Timestamp:

Oct 15, 2008, 3:50:34 PM (16 years ago)

Author:

jazz

Comment:

--

oid/WorkLog/08-10-15

@@ -74 +74 @@
  * [工具] [http://www.lightbox.ca/pg2mysql.php pg2mysql converter (PostgreSQL to MySQL Converter)]
  * [參考] [http://forums.mysql.com/read.php?83,128328,226468#msg-226468 遇到 triggers , sequences , domain 這幾個差異時就沒輒了]
+ * 原始 account Table 表
 {{{
-jazz@oceandb:~$ wget http://www.lightbox.ca/pg2mysql-1.2.tar.bz2
-jazz@oceandb:~$ tar jxvf pg2mysql-1.2.tar.bz2
-jazz@oceandb:~$ cd pg2mysql-1.2/
-jazz@oceandb:~/pg2mysql-1.2$ sudo apt-get install php5-cli
-jazz@oceandb:~/pg2mysql-1.2$ 
+--
+-- PostgreSQL database dump
+--
+
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = off;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET escape_string_warning = off;
+
+SET search_path = public, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = true;
+
+--
+-- Name: account; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE TABLE account (
+    serial smallint DEFAULT nextval(('account_seq'::text)::regclass) NOT NULL,
+    name character varying(10) NOT NULL,
+    tel character varying(20) NOT NULL,
+    fax character varying(20),
+    mail character varying(20),
+    department character varying(20) NOT NULL,
+    unit character varying(20) NOT NULL,
+    title character varying(20),
+    admin boolean NOT NULL,
+    account character varying(20) NOT NULL,
+    password character varying(20) NOT NULL
+);
+
+
+ALTER TABLE public.account OWNER TO postgres;
 }}}
-   * 轉出來的結果有錯，因為有用到 sequence (序列)
+   * 經 pg2mysql 轉出來的結果有錯，因為有用到 sequence (序列)
 {{{
 #!diff