sql schema
Spiros Bolis
sbolis at freemail.gr
Mon Oct 21 23:48:56 EEST 2002
On Sun, 20 Oct 2002, Nikos Mavroyanopoulos wrote:
> Δεν υπαρχει καποιος με προσβαση στη database του lugistics
> για να μου στειλει το sql schema?
>
Ebala phpPgAdmin kai to stelnw sth lista gia na yparxei
----------------------------------------
Database lugistics
Table Owner Action Records Comments
active_sessions lug Browse Select Insert Properties Empty Drop Privileges 3
auth_user lug Browse Select Insert Properties Empty Drop Privileges 1
members lug Browse Select Insert Properties Empty Drop Privileges 158
news lug Browse Select Insert Properties Empty Drop Privileges 85
project lug Browse Select Insert Properties Empty Drop Privileges 23
qa_articles lug Browse Select Insert Properties Empty Drop Privileges 10985
qa_keywords lug Browse Select Insert Properties Empty Drop Privileges 136
qa_keywords_articles lug Browse Select Insert Properties Empty Drop Privileges 14389
sponsors lug Browse Select Insert Properties Empty Drop Privileges 7
sug_synonyms lug Browse Select Insert Properties Empty Drop Privileges 1
sug_words lug Browse Select Insert Properties Empty Drop Privileges 2
tmp_pg_shadow evris Browse Select Insert Properties Empty Drop Privileges 1
url lug Browse Select Insert Properties Empty Drop Privileges 89
url_type lug Browse Select Insert Properties Empty Drop Privileges 8
vocabulary lug Browse Select Insert Properties Empty Drop Privileges 840
voting_members lug Browse Select Insert Properties Empty Drop Privileges 824
voting_options lug Browse Select Insert Properties Empty Drop Privileges 64
voting_sessions lug Browse Select Insert Properties Empty Drop Privileges 9
voting_tickets lug Browse Select Insert Properties Empty Drop Privileges 147
----------------------------------------
Database lugistics - Table active_sessions
Field Type Length Not Null Default Action
sid varchar 32 Yes '' Change Drop Index Unique
name varchar 32 Yes '' Change Drop Index Unique
val text var No Change Drop Index Unique
changed varchar 14 Yes '' Change Drop Index Unique
----------------------------------------
Database lugistics - Table auth_user
Field Type Length Not Null Default Action
uid varchar 32 Yes Change Drop Index Unique
username varchar 32 Yes '' Change Drop Index Unique
password varchar 32 Yes '' Change Drop Index Unique
perms varchar 255 No Change Drop Index Unique
----------------------------------------
Database lugistics - Table members
Field Type Length Not Null Default Action
member_id int4 4 No Change Drop Index Unique
lname varchar 50 Yes Change Drop Index Unique
mname varchar 50 No Change Drop Index Unique
fname varchar 50 No Change Drop Index Unique
photo_ref varchar 100 No Change Drop Index Unique
descr_ref text var No Change Drop Index Unique
address varchar 255 No Change Drop Index Unique
tk varchar 255 No Change Drop Index Unique
city varchar 255 No Change Drop Index Unique
country varchar 255 No Change Drop Index Unique
email varchar 255 No Change Drop Index Unique
phone varchar 255 No Change Drop Index Unique
company varchar 255 No Change Drop Index Unique
member_from varchar 50 No Change Drop Index Unique
url varchar 255 No Change Drop Index Unique
active int4 4 No Change Drop Index Unique
passwd varchar 100 No Change Drop Index Unique
----------------------------------------
Database lugistics - Table news
Field Type Length Not Null Default Action
cid int4 4 Yes Change Drop Index Unique
proj_cid int4 4 Yes Change Drop Index Unique
dt datetime 8 No Change Drop Index Unique
title varchar 40 No Change Drop Index Unique
descr text var No Change Drop Index Unique
----------------------------------------
Database lugistics - Table project
Field Type Length Not Null Default Action
cid int4 4 Yes Change Drop Index Unique
name varchar 20 No Change Drop Index Unique
descr text var No Change Drop Index Unique
----------------------------------------
Database lugistics - Table project
Field Type Length Not Null Default Action
cid int4 4 Yes Change Drop Index Unique
name varchar 20 No Change Drop Index Unique
descr text var No Change Drop Index Unique
----------------------------------------
Database lugistics - Table qa_articles
Field Type Length Not Null Default Action
id int4 4 Yes Change Drop Index Unique
subject varchar 255 Yes Change Drop Index Unique
pathname varchar 255 Yes Change Drop Index Unique
----------------------------------------
Database lugistics - Table qa_keywords
Field Type Length Not Null Default Action
key_id int4 4 Yes Change Drop Index Unique
key_name varchar 100 Yes Change Drop Index Unique
----------------------------------------
Database lugistics - Table qa_keywords_articles
Field Type Length Not Null Default Action
article_id int4 4 Yes Change Drop Index Unique
key_id int4 4 Yes Change Drop Index Unique
----------------------------------------
Database lugistics - Table sponsors
Field Type Length Not Null Default Action
sponsor_id int4 4 No Change Drop Index Unique
company_name varchar 100 No Change Drop Index Unique
lname varchar 100 No Change Drop Index Unique
fname varchar 100 No Change Drop Index Unique
address varchar 255 No Change Drop Index Unique
tk varchar 255 No Change Drop Index Unique
city varchar 255 No Change Drop Index Unique
country varchar 50 No Change Drop Index Unique
banner varchar 255 No Change Drop Index Unique
url varchar 255 No Change Drop Index Unique
email varchar 255 No Change Drop Index Unique
phone varchar 255 No Change Drop Index Unique
fax varchar 255 No Change Drop Index Unique
description text var No Change Drop Index Unique
----------------------------------------
Database lugistics - Table sug_synonyms
Field Type Length Not Null Default Action
word_id int4 4 No Change Drop Index Unique
greek_w varchar 255 No Change Drop Index Unique
sug_date datetime 8 No Change Drop Index Unique
----------------------------------------
Database lugistics - Table sug_words
Field Type Length Not Null Default Action
engl_w varchar 255 No Change Drop Index Unique
greek_w varchar 255 No Change Drop Index Unique
sug_date datetime 8 No Change Drop Index Unique
----------------------------------------
Database lugistics - Table url
Field Type Length Not Null Default Action
cid int4 4 Yes Change Drop Index Unique
proj_cid int4 4 Yes Change Drop Index Unique
tp varchar 15 No Change Drop Index Unique
txt varchar 20 No Change Drop Index Unique
url text var No Change Drop Index Unique
----------------------------------------
Database lugistics - Table url_type
Field Type Length Not Null Default Action
tp varchar 15 Yes Change Drop Index Unique
txt text var Yes Change Drop Index Unique
icon text var No Change Drop Index Unique
----------------------------------------
Database lugistics - Table vocabulary
Field Type Length Not Null Default Action
word_id int4 4 No Change Drop Index Unique
engl_w varchar 255 No Change Drop Index Unique
greek_w varchar 255 No Change Drop Index Unique
----------------------------------------
Database lugistics - Table voting_members
Field Type Length Not Null Default Action
vid int4 4 Yes Change Drop Index Unique
member_id int4 4 Yes Change Drop Index Unique
has_voted int4 4 Yes Change Drop Index Unique
what_voted text var No Change Drop Index Unique
when_voted datetime 8 No Change Drop Index Unique
----------------------------------------
atabase lugistics - Table voting_options
Field Type Length Not Null Default Action
vid int4 4 Yes Change Drop Index Unique
option text var Yes Change Drop Index Unique
num_of_votes int4 4 Yes Change Drop Index Unique
option_id int4 4 Yes Change Drop Index Unique
----------------------------------------
Database lugistics - Table voting_sessions
Field Type Length Not Null Default Action
vid int4 4 Yes Change Drop Index Unique
theme text var Yes Change Drop Index Unique
dstart datetime 8 Yes Change Drop Index Unique
dend datetime 8 Yes Change Drop Index Unique
descr text var No Change Drop Index Unique
secret int4 4 Yes Change Drop Index Unique
num_of_options int4 4 Yes Change Drop Index Unique
active int4 4 Yes Change Drop Index Unique
----------------------------------------
Database lugistics - Table voting_tickets
Field Type Length Not Null Default Action
ticket_id int4 4 Yes Change Drop Index Unique
vid int4 4 Yes Change Drop Index Unique
when_voted datetime 8 Yes Change Drop Index Unique
text1 text var No Change Drop Index Unique
text2 text var No Change Drop Index Unique
what_voted text var Yes Change Drop Index Unique
----------------------------------------
An kapoios thelhsei prosbash sthn idia th bash as moy steilei mail, den
exei nohma na kanw post kati tetoio se dhmosia lista
Thn kalhnyxta moy se oloys
More information about the Lugistics-devel
mailing list