Revision 15079,
1.1 KB
checked in by nanasess, 17 years ago
(diff) |
svn:mime-type application/x-httpd-php; charset=UTF-8 設定
|
-
Property svn:mime-type set to
application/x-httpd-php; charset=UTF-8
|
Line | |
---|
1 | CREATE TABLE dtb_campaign_order (
|
---|
2 | campaign_order_id int auto_increment primary key NOT NULL,
|
---|
3 | order_id int DEFAULT 0,
|
---|
4 | campaign_id int NOT NULL,
|
---|
5 | customer_id int NOT NULL,
|
---|
6 | message text,
|
---|
7 | order_name01 text,
|
---|
8 | order_name02 text,
|
---|
9 | order_kana01 text,
|
---|
10 | order_kana02 text,
|
---|
11 | order_email text,
|
---|
12 | order_tel01 text,
|
---|
13 | order_tel02 text,
|
---|
14 | order_tel03 text,
|
---|
15 | order_fax01 text,
|
---|
16 | order_fax02 text,
|
---|
17 | order_fax03 text,
|
---|
18 | order_zip01 text,
|
---|
19 | order_zip02 text,
|
---|
20 | order_pref text,
|
---|
21 | order_addr01 text,
|
---|
22 | order_addr02 text,
|
---|
23 | order_sex smallint,
|
---|
24 | order_birth datetime,
|
---|
25 | order_job int,
|
---|
26 | deliv_name01 text,
|
---|
27 | deliv_name02 text,
|
---|
28 | deliv_kana01 text,
|
---|
29 | deliv_kana02 text,
|
---|
30 | deliv_tel01 text,
|
---|
31 | deliv_tel02 text,
|
---|
32 | deliv_tel03 text,
|
---|
33 | deliv_fax01 text,
|
---|
34 | deliv_fax02 text,
|
---|
35 | deliv_fax03 text,
|
---|
36 | deliv_zip01 text,
|
---|
37 | deliv_zip02 text,
|
---|
38 | deliv_pref text,
|
---|
39 | deliv_addr01 text,
|
---|
40 | deliv_addr02 text,
|
---|
41 | payment_total numeric,
|
---|
42 | create_date datetime NOT NULL
|
---|
43 | ) TYPE=InnoDB ; |
---|
Note: See
TracBrowser
for help on using the repository browser.