4,395
edits
Changes
→Structure
Line 6:
Line 6:
+<pre>+-- ===================================================================+--+-- This program is free software; you can redistribute it and/or modify+-- the Free Software Foundation; either version 2 of the License, or+-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the+-- along with this program; if not, write to the Free Software+-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.+--+-- $Id: llx_export_compta.sql,v 1.2 2005/01/03 09:58:09 rodolphe Exp $+--+-- $Revision: 1.2 $+ +create table llx_export_compta+(+ rowid integer AUTO_INCREMENT PRIMARY KEY,+ ref varchar(12) NOT NULL,+ date_export datetime NOT NULL, -- date de creation+ fk_user integer NOT NULL,+ note text+ +)type=innodb;+</pre>+
= Structure =
= Structure =
−{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
− |style="background-color: #e9e9ef"| <b>Field</b>
− |style="background-color: #e9e9ef"| <b>Type</b>
−-- Copyright (C) 2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
+ |style="background-color: #e9e9ef"| <b>Null</b>
− |style="background-color: #e9e9ef"| <b>Key</b>
− |style="background-color: #e9e9ef"| <b>Default</b>
−-- it under the terms of the GNU General Public License as published by
+ |style="background-color: #e9e9ef"| <b>Extra</b>
− |style="background-color: #e9e9ef"| <b>Description</b>
−-- (at your option) any later version.
+|-
−--
+| rowid
−-- This program is distributed in the hope that it will be useful,
+| int(11)
−-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+|
−| PRI
−-- GNU General Public License for more details.
+| NULL
−--
+| auto_increment
−-- You should have received a copy of the GNU General Public License
+| technical index
−|-
−| ref
−| varchar(12)
−|
−-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_export_compta.sql,v $
+|
−-- ===================================================================
+| NULL
−|
−|
−|-
−| date_export
−| datetime
−|
−|
−| NULL
−|
−|
−|-
−| fk_user
−| int(11)
+|
+|
+| NULL
+|
+|
+|-
+| note
+| text
+|
+|
+| NULL
+|
+|
+|}