Home
randomname2
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (6)
user
id
increments
email
string
password
string
is_artist
tinyInteger
is_admin
tinyInteger
confirmed
tinyInteger
confirmation_code
string
fb_id
string
remember_token
string
(100)
updated_at
timestamp
created_at
timestamp
profession
id
increments
title
string
lang_code
string
association
id
increments
association
string
lang_code
string
profile
user_id
increments
language
integer
slug
string
image_id
integer
firstname
string
lastname
string
email
string
dob
date
phone
string
address
string
city
string
zip
string
country
string
(45)
IBAN
string
SWIFT
string
about_user_langcode
string
is_associated
integer
association
string
kuvataiteilijamatrikkeli
tinyInteger
is_mailsubscribed
string
profile_completed
string
commission
double
created_at
timestamp
updated_at
timestamp
artist_away
user_id
increments
awayDate
date
returnDate
date
created_at
timestamp
updated_at
timestamp
curriculum
user_id
increments
name
string
ext
string
original_filename
string
(45)
profile_evaluation
user_id
increments
in_evaluation
tinyInteger
status
string
created_at
timestamp
updated_at
timestamp
profession_user
user_id
integer
profession_id
integer
association_user
user_id
integer
association_id
integer
follow
follower_id
integer
followed_id
integer
image
id
increments
image_name
string
thumb_name
string
mime
string
bw
tinyInteger
artwork
id
increments
user_id
integer
category_id
integer
slug
string
price_range_id
integer
price
decimal
(9,3)
vat
integer
full_price
decimal
(9,3)
is_discounted
tinyInteger
discounted_by
tinyInteger
discount_percent
integer
views
integer
favorites
integer
is_active
tinyInteger
for_sale
tinyInteger
size_range_id
integer
orientation
integer
depth
double
width
double
height
double
weight
double
created_year
integer
copyright_owner
tinyInteger
is_hidden
tinyInteger
created_at
timestamp
updated_at
timestamp
published_at
timestamp
translation_description_code
string
translation_title_code
string
shipping
tinyInteger
favorites
user_id
integer
artwork_id
integer
category
id
increments
name
string
parent_id
integer
root_category_id
integer
lang_code
string
translation
id
increments
code
string
lang_id
integer
translation
text
language
id
increments
code
string
name
string
is_active
tinyInteger
sold_giftcard
id
increments
giftcard_Id
integer
payment_id
integer
code
string
(10)
transaction_id
string
(50)
sold_artwork
id
increments
payment_id
integer
artwork_id
integer
delivery_status
string
pick_up_address
string
pick_up_city
string
pick_up_zip
string
tracking_id
string
pdf_id
string
pick_up_date
date
delivery_date
date
created_at
timestamp
updated_at
timestamp
image_properties
image_id
integer
group_0
integer
group_1
integer
group_2
integer
group_3
integer
group_4
integer
hierarchy_color_0
double
(4,2)
hierarchy_color_1
double
(4,2)
hierarchy_color_2
double
(4,2)
hierarchy_color_3
double
(4,2)
hierarchy_color_4
double
(4,2)
bw
tinyInteger
curate
tinyInteger
color_palette
id
increments
HEX
string
color_group
integer
slug
string
name
string
artwork_keyword
artwork_id
integer
keyword_id
integer
artwork_theme
artwork_id
integer
theme_id
bigInteger
size_range
id
increments
name
string
lang_code
string
keywords
id
increments
en
string
fi
string
sv
string
curate
tinyInteger
created_at
timestamp
updated_at
timestamp
theme
id
increments
name
string
lang_code
string
artwork_image
artwork_id
integer
image_id
integer
is_primary
tinyInteger
password_resets
email
string
token
string
created_at
timestamp
price_range
id
increments
name
string
min
double
max
double
lang_code
string
billing_profile
id
increments
user_id
integer
country
string
firstname
string
lastname
string
company
string
companyId
string
address
string
lang_id
integer
address_additional
string
city
string
email
string
phone
string
zip
string
created_at
timestamp
updated_at
timestamp
payment
id
increments
shipping_profile_id
integer
billing_profile_id
integer
items
string
amount
string
discount_code
string
discount_percent
string
giftcard_code
string
giftcard_amount
integer
currency
string
method
string
status_code
string
status
string
processor
string
returnData
text
created_at
timestamp
updated_at
timestamp
giftcard
id
increments
billingProfileId
integer
name
string
price
double
user_id
integer
code
string
(6)
is_active
tinyInteger
valid_till
date
created_at
timestamp
updated_at
timestamp
to_print
tinyInteger
shipping_profile
id
increments
country
string
firstname
string
lastname
string
company
string
address
string
address_additional
string
city
string
email
string
phone
string
zip
string
order_notes
string
created_at
timestamp
updated_at
timestamp
discount_coupon
id
increments
code
string
percent
double
valid_till
date
is_active
tinyInteger
created_at
timestamp
updated_at
timestamp
log
user_id
integer
edited_by
integer
action
string
timestamp
timestamp
search_log
id
increments
query
string
created_at
timestamp
×
Comments for randomname2
Artur Gazizov . 15 September 2017
outside this editor
1.Check box earch mode "normal" in notepad++
Replace 'NULL' by NULL. and default('0') by default(NULL)
2.Make integers Primary in auxilary tables
3.Check box search mode "regular expression" in notepad++
uncheck box "matches line" before replacing.
replace
timestamps default values also replace in notepad++ in files
(timestamp.*);
by
\1->default\(NULL\);
Artur Gazizov . 15 September 2017
I renamed account table to user because "belongsTo" looks for account_id, not user_id. It follows not eloquent model name but name of table
Artur Gazizov . 15 September 2017
Probably will have to edit follow model relationships manually, cos it uses second column
Artur Gazizov . 15 September 2017
In seeder have to replace by ORM query, cos we use not many-to-many relationships between artwork and user
Artur Gazizov . 06 October 2017
while True :
import re,os
address='C:/Users/posoh/Taiko/services/database/migrations/'
listofpairs=[
"'NULL' NULL ".split(' ', 1 ) ,
"'0' NULL ".split(' ', 1 ) ,
"(timestamp.*); \g->default(NULL); ".split(' ', 1 ) ,
]
listoffiles = [f for f in os.listdir(address)]
for currentfilename in listoffiles:
path=(address+currentfilename)
with open(path, 'r') as file :
filedata = file.read()
for i in listofpairs:
filedata = re.sub(i[0],i[1].rstrip(),filedata)
with open(path, 'w') as file:
file.write(filedata)
break
#this script replaces wrong laravelsd nulls in exported model
Artur Gazizov . 06 October 2017
while True :
import re,os
address='C:/Users/posoh/Taiko/services/database/migrations/'
listofpairs=[
"'NULL' NULL ".split(' ', 1 ) ,
"'0' NULL ".split(' ', 1 ) ,
"(timestamp.*); \g->default(NULL); ".split(' ', 1 ) ,
]
listoffiles = [f for f in os.listdir(address)]
for currentfilename in listoffiles:
path=(address+currentfilename)
with open(path, 'r') as file :
filedata = file.read()
for i in listofpairs:
filedata = re.sub(i[0],i[1].rstrip(),filedata)
with open(path, 'w') as file:
file.write(filedata)
break
#this script replaces wrong laravelsd nulls in exported model
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01